​​Hello,

Does anyone know how/where to pull in the 'username' for the 'User Logon Failures' table? 

The only fields in the table are:
Login Failure Time, Login failure time timezone offset, loon failure date, logon failure hour, logon failure quarter hour, operations.

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------

#CognosAnalyticswithWatson

Hi Jen,
which data connection do you use to see the user logon table? Is it the audit package from the IBM samples?
The username should be there as it is a column of the table in the audit data base:


------------------------------
Robert Dostal
Team Leader BI
GEMÜ
Ingelfingen
------------------------------

Original Message:
Sent: Thu June 17, 2021 08:53 AM
From: Jenifer Broughton
Subject: Audit Package - User Logon Failures

​​Hello,

Does anyone know how/where to pull in the 'username' for the 'User Logon Failures' table? 

The only fields in the table are:
Login Failure Time, Login failure time timezone offset, loon failure date, logon failure hour, logon failure quarter hour, operations.

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------

#CognosAnalyticswithWatson

Hi Jenifer,
The username is not stored in the [Audit].[User Logon Failures] table. Which in fact is the "COGIPF_USERLOGON" table. You could add the query item [COGIPF_USERLOGON_FAILURES].[ERROR DETAILS] to your query to get more information.


------------------------------
Thomas van der Meer
------------------------------

Original Message:
Sent: Thu June 17, 2021 08:53 AM
From: Jenifer Broughton
Subject: Audit Package - User Logon Failures

​​Hello,

Does anyone know how/where to pull in the 'username' for the 'User Logon Failures' table? 

The only fields in the table are:
Login Failure Time, Login failure time timezone offset, loon failure date, logon failure hour, logon failure quarter hour, operations.

Thanks,
Jen

------------------------------
Jenifer Broughton
------------------------------

#CognosAnalyticswithWatson