Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => ReportNet Administration => Topic started by: hybridE4t on 06 Jul 2006 04:36:49 AM

Title: Where does Reportnet store users' email addreses?
Post by: hybridE4t on 06 Jul 2006 04:36:49 AM
Hello,

Any idea where Reportnet stores the email address that a user puts in their Reportnet Preferences -> Personal tab? And if the address is stored then if they are in a useable format or not? We are on SQL Server but I assume that the user tables Cognos creates will be at least vaguely similar regardless of the database...

Thanks, Marc
Title: Re: Where does Reportnet store users' email addreses?
Post by: hybridE4t on 06 Jul 2006 08:22:37 AM
...or where their CAMID is stored (in the database). I guess that would do the trick instead.

Thanks - Marc
Title: Re: Where does Reportnet store users' email addreses?
Post by: cognosfreelancer on 06 Jul 2006 12:05:48 PM
Their CAMID is stored in the content store database.

HTH

NKT
Title: Re: Where does Reportnet store users' email addreses?
Post by: hybridE4t on 10 Jul 2006 05:12:32 AM
Yes but where in this database? Or is this setup specific?
Title: Re: Where does Reportnet store users' email addreses?
Post by: cognosfreelancer on 10 Jul 2006 08:08:11 AM
Unfortunately Cognos maintains that the database schema is proprietary (in other words none of the customer's concern).

Therefore there is no documentation on what is stored in each tables or a guarantee that the schema will not change from release to release.

Having said that I discovered that CAMIDs are stored in the content store while debugging a security issue.

I am sorry I do not recall where.

NKT
Title: Re: Where does Reportnet store users' email addreses?
Post by: hybridE4t on 24 Jul 2006 11:00:57 AM
Resolved on justcog<dot>com. Thanks.
Text only | Text with Images