Browse by Tags

How to find PCs within an AD container
Saturday, March 16, 2013 9:02 AM

If you need to find all PC within an AD container (not an OU). Use this WQL query to find them. For more details about this request, see the full forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/9358cee7-75a5-4595-80a3-4016ea572f1b   select SMS_R_System.Name, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, System Center, Code, WQL, SCCM, CM12, CM07

WMI query for C: with more than 1GB of HD space.
Friday, January 11, 2013 8:39 AM

For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/fde395bb-a4b6-4347-b1b6-8c180c3f7f46   This is a WMI WQL query and NOT and native CM07 / CM12 WQL query. select Size from Win32_LogicalDisk Where DeviceId="C:" and size > 1073741824 Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, System Center, Code, WQL, SCCM, CM12, CM07

SCCM Query for Memory & CPU
Tuesday, January 31, 2012 9:18 PM

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... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, Code, WQL, SCCM, CM12