Forum Discussion
Matty1231
May 28, 2024Copper Contributor
KQL for an application within an application group
Hi,
Is it possible to query how many "hits" there are against an application within an application group in AVD?
I'm able to see the resource alias via WVDConnections but this doesn't show the specific applications that a user is connecting to.
Thanks
- tommykneetzIron Contributorwhen you have LOgs enabled and go to > avd > insights > utilization > right corner at the bottom > that could be your information. you can try to edit that workbook to find the kql...
- Matty1231Copper ContributorEnded up using the following:
// 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 == "RdpShellAppExecution"
| extend App = parse_json(Parameters).filename
| summarize Usage = dcount(UserName) by tostring(App)
| sort by Usage desc
| render barchart