Browse by Tags

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

WQL Query for both x86 and x64 version of Software
Monday, January 16, 2012 5:27 PM

  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.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS_64... Read More...

by Garth Jones

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

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

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

2011 myITforum.com Donation
Sunday, January 02, 2011 3:47 PM

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

by Garth Jones

Filed under: User Groups, ConfigMGr, MOM, Study group, SMS, OpsMgr, SoftGrid, System Center, SCMDM, SCSM, SCE, SCVMM, exam, MVP, WQL, MDT, MMS, DPM, myITforum, SCCM, SMSI, SMS Installer, App-v, Med-V, vNext

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

Vista without SP1 or SP2 (WQL)
Sunday, June 13, 2010 10:55 AM

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     OS.CSDVersion is null     and OS.Caption like "%Vista%" Read More...

by Garth Jones

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

2010 myITforum Donation
Thursday, January 07, 2010 1:39 PM

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). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community. OWSUG is small in comparison to MIF! Our network traffic... Read More...

by Garth Jones

Filed under: Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, SMS, OpsMgr, Fun Links, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, System Center, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, Code, VS 2008, 70-624, Q&A, 70-298, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, 70-631, 70-089, MMS, Enhansoft, myITforum, Rant, 70-630, 70-236, Windows 7, MSN, SCCM, SMSI, SMS Installer

Collection Query - AD group membership & filter for Add\Remove Programs
Monday, January 04, 2010 8:08 AM

select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ... Read More...

by Garth Jones

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

Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0
Friday, December 04, 2009 10:04 AM

Take the following query, if you only used v_R_System . Operating_System_Name_and0 then you would have no idea as to which PCs are installed with “Microsoft Windows 7 Ultimate" or “Microsoft Windows 7 Professional”.     Select       R . Name0 ,       R . Operating_System_Name_and0 ,      ... Read More...

by Garth Jones

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

More Posts Next page »