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.

Display top Autoscale 50 logs

Show the latest Azure Autoscale logs in the last 24 hours.

AutoscaleScaleActionsLog 
| where TimeGenerated > ago(24h) 
| limit 50

Autoscale operation status

Lists latest Autoscale operations, scale direction, instance count and it's status.

AutoscaleScaleActionsLog
| project TimeGenerated, ResourceId, CurrentInstanceCount, NewInstanceCount, ScaleDirection, ResultType
| sort by TimeGenerated desc 

Autoscale failed operations

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"