适用于 Windows 操作系统的 WMI 筛选器

最新推荐文章于 2025-10-11 15:50:15 发布

原创最新推荐文章于 2025-10-11 15:50:15 发布 · 1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#windows

收录于

这些SQL查询语句展示了如何使用WMI（Windows Management Instrumentation）来筛选不同版本和产品类型的Windows操作系统，包括Windows Server 2012、Windows 8、Windows Server 2008 R2等。每个查询通过`Win32_OperatingSystem`类的`Version`和`ProductType`属性来识别特定的操作系统。

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"

视窗服务器 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"

有关 WMI 过滤器示例的更大列表，请参见此处： Windows：WMI 过滤器字符串示例