Коллекция ПК определенной модели

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System     INNER JOIN SMS_G_System_COMPUTER_SYSTEM       ON SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId   WHERE  SMS_G_System_COMPUTER_SYSTEM.Model = "Ergo Ensis 211"

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Q_24934460.html