Queries for the AutoscaleScaleActionsLog table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Show the latest Azure Autoscale logs in the last 24 hours.
AutoscaleScaleActionsLog
| where TimeGenerated > ago(24h)
| limit 50
Lists latest Autoscale operations, scale direction, instance count and it's status.
AutoscaleScaleActionsLog
| project TimeGenerated, ResourceId, CurrentInstanceCount, NewInstanceCount, ScaleDirection, ResultType
| sort by TimeGenerated desc
List all reports of failed operations, over the last day.
// To create an alert for this query, click '+ New alert rule'
AutoscaleScaleActionsLog
| where TimeGenerated > ago(24h)
| where ResultType == "Failed"