AppPageViews 表的查询

页面视图趋势

绘制最后一天的页面浏览次数的图表。

// 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

最慢的页面

最慢的 3 个页面是什么,它们有多慢?

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