Запрос на получение компьютеров с Windows 7 x86:
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_R_System.OperatingSystemNameandVersion LIKE "%Workstation 6.1%" AND SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC"
Запрос на получение компьютеров с Windows 7 x64:
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_R_System.OperatingSystemNameandVersion LIKE "%Workstation 6.1%" AND SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC"