Query to get Audit logs for past two hours

[yeddulanaveen]

Hi Team,

We need a query for getting the audit logs of Saviynt for every 2 hours. Whenever the analytics run the audit logs should be generated only for the past 2 hours. Currently the analytics for audit logs fetches data from 00:00 only.

Regards,

Naveen

[rushikeshvartak · Accepted solution]

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 120 Minute) and ua.Detail is not NULL