Pull list of computers for a specific model
This tip requires a limited knowledge of SQL Server Management Studio. Paste this query into SSMS and modify the WHERE statement to pull the model that you are looking for. In this example, I was getting all Dell Latitude E6*20 series, with returned E6320, E6420, and E6520 devices.
SELECT ResouceID,Manufacturer0,Model0,Name0
FROM v_GS_COMPUTER_SYSTEM
WHERE v_GS_COMPUTER_SYSTEM.Model0 like ‘%Latitude E6%20%’