Queries for the AppPageViews table

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

Page views trend

Chart the page views count, during the last day.

// To create an alert for this query, click '+ New alert rule'
AppPageViews
| where ClientType == 'Browser'
| summarize count_sum = sum(ItemCount) by bin(TimeGenerated,30m), _ResourceId
| render timechart

Slowest pages

What are the 3 slowest pages, and how slow are they?

AppPageViews
| where notempty(DurationMs) and ClientType == 'Browser'
| extend total_duration=DurationMs*ItemCount
| summarize avg_duration=(sum(total_duration)/sum(ItemCount)) by OperationName
| top 3 by avg_duration desc