WINDOWS XP 
Windows XP select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" 
32-bit 
select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" AND NOT OSArchitecture = "64-bit" 
64-bit 
select * from Win32_OperatingSystem WHERE (Version like "5.1%" or Version like "5.2%") AND ProductType="1" AND OSArchitecture = "64-bit" 

WINDOWS VISTA 

select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" 
32-bit 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" 
64-bit 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="1" AND OSArchitecture = "64-bit" 
WINDOWS 7 
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" 
 32-bit 
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" 
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" 
32-bit 
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" 
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" 
32-bit 
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND NOT OSArchitecture = "64-bit" 
64-bit 
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="1" AND OSArchitecture = "64-bit" 

Windows 10     
Select BuildNumber, ProductType from Win32_OperatingSystem where BuildNumber <= 14393 AND ProductType ="1"

SERVERS 
select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") 
32-bit 
select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") AND NOT OSArchitecture = "64-bit" 
64-bit 
select * from Win32_OperatingSystem where (ProductType = "2") OR (ProductType = "3") AND OSArchitecture = "64-bit" 
Domain Controller 
select * from Win32_OperatingSystem where (ProductType = "2") 
32-bit 
select * from Win32_OperatingSystem where (ProductType = "2") AND NOT OSArchitecture = "64-bit" 
64-bit 
select * from Win32_OperatingSystem where (ProductType = "2") AND OSArchitecture = "64-bit" 
Non-Domain Controller 
select * from Win32_OperatingSystem where (ProductType = "3") 
32-bit 
select * from Win32_OperatingSystem where (ProductType = "3") AND NOT OSArchitecture = "64-bit" 
64-bit 
select * from Win32_OperatingSystem where (ProductType = "3") AND OSArchitecture = "64-bit" 
WINDOWS SERVER 2003 
DC 
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" 
non-DC 
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" 
32-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" AND NOT OSArchitecture = "64-bit" 
32-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" AND NOT OSArchitecture = "64-bit" 
64-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="2" AND OSArchitecture = "64-bit" 
64-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "5.2%" AND ProductType="3" AND OSArchitecture = "64-bit" 
WINDOWS SERVER 2003 R2 
DC 
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" 
non-DC 
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" 
32-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" AND NOT OSArchitecture = "64-bit" 
32-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" AND NOT OSArchitecture = "64-bit" 
64-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="2" AND OSArchitecture = "64-bit" 
64-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "5.2.3%" AND ProductType="3" AND OSArchitecture = "64-bit" 
WINDOWS SERVER 2008 
DC 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" 
non-DC 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" 
32-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND NOT OSArchitecture = "64-bit" 
32-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND NOT OSArchitecture = "64-bit" 
64-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="2" AND OSArchitecture = "64-bit" 
64-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "6.0%" AND ProductType="3" AND OSArchitecture = "64-bit" 
WINDOWS SERVER 2008 R2 
64-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="2" 
64-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "6.1%" AND ProductType="3" 
WINDOWS SERVER 2012 
64-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="2" 
64-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "6.2%" AND ProductType="3" 
WINDOWS SERVER 2012 R2 
64-bit – DC 
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="2" 
64-bit – non-DC 
select * from Win32_OperatingSystem WHERE Version like "6.3%" AND ProductType="3"