COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: konesens on 20 Nov 2013 09:13:46 PM

Title: Cognos User list
Post by: konesens on 20 Nov 2013 09:13:46 PM
Hello,

I need to create a prompt User list , in order to give administrator the ability to open reports on behalf of other users.
For instance administrator can check what every users see
Do you know how I can get the user list ?
Thanks
Title: Re: Cognos User list
Post by: TheCognosDave on 25 Nov 2013 01:31:54 PM
I did this by querying the Cognos metadata as follows:

SELECT DISTINCT B.Name as UserName
FROM C1011_ContentStore_64.dbo.CMOBJPROPS33 B
WHERE B.Name is not null

Good Luck !  ;)