Modules

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

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 100 DAY)
AND ua.Detail IS NOT NULL
AND ua.TYPEOFACCESS LIKE '%users%';