Forum Discussion

Matty1231's avatar
Matty1231
Copper Contributor
May 28, 2024

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

  • tommykneetz's avatar
    tommykneetz
    Iron Contributor
    May 30, 2024
    when 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...
    • Matty1231's avatar
      Matty1231
      Copper Contributor
      Jun 11, 2024
      Ended 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

Resources