User Last Login Time from Content Store Table

[mrcool]

Hi All,

Could someone help me by sending the sql from Cognos Audit package which provides the usernames and their last login time?
If you can provide me the table which has login time I will work out on last login time.

Thanks,
MC

[adam_mc]

We use the COGIPF_USERLOGON table from the Audit Database where COGIPF_LOGON_OPERATION= 'Logon'

So SQL is something like:

select * from AUDITDB.COGIPF_USERLOGON where COGIPF_LOGON_OPERATION= 'Logon'

Hope this helps!

[mrcool]

Thanks Adam..
Is there any other alternative to find these details without Audit Database?

Thanks,
MC