COGNOiSe.com - The IBM Cognos Community

Is there an easy way to find how a user has been setup and what roles/groups they have been put in in Cognos?

hi ,

Just run the following script in your content store.

SELECT      v_group.name AS group_name,                                  
         v_user.ldap_id AS user_name                              
FROM      dbo.cmreford1 AS v_group_user                                  
JOIN      (SELECT      cmid user_id,                            
                  UPPER (NAME) ldap_id                      
         FROM      dbo.cmobjprops33) v_user                        
ON         v_group_user.refcmid = v_user.user_id                               
JOIN      (SELECT      cmobjnames.cmid cmid,                            
                  UPPER(cmobjnames.NAME) name                      
         
         FROM      dbo.cmobjects, dbo.cmobjnames                        
         WHERE      cmobjects.classid IN (26, 54)                         
                  AND cmobjnames.mapdlocaleid = 96                     
                  AND cmobjects.cmid = cmobjnames.cmid) v_group                      
      ON         v_group.cmid = v_group_user.cmid