How to trace users..?

[shri]

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

[COGNOiSe administrator]

Check out the Cognos Audit package. It has lots of information like that.

[megatrack67]

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