Hi guys,
I have Cognos 8.2 installed on windows 2003 with IIS 6 as webserver. I need to trace the users, for example i have few clients who have access to our cognos reports, i need to when they logged in ..? how many times they logged in..? ...any information like their machine IP...? is that possible..?
Many thanks
Check out the Cognos Audit package. It has lots of information like that.
Here are some info for you if you are user Oracle as content store
List of users
SELECT cmobjprops1.cmid, cmobjprops1.busphone, cmobjprops1.email,
cmobjprops1.faxphone, cmobjprops1.givenname, cmobjprops1.homephone,
cmobjprops1.mobilephone, cmobjprops1.pagerphone,
cmobjprops1.paddress, cmobjprops1.surname, cmobjprops1.TIMEZONE,
cmobjprops1.clocaleid, cmobjprops1.prodlocale, cmobjprops1.objid,
cmobjprops1.useaccessibility, cmobjprops33.cmid AS cmid1,
UPPER (cmobjprops33.NAME)
FROM cmobjprops1, cmobjprops33
WHERE cmobjprops1.cmid = cmobjprops33.cmid
List of reports executed
SELECT UPPER (u.cogipf_username), dlu.lastname, dlu.firstname,
r.cogipf_sessionid, r.cogipf_localtimestamp,
dba_get_packagename (UPPER (r.cogipf_package)),
UPPER (r.cogipf_model),
dba_get_reportname (UPPER (r.cogipf_reportname))
FROM cogipf_runreport r, cogipf_userlogon u, dba_ldap_user dlu
WHERE r.cogipf_sessionid = u.cogipf_sessionid(+)
AND UPPER (u.cogipf_username) = dlu.ldap_id(+)
AND u.cogipf_username IS NOT NULL
AND r.cogipf_package IS NOT NULL
Let me know if this helped you