Queries for the WVDCheckpoints table

  • Article

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