Cognos User list

[konesens]

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

[TheCognosDave]

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 !  ;)