select
SMS_R_System.Name,
SMS_R_System.ResourceId,
SMS_G_System_COMPUTER_SYSTEM.Manufacturer,
SMS_G_System_COMPUTER_SYSTEM.Model
from
SMS_R_System
inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_R_System.ClientVersion = “4.00.6487.2000”
and SMS_G_System_COMPUTER_SYSTEM.Model = “Virtual Machine”