AzureActivity | where ResourceGroup =~ "" | where ResourceProviderValue =~ "Microsoft.Resources" | where ActivityStatusValue =~ "Accept" | where ActivitySubstatusValue =~ "Created" | order by TimeGenerated desc | extend Name = parse_json(Properties).resource | project TimeGenerated, CorrelationId, Caller, CallerIpAddress, ResourceGroup = tolower(ResourceGroup), Name | join (AzureActivity | where ActivityStatusValue =~ "Start" | where ResourceProviderValue !~ "Microsoft.Resources" | extend Resource = tolower(_ResourceId) | distinct Resource, CorrelationId | summarize Resources=make_list(Resource) by CorrelationId) on CorrelationId | project TimeGenerated, Caller, CallerIpAddress, ResourceGroup, Name, Resources