Author Topic: Cognos Audit Username vs Login Username  (Read 263 times)

Offline redspark

  • Associate
  • **
  • Join Date: Sep 2018
  • Posts: 3
  • Forum Citizenship: +0/-0
Cognos Audit Username vs Login Username
« 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.


Offline redspark

  • Associate
  • **
  • Join Date: Sep 2018
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Cognos Audit Username vs Login Username
« Reply #1 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.

 


       
Twittear