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

Read More