Queries for the AlertEvidence table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Alerts involving a user

List 100 alerts involving a certain user.

let userID = "<inert your AAD user ID>";
let userSid = "<inert your user SID>";
AlertEvidence
| where EntityType == "User" and (AccountObjectId == userID or AccountSid == userSid )
| join AlertInfo on AlertId
| project Timestamp, AlertId, Title, Category , Severity , ServiceSource , DetectionSource , AttackTechniques, AccountObjectId, AccountName, AccountDomain , AccountSid  
| limit 100