I came across this slick KB article on how to get the list of active sessions/users currently on any cognos environment and implemented it. https://www-304.ibm.com/support/docview.wss?uid=swg21385278 After I got this to work the servlet that runs only retrieves the CAMID and the session start time. I started looking around in the content store tables and was able to successfully retrieve the CAMID and the associated LDAP ID/User ID. I made this a query subject in the Audit model and joined it to the security groups table and created a report that will give me User ID, CAMID, AD Group, Name , Email. Query : SELECT distinct ldap_id, last_name, first_name, email, objid as CAMID FROM (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id, c1.surname last_name, c1.givenname first_name, c1.email email, c1.objid FROM cmobjprops1 c1 LEFT OUTER JOIN cmobjprops33 c33 ON c33.cmid = c1.cmid
Comments
Post a Comment