Share This Post

List of machines with Windows 2003 R2

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’

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply