SQL Query – All Systems with Make and Model Name (per Lenovo)

As we all  know, Lenovo have to be different.  When we run a query for Make / Model any of our Lenovo devices return a manufacturer specific model number rather than the model we would like to see like ThinkPad 470S.  This query returns the Version00 field which is where the actual model name is stored.

SELECT GCS.Name0
    ,GCS.ResourceID
    ,GCS.Manufacturer0
    ,GCS.Model0
    ,CSP.Version00
FROM v_GS_COMPUTER_SYSTEM GCS
    JOIN COMPUTER_SYSTEM_PRODUCT_DATA CSP on GCS.ResourceID = CSP.MachineID
WHERE Manufacturer0 = 'Lenovo'
Order by Name0

Sample Output

Related posts

Leave a Comment