WMI Filter for Windows Operating Systems

You can use the attached queries to apply GPOs only to a specific Operating System. This can prevent problems, like applying a server GPO to a client and vice versa. You can also use this, to only apply mappings on client OS.


Windows Server 2012 DC
select * from Win32_OperatingSystem where Version like "6.2%" and ProductType = "2"

Windows Server 2012   
select * from Win32_OperatingSystem where Version like "6.2%" and ProductType = "3"

Windows 8   
select * from Win32_OperatingSystem where Version like "6.2%" and ProductType = "1"

Windows Server 2008 R2   
select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "3"

Windows Server 2008 R2 DC   
select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "2"

Windows 7   
select * from Win32_OperatingSystem where Version like "6.1%" and ProductType = "1"

Windows Server 2008   
select * from Win32_OperatingSystem where Version like "6.0%" and ProductType = "3"

Windows Server 2008 DC   
select * from Win32_OperatingSystem where Version like "6.0%" and ProductType = "2"

Windows Vista   
select * from Win32_OperatingSystem where Version like "6.0%" and ProductType = "1"

Windows Server 2003   
select * from Win32_OperatingSystem where Version like "5.2%" and ProductType = "3"

Windows XP   
select * from Win32_OperatingSystem where (Version like "5.1%" or Version like "5.2%") and ProductType = "1"