SCCM Query for Memory & CPU

See Forum post for fill details.

select distinct 

  SMS_R_System.Name, 

  SMS_R_System.Client, 

  SMS_R_System.LastLogonUserName, 

  SMS_R_System.ADSiteName, 

  SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, 

  SMS_G_System_PROCESSOR.NormSpeed 

from  

  SMS_R_System 

  inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId 

  left join SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId 

  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 is like "Adobe Reader X%"

  and SMS_R_System.Client = 1