Queries for the AppServiceAuthenticationLogs table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Most recent errors from App Service Authentication

Lists up to 100 most recent errors from App Service Authentication in selected time range.

AppServiceAuthenticationLogs
| where TaskName == "MiddlewareError"
| sort by TimeGenerated desc
| take 100

Most recent warnings from App Service Authentication

Lists up to 100 most recent warnings from App Service Authentication in selected time range.

AppServiceAuthenticationLogs
| where TaskName == "MiddlewareWarning"
| sort by TimeGenerated desc
| take 100

Top 100 most frequent errors and warnings from App Service Authentication

Count of top 100 most frequent error and warning messages from App Service Authentication in selected time range, sorted by type (errors shown first), then descending count.

AppServiceAuthenticationLogs
| where TaskName == "MiddlewareWarning" or TaskName == "MiddlewareError"
| summarize count() by Message, TaskName
| order by TaskName asc, count_
| take 100