NrAuditEvent: 쿼리 계정 감사 로그

SELECT * 
FROM NrAuditEvent 
SINCE 1 day ago

SELECT count(*) AS Actions 
FROM NrAuditEvent 
FACET actionIdentifier 
SINCE 1 week ago

SELECT actorEmail, actorId, targetId 
FROM NrAuditEvent 
WHERE actionIdentifier = 'account.create' 
SINCE 1 month ago

SELECT count(*) 
FROM NrAuditEvent 
TIMESERIES facet actionIdentifier since 1 week ago

SELECT * 
FROM NrAuditEvent 
WHERE targetType = 'user' 
SINCE this month

SELECT * FROM NrAuditEvent 
WHERE targetType = 'user' 
  AND actionIdentifier IN ('user.self_upgrade', 'user.change_type') 
SINCE this month

SELECT count(*) FROM NrAuditEvent 
WHERE actionIdentifier = 'synthetics_monitor.update_script' 
FACET actionIdentifier, description, actorEmail 
SINCE 1 week ago LIMIT 1000

SELECT timestamp, actorEmail, actorType, description, targetId 
FROM NrAuditEvent 
WHERE targetType = 'workload' 
SINCE 1 week ago LIMIT MAX

SELECT uniques(targetType)
FROM NrAuditEvent
SINCE 90 days ago

SELECT actionIdentifier, description, actorEmail, actorId, targetType, targetId 
FROM NrAuditEvent 
WHERE actorType = 'user' 
SINCE 1 week ago

SELECT actionIdentifier 
FROM NrAuditEvent 
WHERE actorId = 829034 SINCE 1 week ago

SELECT count(*) as Users 
FROM NrAuditEvent 
WHERE actorType = 'user' 
FACET actorEmail SINCE 1 week ago

SELECT count(*) FROM NrAuditEvent 
WHERE actionIdentifier = 'synthetics_monitor.update_script' 
FACET actorEmail, actionIdentifier, description 
SINCE 1 week ago LIMIT 1000

SELECT actionIdentifier, description, targetType, targetId, actorAPIKey, actorId, actorEmail 
FROM NrAuditEvent 
WHERE actorType = 'api_key' 
SINCE 1 week ago