Client Version and model

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”

Leave a Reply

Your email address will not be published. Required fields are marked *