Лог Пафа – Метка: Запросы

Записи с меткой «Запросы»

Коллекции на получение компьютеров с Windows 7 x86 и x64 в SCCM 2007

Запрос на получение компьютеров с 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 …

Do NOT follow this link or you will be banned from the site!