// Hunting starter. Documentation checked 2026-11-13; not tenant-tested. let analysisEnd = startofday(now()) - 1d; let analysisStart = analysisEnd - 1d; let reads = materialize( StorageBlobLogs | where TimeGenerated >= analysisStart - 7d and TimeGenerated < analysisEnd | where OperationName =~ "GetBlob" and AuthenticationType =~ "OAuth" | where toint(StatusCode) between (200 .. 299) | extend AccountResource = tolower(_ResourceId), PrincipalTenant = tolower(RequesterTenantId), PrincipalObject = tolower(RequesterObjectId), SafeObjectPath = tostring(split(Uri, "?")[0]) | where isnotempty(AccountResource) and isnotempty(PrincipalTenant) and isnotempty(PrincipalObject) | project TimeGenerated, AccountResource, PrincipalTenant, PrincipalObject, ResponseBodySize, SafeObjectPath, CallerIpAddress ); let baseline = reads | where TimeGenerated < analysisStart | summarize BaselineRequests = count(), BaselineDaysWithReads = dcount(startofday(TimeGenerated)) by AccountResource, PrincipalTenant, PrincipalObject | extend BaselineDailyMean = toreal(BaselineRequests) / 7.0; reads | where TimeGenerated >= analysisStart | summarize AnalysisRequests = count(), ObservedResponseBytes = sum(ResponseBodySize), MissingResponseSizes = countif(isnull(ResponseBodySize)), ObjectEstimate = dcount(iff(isnotempty(SafeObjectPath), pack_array(SafeObjectPath), dynamic(null))), IpSamples = make_set(CallerIpAddress, 5) by AccountResource, PrincipalTenant, PrincipalObject | join kind=leftouter baseline on AccountResource, PrincipalTenant, PrincipalObject | extend BaselineState = iff(isnull(BaselineRequests), "No matching historical rows", "Historical rows observed"), VolumeRatio = iff(BaselineDailyMean > 0, toreal(AnalysisRequests) / BaselineDailyMean, real(null)) | where AnalysisRequests >= 100 and (isnull(BaselineRequests) or VolumeRatio >= 3.0) | project AnalysisStart = analysisStart, AnalysisEnd = analysisEnd, AccountResource, PrincipalTenant, PrincipalObject, AnalysisRequests, BaselineState, BaselineRequests, BaselineDaysWithReads, BaselineDailyMean, VolumeRatio, ObservedResponseBytes, MissingResponseSizes, ObjectEstimate, IpSamples | order by AnalysisRequests desc | take 200