Garth Jones at myITforum.com : SMS, WQL

How to find PCs within an AD container

Garth Jones — Sat, 16 Mar 2013 13:02:12 GMT

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...(read more)

WMI query for C: with more than 1GB of HD space.

Garth Jones — Fri, 11 Jan 2013 13:39:36 GMT

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...(read more)

Query for computers with single partition

Garth Jones — Sat, 09 Jun 2012 21:53:18 GMT

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...(read more)

SCCM Query for Memory & CPU

Garth Jones — Wed, 01 Feb 2012 02:18:43 GMT

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...(read more)

WQL Query for both x86 and x64 version of Software

Garth Jones — Mon, 16 Jan 2012 22:27:42 GMT

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...(read more)

Collection by Gateway

Garth Jones — Fri, 18 Mar 2011 19:28:06 GMT

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 ...(read more)

Client Version and model

Garth Jones — Thu, 10 Mar 2011 03:39:22 GMT

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 ...(read more)

PCs without SEP

Garth Jones — Tue, 11 Jan 2011 23:52:30 GMT

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 where SMS_R_System.ResourceId not in (select SMS_G_System_ADD_REMOVE_PROGRAMS...(read more)

2011 myITforum.com Donation

Garth Jones — Sun, 02 Jan 2011 20:47:12 GMT

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...(read more)

PC with app x but exclude PC y

Garth Jones — Fri, 08 Oct 2010 10:27:00 GMT

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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS...(read more)

Find PCs like TTDRxxxACxxWxxx

Garth Jones — Fri, 03 Sep 2010 15:01:29 GMT

select * from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name like "TTDR___AC__W___"...(read more)

Dynamic Subnet Collection

Garth Jones — Fri, 16 Jul 2010 16:02:01 GMT

select * 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 ...(read more)

SMSUG.ca Forums

Garth Jones — Thu, 01 Jul 2010 13:44:41 GMT

I have decided that the forums on www.SMSUG.ca are not being used and due to some SPAMMER populating the membership list, I have closed them down. This is a good thing as it means I will arrange for the site to be convert to a blog only site. With the...(read more)

List of Random PCs by Condition

Garth Jones — Wed, 16 Jun 2010 21:56:45 GMT

Here is a nice and simple way to get a list of Random PCs. Create a query based on what you want to find, in my example Windows XP. Then add to the query a condition to find those with a “3” as the last character in the SMSID, Since the SMSID/GUID...(read more)

Vista without SP1 or SP2 (WQL)

Garth Jones — Sun, 13 Jun 2010 14:55:33 GMT

select R.Name, OS.Caption, OS.CSDVersion from SMS_R_System R inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId where ...(read more)