Skip to content

Instantly share code, notes, and snippets.

@SvenAelterman

SvenAelterman/WVDConnections_byUser_byClientVersion.kql

Last active August 16, 2024 18:17
Show Gist options
  • 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