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

Query for computers with single partition
Saturday, June 09, 2012 5:53 PM

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.DeviceID = " Disk #0, Partition #1 "... Read More...

by Garth Jones

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

How to exclude a collection from sccm collection query
Saturday, May 19, 2012 10:47 AM

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, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile... Read More...

by Garth Jones

Filed under: ConfigMGr, System Center, Code, WQL, SCCM

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

Collection by Gateway
Friday, March 18, 2011 3:28 PM

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.DefaultIPGateway = "192.168.1.1" Read More...

by Garth Jones

Filed under: SMS, System Center, Code, WQL, SCCM

Client Version and model
Wednesday, March 09, 2011 10:39 PM

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 on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System... Read More...

by Garth Jones

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

List PCs within a Security Group
Sunday, February 13, 2011 10:39 PM

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

by Garth Jones

Filed under: ConfigMGr, System Center, Code, WQL, SCCM

PCs without SEP
Tuesday, January 11, 2011 6:52 PM

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.ResourceID from   SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS... Read More...

by Garth Jones

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

PC with app x but exclude PC y
Friday, October 08, 2010 6:27 AM

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.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like... Read More...

by Garth Jones

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

Find PCs like TTDRxxxACxxWxxx
Friday, September 03, 2010 11:01 AM

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

by Garth Jones

Filed under: ConfigMGr, SMS, System Center, Code, WQL, vNext

Dynamic Subnet Collection
Friday, July 16, 2010 12:02 PM

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     SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "192.168.1.%" Read More...

by Garth Jones

Filed under: SMS, Code, WQL, SCCM, vNext

SMSUG.ca Forums
Thursday, July 01, 2010 9:44 AM

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 new site will come a new look a feel. (wait for it)   If you are looking for ConfigMgr , SCCM , SMS, v.Next... Read More...

by Garth Jones

Filed under: Joke, Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, Study group, SMS, OpsMgr, Canada, Fun Links, SoftGrid, 70-299, 70-640, 70-643, EnergizeIT, 70-642, MS Support, Training, Windows 2008, self-study, Podcast, System Center, UK, Ottawa, 70-620, 70-536, CTE Solutions, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, MVP, Code, VS 2008, 70-624, Q&A, 70-298, A+, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, TechDays Canada, Sector, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, Flowcharts, Drinks, 70-631, 70-089, MMS, DPM, Enhansoft, Poll, RobertHalf, Microsoft Canada, DevTeach, Redgate, myITforum, Rant, 70-630, 70-236, VMRCPlus, Windows 7, MSN, SCCM, SP2, SMSI, SMS Installer, Microsoft, Zune, App-v, Med-V, 70-669, Windows XP, Samsung, mobile, 70-432, vNext

List of Random PCs by Condition
Wednesday, June 16, 2010 5:56 PM

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 is HEX this will give you ~1/16 of all of those PCs.   select               ... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, System Center, Code, WQL, vNext

Routers?
Wednesday, January 20, 2010 9:45 AM

This might NOT list all routers in your environment, and it will has lots of false positives too.   Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives.   In my test lab it found 3 out of 7, Routers /Switches.   Plus it lists ·         1 WS, that is not acting like routers... Read More...

by Garth Jones

Filed under: ConfigMGr, Code, WQL, SCCM

More Posts Next page »