in

SMSUG.ca

...your virtual communITy
All Tags » WQL » CM12 (RSS)

Browse by Tags

  • Find all PC with HW and SW inventory dates greater than 180 days

    This WQL query will show you all PCs with a HW and SW Scan date of greater than 180 days. select SMS_R_System.Name, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId inner join...
    Posted to Garth Jones (Weblog) by Garth on 08-26-2013
  • Finding all PCs with MSAcess.exe in the All Systems collection

    Use this query to find all PCs with MS Access in the All systems collection.   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_SoftwareFile...
    Posted to Garth Jones (Weblog) by Garth on 07-30-2013
  • Find PC by Last logon user – prompted

    Use this query if you want to locate PCs by that last logon user but prompt for the user name each time. select SMS_R_System.Name from SMS_R_System where SMS_R_System.LastLogonUserName = ##PRM:SMS_R_System.LastLogonUserName## order by SMS_R_System.Name
    Posted to Garth Jones (Weblog) by Garth on 06-29-2013
  • How to find PCs within an AD container

    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...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2013
  • WMI query for C: with more than 1GB of HD space.

    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
    Posted to Garth Jones (Weblog) by Garth on 01-11-2013
  • 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...
    Posted to Garth Jones (Weblog) by Garth on 01-31-2012
Page 1 of 1 (6 items)
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems