Operating system | Version number |
---|---|
Windows 8 | 6.2 |
Windows Server 2012 | 6.2 |
Windows 7 | 6.1 |
Windows Server 2008 R2 | 6.1 |
Windows Server 2008 | 6 |
Windows Vista | 6 |
Windows Server 2003 R2 | 5.2 |
Windows Server 2003 | 5.2 |
Windows XP 64-Bit Edition | 5.2 |
Windows XP | 5.1 |
Windows 2000 | 5 |
eg
SELECT * FROM Win32_OperatingSystem WHERE Version LIKE “5.%”
SCS – ProductType = Domain Controller Servers Only
SELECT * FROM Win32_OperatingSystem WHERE ProductType = 2
SCS – ProductType = All Servers
SELECT * FROM Win32_OperatingSystem WHERE ProductType = 2 OR ProductType = 3
SCS – ProductType = All Workstations
SELECT * FROM Win32_OperatingSystem WHERE ProductType =