WINDOWS CLIENT
Windows XP
select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1"
Windows 7
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1"
Windows 7 (32-bit)
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 7 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND OSArchitecture = "64-bit"
Windows 8
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1"
Windows 8 (32-bit)
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 8 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND OSArchitecture = "64-bit"
Windows 8.1
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1"
Windows 8.1 (32-bit)
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 8.1 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND OSArchitecture = "64-bit"
Windows 10 RTM (32-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.10240%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 10 RTM (64-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.10240%" AND ProductType="1" AND OSArchitecture = "64-bit"
Windows 10 1511Β (32-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.10586%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 10 1511 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.10586%" AND ProductType="1" AND OSArchitecture = "64-bit"
Windows 10 1607 (AnniversaryΒ Update) (32-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.14393%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 10 1607 (AnniversaryΒ Update) (64-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.14393%" AND ProductType="1" AND OSArchitecture = "64-bit"
Windows 10 1703 (Creators Update) (32-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.15063%" AND ProductType="1" AND NOT OSArchitecture = "64-bit"
Windows 10 1703 (Creators Update) (64-bit)
select * from Win32_OperatingSystem WHERE Version like "10.0.15063%" AND ProductType="1" AND OSArchitecture = "64-bit"
WINDOWS SERVER
Windows Server 2003
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3"
Windows Server 2003 (Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2"
Windows Server 2003 R2
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3"
Windows Server 2003 R2 (Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2"
Windows Server 2008
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3"
Windows Server 2008 (Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2"
Windows Server 2008 (32-bit)
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND NOT OSArchitecture = "64-bit"
Windows Server 2008 (32-bit, Β Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND NOT OSArchitecture = "64-bit"
Windows Server 2008 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND OSArchitecture = "64-bit"
Windows Server 2008 (64-bit, Β Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND OSArchitecture = "64-bit"
Windows Server 2008 R2 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="3"
Windows Server 2008 R2 (64-bit, Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="2"
Windows Server 2012 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="3"
Windows Server 2012 (64-bit, Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="2"
Windows Server 2012 R2 (64-bit)
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="3"
Windows Server 2012 R2 (64-bit, Domain Controller)
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="2"
/ JC