Tip of the day: List of machines with Windows Vista

Posted
This query lists all the machines with Windows Vista with the Edition and Service Pack. The queries use a class that is provided by Normalize CM.

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 Vista”

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 Vista’

Sample output:

OS Manufacturer OS Name OS MajorVersion OS ServicePack OS Edition
Microsoft Windows Vista Vista NULL Enterprise
Microsoft Windows Vista Vista NULL Ultimate
Microsoft Windows Vista Vista SP1 Business
Microsoft Windows Vista Vista SP1 Enterprise
Microsoft Windows Vista Vista SP1 Ultimate
Microsoft Windows Vista Vista SP2 Enterprise

 

email

Written by , Posted .