in

SMSUG.ca

...your virtual communITy
All Tags » WQL » SMS (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
  • 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
  • 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
  • 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
  • WQL Query for both x86 and x64 version of Software

      select distinct SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = " Microsoft Lync 2010 ") or SMS_R_System...
    Posted to Garth Jones (Weblog) by Garth on 01-16-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
  • Client Version and model

    select     SMS_R_System.Name,     SMS_R_System.ResourceId,     SMS_G_System_COMPUTER_SYSTEM.Manufacturer,     SMS_G_System_COMPUTER_SYSTEM.Model from      SMS_R_System     inner join SMS_G_System_COMPUTER_SYSTEM...
    Posted to Garth Jones (Weblog) by Garth on 03-09-2011
  • 2011 myITforum.com Donation

    With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Have you made a donation to your community yet? http://www.myitforum.com/donations/donate.asp
    Posted to Garth Jones (Weblog) by Garth on 01-02-2011
Page 1 of 5 (45 items) 1 2 3 4 5 Next >
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems