Queries for the WVDCheckpoints table

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

Published remote resources by count of users

Produces a bar chart of published resources by the number of users that have launched them.

// The checkpoints table keeps track of any individual remote application or desktop a user has started from the remote desktop client UI. 
// Note: These logs will only reflect applications published as RemoteApp; applications started within a published desktop session are not individually captured and only show as the overall remote desktop connection.
WVDCheckpoints  
| where Name == "LaunchExecutable" 
| extend App = parse_json(Parameters).filename 
| summarize Usage = dcount(UserName) by tostring(App) 
| sort by Usage desc 
| render barchart