SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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
Published Jan 31 2012, 09:18 PM by Garth
Filed under: , , , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems