Cognos Audit Username vs Login Username

[redspark]

Hi,

I'm sorry if this is the wrong forum for Audit questions but I thought Admin was the proper spot.  In the Audit database, the Username is actually the person's real name. All of our reporting database data is based on a user's login username and we would like to connect the audit data to our reporting data. Is there a way to find their Login username from the Audit database?  Thanks.

[redspark]

Well, I figured this out myself.  There is a field in the Audit table COGIPF_USERLOGON called USERID that contains the user's account.  However it is not added to the base Audit FM project.  So I added it and it works.