Skip to content

Instantly share code, notes, and snippets.

@SvenAelterman

SvenAelterman/WVDConnections_byUser_byClientVersion,kql

Created April 27, 2023 13:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SvenAelterman/f518af407f1eecfb64d0364450d302fb to your computer and use it in GitHub Desktop.
Save SvenAelterman/f518af407f1eecfb64d0364450d302fb to your computer and use it in GitHub Desktop.
Download ZIP
Query Azure Virtual Desktop (AVD) connection logs for client versions used by users over time
Raw
WVDConnections_byUser_byClientVersion,kql
let startTime = ago(30d);
WVDConnections
| where TimeGenerated > startTime
| summarize min(TimeGenerated), max(TimeGenerated) by UserName, ClientOS, ClientType, ClientVersion
| sort by UserName, min_TimeGenerated
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment