List of machines with Windows 2000

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

This query lists all the machines with Windows 2000 by Edition, and Service Pack.

*Requires BDNA Normalize CM

OS Manufacturer

OS Name

OS MajorVersion

OS ServicePack

OS Edition

Microsoft

Windows 2000

2000

SP4

Advanced Server

Microsoft

Windows 2000

2000

SP4

Professional

Microsoft

Windows 2000

2000

SP4

Server

*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 2000"

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 2000′

email

Written by , Posted .