Skip to content

Instantly share code, notes, and snippets.

@alexverboon

alexverboon/win10versiondistribution.kql

Created January 26, 2021 23:25
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexverboon/f708d7c73e4a48561d3357e2a24237e0 to your computer and use it in GitHub Desktop.
Save alexverboon/f708d7c73e4a48561d3357e2a24237e0 to your computer and use it in GitHub Desktop.
Download ZIP
KQL_Windows10versiondistribution
Raw
win10versiondistribution.kql
// Windows 10 versions https://docs.microsoft.com/en-us/windows/release-information/
DeviceInfo
| where isnotempty( OSPlatform) and OSPlatform == "Windows10"
| summarize arg_max(Timestamp,*) by DeviceId
| extend Version = case(
OSBuild == "19041","2004",
OSBuild == "19042","20H2",
OSBuild == "18363","1909",
OSBuild == "18362","1903",
OSBuild == "17763","1809",
OSBuild == "17134","1803",
OSBuild == "16299","1709",
OSBuild == "15063","1703",
OSBuild == "14393","1607",
OSBuild == "20270","Insider",
OSBuild == "21292","Insider",
OSBuild == "21277","Insider",
OSBuild == "21296","Insider","undefined")
| project DeviceName, OSPlatform, OSVersion, OSBuild, Version
| summarize TotalDevices = count() by Version | render barchart | sort by Version
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment