Queries for the AutoscaleScaleActionsLog table

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"