Saviynt Query Portal

All Modules

ARS Requests ARS Tasks Accounts Accounts, Endpoint Accounts, Endpoints Analytics Audit Logs Audit Trail Campaign Certification Connections Connections, Job Control Panel Endpoints Job Control Panel Roles Rules Security Systems User Group Users Users, Accounts Users, Accounts, Endpoint Users, Entitlements Users, Roles Users, SAV ROLES

Job Logs for a specific Job executed

Module: Audit Logs

Description

Gets audit log records for the specific job executed within the specified recent time window.

Dynamic Input

Job Name

Execute in

Analytics

SQL Query

SELECT
ua.TYPEOFACCESS AS 'Object Type',
ua.ActionType AS 'Action Taken',
u.username AS 'Modified By',
ua.IPADDRESS AS 'IP Address',
ua.ACCESSTIME AS 'Change Timestamp',
ua.DETAIL AS 'Change Details'
FROM users u, userlogin_access ua, userlogins l
WHERE l.loginkey = ua.LOGINKEY
AND l.USERKEY = u.userkey
AND ua.AccessTime >= (NOW() - INTERVAL 86400 MINUTE)
AND ua.TYPEOFACCESS = 'JOB_CONTROL'
AND ( ua.DETAIL LIKE '%PROVISIONING_JOB_NEW_ACCOUNT%' OR ua.DETAIL LIKE '%jobname:PROVISIONING_JOB_NEW_ACCOUNT%' OR ua.DETAIL LIKE '%triggername:PROVISIONING_JOB_NEW_ACCOUNT%' OR ua.DETAIL LIKE '%trigerName:PROVISIONING_JOB_NEW_ACCOUNT%' )
ORDER BY ua.ACCESSTIME DESC;

Comments

nan

Query copied!