in

SMSUG.ca

...your virtual communITy
All Tags » WQL » Code (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
  • IE7 Collection

    For full detail please see forum post   select * from SMS_R_System left join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId left join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId...
    Posted to Garth Jones (Weblog) by Garth on 10-08-2012
  • Query for computers with single partition

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/4d84e5f9-fd48-4fcb-b490-d0a64052aa08 select SMS_R_System.Name from SMS_R_System where SMS_R_System.ResourceId not in ( select SMS_G_System_PARTITION.ResourceId from SMS_G_System_PARTITION where SMS_G_System_PARTITION...
    Posted to Garth Jones (Weblog) by Garth on 06-09-2012
  • How to exclude a collection from sccm collection query

    For full details, see this forums post. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/75288b97-1fe6-4634-a20a-54091bba8d91   select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup...
    Posted to Garth Jones (Weblog) by Garth on 05-19-2012
  • 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
  • Collection by Gateway

    select     SMS_R_System.Name from      SMS_R_System     inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where     SMS_G_System_NETWORK_ADAPTER_CONFIGURATION...
    Posted to Garth Jones (Weblog) by Garth on 03-18-2011
Page 1 of 5 (43 items) 1 2 3 4 5 Next >
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems