Bert-Jan Pals unknown stable kql
List the external admin activities
This query lists all the external admin activities in your tenant sorted from the account with the most actions performed to the one with the least actions.
Detection Logic
CloudAppEvents
| where IsExternalUser == 1 and AccountType == "Admin"
| summarize
TotalActivities = count(),
ActionsPerformed = make_set(ActionType),
Applications = make_set(Application),
IPsUsed = make_set(IPAddress)
by AccountId
| sort by TotalActivities Field Validations
Loading…
Comments (0)
Loading comments...