Query Details

Domain Admins Enterprise Admins

Query

//New Domain Admins and Enterprise Admins

Event
| where TimeGenerated > ago(7d)
| extend eventData=parse_json(EventData)
| project TimeGenerated, Computer, EventID, eventData.MemberName, eventData.SubjectDomainName, eventData.SubjectUserName, eventData.TargetUserName
| where eventData_TargetUserName == "Domain Admins" or eventData_TargetUserName == "Enterprise Admins"

Explanation

This query looks for events that occurred in the last 7 days and retrieves information about new domain admins and enterprise admins. It includes the time the event was generated, the computer involved, the event ID, the member name, the subject domain name, the subject username, and the target username. It filters the results to only include events where the target username is either "Domain Admins" or "Enterprise Admins".