GraphAPIAuditEvents App Enrichment AADNonInteractiveUserSignInLogs Based
Description
This query enriches the GraphAPIAuditEvents with Application information from the AADNonInteractiveUserSignInLogs table to get more context in the results.
This query does have a limitation, a user must have signed in to the application to show up in the logs. An alternative KQL query is available that leverages the externaldata operator to solve this issue: GraphAPIAuditEvents App Enrichment ExternalData
Query · kql
let ApplicationName = AADNonInteractiveUserSignInLogs | where TimeGenerated > ago(30d) | summarize arg_max(TimeGenerated, *) by ResourceIdentity | project-rename ApplicationName = ResourceDisplayName | distinct ApplicationName, ResourceIdentity; GraphAPIAuditEvents // Your filter here | lookup kind=leftouter ApplicationName on $left.ApplicationId == $right.ResourceIdentity | project-reorder ApplicationId, ApplicationName