↳ GitHub sourceAnalytics ruleMedium
Dataverse - Malware found in SharePoint document management site
Description
This query identifies malware uploaded via Dynamics 365 document management or directly in SharePoint impacting Dataverse associated SharePoint sites.
- Rule type
- Scheduled
- Version
- 3.2.0
- Declared status
- Available
- Query frequency
- 1h
- Query period
- 14d
- Trigger
- gt 0
Declared MITRE coverage
Declared sources
Metadata from the source file. No dependencies inferred from KQL.
Connectors
Data types
KQL query
Original query, unchanged.
let query_frequency = 15m;
let malware_events = OfficeActivity
| where OfficeWorkload == "SharePoint" and Operation == "FileMalwareDetected"
| summarize by MalwareUserId = UserId, SourceFileName, Site_Url
| join kind=inner (DataverseSharePointSites) on $left.Site_Url == $right.SharePointUrl;
let file_upload_events = OfficeActivity
| where OfficeWorkload == "SharePoint" and Operation == "FileUploaded"
| project TimeGenerated, UserId, Site_Url, SourceFileName, ApplicationId, ClientIP;
let d365_upload_events = DataverseActivity
| where TimeGenerated >= ago(query_frequency)
| where Message == "UploadDocument"
| summarize by UserId, D365ClientIp = ClientIp;
malware_events
| join kind=inner (file_upload_events) on SourceFileName, Site_Url
| lookup (d365_upload_events) on UserId
| extend ClientIp = iif(ApplicationId == "00000007-0000-0000-c000-000000000000", D365ClientIp, ClientIP)
| extend
CloudAppId = int(32780),
SharePointId = int(20892),
AccountName = tostring(split(UserId, '@')[0]),
UPNSuffix = tostring(split(UserId, '@')[1])
| project
TimeGenerated,
UserId,
ClientIp,
InstanceUrl,
SharePointUrl,
SourceFileName,
CloudAppId,
SharePointId,
AccountName,
UPNSuffix
Declared entities
Related content
Links established from declared identifiers and solution manifests.
Source provenance
GitHubDisplayed values come from files in Azure/Azure-Sentinel. They describe the published template, not your workspace configuration.
- Commit
9800e51↗- Source identifier
2e3878bb-d519-43aa-9992-ea069df099e4
GSTEP / CATALOG TRACKING
Added to catalog : 16 Sept 2026 · 05:49 UTC
Last change observed : 16 Sept 2026 · 05:49 UTC