Azure Log Analytics: Cross Workspace Query


This was announced at Ignite last week, see here https://azure.microsoft.com/en-us/blog/query-across-resources/  which I missed at the time.   Adding the 'withsource=SourceTable' I have found to be really useful to see where the data was found.  If the returned SourceTable is just "SecurityEvent" as per this example its from your local workspace, if its workspace('<insert your remote workspace name>').SecurityEvent 
// show AzureActivity in that workspace
union withsource=SourceTable SecurityEvent, workspace("fabrikamltd").SecurityEvent
| where (EventID < 4625)
| summarize count() by EventID, SourceTable, Activity, Computer

// Look at just remote EventIDs
workspace("fabrikamltd").SecurityEvent
| where (EventID < 4625)
| summarize count() by EventID, Activity, Computer


Comments (0)

Skip to main content