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": []
		}
	]
}

​
Workflow Library Example

Execute Analytics Query with Azure Log Analytics and Send Results Via Email
Workflow LibraryPreview this Workflow on desktop