Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Table name and details for Audit Trail

yogesh2
New Contributor III
New Contributor III

We want to create an analytics report with the same information that is shown in Audit Trail page below:

Can you please share the table/column names for the data shown on this page?

yogesh2_0-1713850827436.png

 

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

select ua.TYPEOFACCESS as 'Object Type',ua.ActionType as 'Action Taken',u.username as 'Accessed By', ua.IPADDRESS as 'IP Address',ua.ACCESSTIME as 'Event Time',ua.DETAIL as 'Message' from users u , userlogin_access ua, userlogins l where l.loginkey = ua.LOGINKEY and l.USERKEY = u.userkey and ua.AccessTime >= (NOW() - INTERVAL 90 Minute) and ua.Detail is not NULL


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Manu269
All-Star
All-Star

Refer : 

Solved: Saviynt Audit Trail report generation - Saviynt Forums - 40958

Solved: API endpoint to pull audit trail log data? - Saviynt Forums - 42214

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.