Browse by Tags

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

• Dynamic Subnet Collection

  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    ... Posted Jul 16 2010, 11:02 AM by Garth with | with 1 comment(s) Filed under: SMS, Code, WQL, SCCM, vNext

• SMSUG.ca Forums

  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... Posted Jul 01 2010, 08:44 AM by Garth with | with 1 comment(s) Filed under: SQL, SMS, Virtual Server, Joke, User Groups, Code, MOM, SoftGrid, System Center, MS Support, Fun Links, Canada, Study group, WQL, EnergizeIT , ConfigMGr, Flowcharts, 70-622, 70-293, self-study, MVP, VS 2008, Windows 2008, Podcast, Training, OpsMgr, 70-299, 70-640, 70-643, 70-642, 70-401, 70-400, UK, Ottawa, 70-620, 70-536, CTE Solutions, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, 70-624, Q&A, 70-298, A+, Windows 2003, 70-649, 70-646, 70-647, 70-431, TechDays Canada, Sector, MCSE, Hyper-v, MDT, 70-635, 70-671, 70-672, 70-673, Drinks, 70-631, 70-089, MMS, DPM, Enhansoft, Poll, RobertHalf, Microsoft Canada, DevTeach, Redgate, myITforum, Rant, 70-236, 70-630, 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

  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... Posted Jun 16 2010, 04:56 PM by Garth with | with 3 comment(s) Filed under: SMS, Code, System Center, WQL, ConfigMGr, vNext

• Vista without SP1 or SP2 (WQL)

  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    ... Posted Jun 13 2010, 09:55 AM by Garth with | with no comments Filed under: SMS, System Center, WQL, ConfigMGr, vNext

• Routers?

  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... Posted Jan 20 2010, 09:45 AM by Garth with | with 1 comment(s) Filed under: Code, WQL, ConfigMGr, SCCM

• 2010 myITforum 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). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know... Posted Jan 07 2010, 01:39 PM by Garth with | with 2 comment(s) Filed under: SQL, SMS, Virtual Server, User Groups, Code, MOM, System Center, MS Support, Fun Links, WQL, ConfigMGr, 70-622, 70-293, self-study, VS 2008, Windows 2008, Training, OpsMgr, 70-299, 70-640, 70-643, 70-642, 70-401, 70-400, 70-620, 70-536, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, 70-624, Q&A, 70-298, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, MDT, 70-635, 70-671, 70-672, 70-673, 70-631, 70-089, MMS, Enhansoft, myITforum, Rant, 70-236, 70-630, Windows 7, MSN, SCCM, SMSI, SMS Installer

• Collection Query - AD group membership & filter for Add\Remove Programs

  select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ... Posted Jan 04 2010, 08:08 AM by Garth with | with no comments Filed under: SMS, Code, System Center, WQL, ConfigMGr, SCCM

• Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0

  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      ... Posted Dec 04 2009, 10:04 AM by Garth with | with 1 comment(s) Filed under: SQL, SMS, System Center, WQL, ConfigMGr, SCCM

• Attribute Reference Query

  select     SMS_R_System.ResourceId,     SMS_R_System.ResourceType,     SMS_R_System.Name,     SMS_R_System.SMSUniqueIdentifier,     SMS_R_System.ResourceDomainORWorkgroup,    ... Posted Nov 14 2009, 09:15 AM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr, SCCM

• Find all non-client PCs

  :-) at the suggestion of a friend here is a query to find all non-client PCs. select                SMS_R_SYSTEM.ResourceID,               ... Posted Nov 10 2009, 09:37 AM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr

• No HW inventory in the last 30 days.

  select     SMS_R_SYSTEM.ResourceID,     SMS_R_SYSTEM.ResourceType,     SMS_R_SYSTEM.Name,     SMS_R_SYSTEM.SMSUniqueIdentifier,     SMS_R_SYSTEM.ResourceDomainORWorkgroup,    ... Posted Nov 10 2009, 08:51 AM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr

• A Collection based on Domain name

  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.Domain = "<domain... Posted Aug 28 2009, 09:15 AM by Garth with | with no comments Filed under: SMS, WQL, ConfigMGr

• List of PCs with Excel (WQL)

  select     R.NetbiosName,     R.LastLogonUserName,     SP.ProductName,     SP.ProductVersion from      SMS_R_System R     inner join SMS_G_System_SoftwareProduct... Posted Aug 06 2009, 08:01 PM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr

• Clients without Hardware information (WQL)

  select     *  from      SMS_R_System left outer join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where     SMS_G_System_OPERATING_SYSTEM.CSDVersion... Posted May 18 2009, 03:48 PM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr

• Adding Display name to "All Systems" query

  select r.Name, r.SMSAssignedSites, r.IPAddresses, r.IPSubnets, r.OperatingSystemNameandVersion, r.ResourceDomainORWorkgroup, ru.name, r.LastLogonUserDomain, r.LastLogonUserName, r.SMSUniqueIdentifier, r.ResourceId, r.ResourceType, r.NetbiosName from sms_r_system... Posted Feb 20 2009, 10:52 AM by Garth with | with no comments Filed under: SMS, WQL, ConfigMGr