SCCM 2012 запросы(query )

links
Computers with certain prefixes - % being a wildcard

   select SMS_R_System.NetbiosName
  from
   SMS_R_System
   WHERE
   SMS_R_System.NetbiosName = "ABC%"  

Adobe Reader XI Installations - from Programs in Control Panel

 select SMS_R_System.NetbiosName,  
 SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from  
 SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on  
 SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId =  
 SMS_R_System.ResourceId where  
 SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “Adobe Reader XI”  

Devices based on OU

  select distinct * from SMS_R_System
 WHERE
 SMS_R_System.SystemOUName = "OU NAME"  

Windows 8 Installations

 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.2%" or SMS_R_System.OperatingSystemNameandVersion LIKE "%Windows 8%"