COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: redspark on 02 Oct 2019 07:25:45 AM

Title: Cognos Audit Username vs Login Username
Post by: redspark on 02 Oct 2019 07:25:45 AM
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.

Title: Re: Cognos Audit Username vs Login Username
Post by: redspark on 03 Oct 2019 08:41:33 AM
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.