List of machines with Windows 2003 R2

Posted in Reports and Queries, SCCM 2007, SCCM 2012, System Center Configuration Manager

This query lists all the machines with Windows 2003 R2 by Edition, and ServicePack.

*Requires BDNA Normalize CM

OS Manufacturer

OS Name

OS MajorVersion

OS ServicePack

OS Edition

Microsoft

Windows Server 2003

2003 R2

SP1

Enterprise (32-bit x86)

Microsoft

Windows Server 2003

2003 R2

SP1

Standard (32-bit x86)

Microsoft

Windows Server 2003

2003 R2

SP2

Enterprise (32-bit x86)

Microsoft

Windows Server 2003

2003 R2

SP2

Enterprise x64

Microsoft

Windows Server 2003

2003 R2

SP2

Standard (32-bit x86)

Microsoft

Windows Server 2003

2003 R2

SP2

Standard x64

*The list above is not exhaustive, and only provided a sample of the data that are available within CM.

Using the new CM class BDNA_HARDWARE_DATA, all your hardware information are now available into a single table. You can query this table using WQL or SQL.

WQL:

select System.Name, HARDWARE.IsVirtual, HARDWARE.OS_Manufacturer, HARDWARE.OS_Name, HARDWARE.OS_MajorVersion, HARDWARE.OS_MinorVersion, HARDWARE.OS_ServicePack, HARDWARE.OS_Edition from SMS_R_System inner join SMS_G_System_BDNA_BDNAHARDWAREDATA_1_1 as HARDWARE on HARDWARE.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = HARDWARE.SMSUniqueIdentifier where HARDWARE.OS_Name = "Windows Server 2003" and HARDWARE.OS_MajorVersion = "2003 R2"

SQL:

SELECT v_R_System.Name0 as Name, Hardware.IsVirtual0 as IsVirtual, Hardware.OS_Manufacturer0 as OS_Manufacturer, Hardware.OS_Name0 as OS_Name, Hardware.OS_MajorVersion0 as OS_MajorVersion, Hardware.OS_MinorVersion0 as OS_MinorVersion, Hardware.OS_ServicePack0 as OS_ServicePack, Hardware.OS_Edition0 as OS_Edition

FROM v_R_System

INNER JOIN v_GS_BDNA_Hardware_Data0 Hardware ON Hardware.SMSUniqueIdentifier0=v_R_System.SMS_Unique_Identifier0

WHERE Hardware.OS_Name0 = ‘Windows Server 2003′ AND Hardware.OS_MajorVersion0 = ’2003 R2′

email

Written by , Posted .