Find PCs based on Model

SELECT v_GS_COMPUTER_SYSTEM.Name0, v_GS_COMPUTER_SYSTEM.Manufacturer0, v_GS_COMPUTER_SYSTEM.Model0, v_GS_COMPUTER_SYSTEM.UserName0
FROM dbo.v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM
WHERE v_GS_COMPUTER_SYSTEM.Model0=’Virtual Machine’

Leave a Reply

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