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.

View Source

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...