We need to fetch reports data for various Object Type, Action performed and accessed by, that is shown in the Saviynt Audit trail section under
Admin > Admin Functions > Audit Trail.
Below Screenshot shows how it looks in UI.
I tried to see the tables under Data analyzer but couldn't find any tables that gives relevant data to these audit trail. Can you help us how we can generate report and schedule such report which will consists of Audit trail information for all the events in Saviynt?
Thanks and Regards,
Solved! Go to Solution.
Please check if below query helps you
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