Skip to main content

Execute Analytics Query

Executes a Log Analytics query.

Parameters

ParameterDescription
FromFilter result from the given date.
QueryThe Analytics query. Learn more about the Analytics query syntax.
ToFilter results before the given date.
Workspace IDThe ID of the workspace. You can obtain this ID by running the Log Analytics List Workspaces In Resource Group action or from the Properties blade in the Azure portal.

Example Output

{
"tables": [
{
"name": "PrimaryResult",
"columns": [
{
"name": "Category",
"type": "string"
},
{
"name": "count_",
"type": "long"
}
],
"rows": []
}
]
}

Automation Library Example

Execute Analytics Query with Azure Log Analytics and Send Results Via Email

Automation LibraryPreview this Automation on desktop