First-Contact External Teams Senders
Description
This query lists external Microsoft Teams senders by the date they were first seen, surfacing recent first-contact senders.
Query · kql
//This query lists external Microsoft Teams senders by the date they were first seen over the last 30 days, surfacing recent first-contact senders. MessageEvents | where Timestamp > ago(30d) | summarize FirstTimestamp = min(Timestamp), arg_max(Timestamp, *) by TeamsMessageId | where IsOwnedThread == 0 and IsExternalThread == 1 | summarize FirstSeen = min(FirstTimestamp), Messages = count(), ThreatMessages = countif(isnotempty(ThreatTypes)) by SenderEmailAddress | top 20 by FirstSeen desc | project ['Sender']=SenderEmailAddress, ['First Seen']=FirstSeen, ['Messages']=Messages, ['Threat Messages']=ThreatMessages