Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/02/2024 08:42 AM
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.
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
07/02/2024 10:48 AM
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 |
07/04/2024 09:19 AM
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?.
07/04/2024 09:26 AM
There is no foreign key get information from userlogin_access table
07/04/2024 10:09 AM
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?.
07/04/2024 04:32 PM
There is no master table for object. Key and object name . Currently object name is not populated in temp table.