Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
KQL_Windows10versiondistribution
// 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