WMI filtering by computer type

 Desktops and workstations

Select * from Win32_ComputerSystem WHERE (PCSystemType = 1) or (PCSystemType = 3) 

Old filter:

select * from Win32_OperatingSystem where ProductType="1"
Select * from Win32_Battery WHERE (BatteryStatus=0)



notebooks only

Select * from Win32_ComputerSystem WHERE (PCSystemType = 2)

Old filter: 

Select * from Win32_Battery WHERE (BatteryStatus <> 0)



0 – Unspecified
1 – Desktop
2 – Mobile
3 – Workstation
4 – Enterprise Server
5 – SOHO Server
6 – Appliance PC
7 – Performance Server
8 – Maximum

WMI filter by OS Name

 

For Windows 10 in general:
Select * from Win32_OperatingSystem WHERE Caption LIKE 'Microsoft Windows 10%'

Example for english Windows 7, Server 2008r2 and 10 (but not Windows 8.x or 2008):
Select * from Win32_OperatingSystem WHERE (Caption LIKE 'Microsoft Windows 7%' OR Caption LIKE ‘Microsoft Windows Server 2008 R2%' OR Caption LIKE 'Microsoft Windows 10%’) AND OSLanguage = 1033