SQL Query To Find All IBM And Lenovo Machines

 

This SQL Query will provide you with a list of all of the IBM and Lenovo machines.

 

SQL Query:

 

Select

SD.Name0,

CS.Manufacturer0

 

From v_R_System SD

Join  v_GS_Computer_System CS On SD.ResourceId = CS.ResourceId

 

Where CS.Manufacturer0 = 'IBM'

Or CS.Manufacturer0 = 'Lenovo'

 

Order By CS.Manufacturer0, SD.Name0

 

 

Published Sunday, October 26, 2008 2:33 PM by dhite
Filed under:

Comments

No Comments