Execute Analytics Query

Executes a Log Analytics query.

Parameters

Parameter	Description
From	Filter result from the given date.
Query	The Analytics query. Learn more about the Analytics query syntax.
To	Filter results before the given date.
Workspace ID	The 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

Preview this Workflow on desktop