This query lists all the Virtual Machines by manufacturer.
* Requires BDNA Normalize CM
Microsoft Corporation Virtual Machine
VMware, Inc. VMware Virtual Platform
*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.
select System.Name, HARDWARE.IsVirtual, HARDWARE.Category1, HARDWARE.Category2, HARDWARE.Manufacturer 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.IsVirtual = "yes"
SELECT v_R_System.Name0 as Name, Hardware.IsVirtual0 as IsVirtual, Hardware.Category10 as Category1, Hardware.Category20 as Category2, Hardware.Manufacturer0 as Manufacturer
INNER JOIN v_GS_BDNA_Hardware_Data0 Hardware ON Hardware.SMSUniqueIdentifier0=v_R_System.SMS_Unique_Identifier0
WHERE Hardware.IsVirtual0 = ‘yes’