We are not able to view the audit logs for all the actions for schedulers under Audit Trail

[kumar99]

We have identified the cause of your issue.  For your convenience, we're including a summary of key details below.

Issue: We are not able to view the audit logs for all the actions for schedulers under Audit Trail

Problem: Unable to view the audit logs in the UI.

Action Taken:

The following tables have the required audit data in it.

• userlogins_temp
• userlogin_access_temp

Please let us know the columns which we have to select for getting the data from the above tables.

Two separate analytics need to be created in order to fetch the relevant data from queries. 

Please note, the following tables are not exposed in the data analyzer and also the data analyzer only returns the first 100 records at any given point in time.

Thanks and Regards,

Kumar

[rushikeshvartak]

Refer 

TABLE_NAME	COLUMN_NAME
userlogins_temp	LOGINKEY
userlogins_temp	LOGINTIME
userlogins_temp	LOGOUTDATE
userlogins_temp	USERKEY
userlogins_temp	IPADDRESS
userlogins_temp	ISANONYMOUS
userlogins_temp	COMMENTS

TABLE_NAME	COLUMN_NAME
userlogin_access_temp	USERLOGIN_ACCESSKEY
userlogin_access_temp	ACCESSTIME
userlogin_access_temp	ACCESS_URL
userlogin_access_temp	IPADDRESS
userlogin_access_temp	LOGINKEY
userlogin_access_temp	REMOTEAHOST
userlogin_access_temp	DETAIL
userlogin_access_temp	QUERY_PARAM
userlogin_access_temp	TYPEOFACCESS
userlogin_access_temp	ACTIONTYPE
userlogin_access_temp	OBJECTKEY
userlogin_access_temp	OBJECT_ATTRIBUTE_NAME
userlogin_access_temp	EVENT_ID
userlogin_access_temp	NEW_VALUE
userlogin_access_temp	OLD_VALUE

[AS5278]

@rushikeshvartak 

Hi, From the above schema of table 'userlogin_access_temp' we can get all the required columns for the report, but how do we fetch the 'ObjectName'?. I can see that there is the 'ObjectKey' column available. Can this be used somehow to get the corresponsing ObjectName?.

[rushikeshvartak]

There is no foreign key get information from userlogin_access table 

[AS5278]

@rushikeshvartak 

There is no foreign key get information from userlogin_access table : Do you mean the 'userlogin_access' table has the 'ObjectName' column and 'userlogin_access_temp' table does not?. The Schema would be same for these two tables I believe.

<OR>

Do you mean  that we cannot fetch the 'Object Name' column in the audit trail report because the table userlogin_access_temp / userlogin_access does not have the foreign key?.

[rushikeshvartak]

There is no master table for object. Key and object name . Currently object name is not populated in temp table.