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-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-671
• 70-672
• 70-673
• A+
• Canada
• Code
• ConfigMGr
• EnergizeIT
• Enhansoft
• exam
• Flowcharts
• Fun Links
• Hyper-v
• Joke
• MCSE
• MDT
• MMS
• MOM
• MS Support
• MSN
• MVP
• myITforum
• OpsMgr
• Ottawa
• Podcast
• Q&A
• Rant
• SCCM
• SCE
• SCMDM
• SCSM
• SCVMM
• self-study
• SMS
• SMS Installer
• SMSI
• SoftGrid
• SQL
• Study group
• System Center
• Training
• User Groups
• Virtual Server
• Vista
• VS 2008
• Windows 2003
• Windows 2008
• Windows 7

• 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

• 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 to MyITForum (MIF). Why do I do it? Well as a User Group leader for www.OWSUG.ca , I know how much it cost... Posted Jan 08 2009, 09:23 AM by Garth with | with no comments Filed under: SQL, SMS, Virtual Server, Joke, User Groups, Code, MOM, SoftGrid, System Center, MS Support, Canada, Study group, WQL, 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, Ottawa, 70-620, 70-536, 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, MCSE, Hyper-v, MDT, 70-635, 70-671, 70-672, 70-673

• Job posting

  Make sure that you stop by the OWSUG Job forums. There have been 10 new posting within the last month with more that half of them for Microsoft! Posted Dec 03 2008, 03:47 PM by Garth with | with no comments Filed under: SQL, SMS, Virtual Server, User Groups, Code, MOM, SoftGrid, System Center, MS Support, Fun Links, Canada, Study group, WQL, 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, Ottawa, 70-620, 70-536, 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, MCSE, Hyper-v, MDT, 70-635

• WQL - PCs with more that 2 GB free on C:

  select distinct SMS_R_System.Name, SMS_G_System_LOGICAL_DISK.* from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_LOGICAL_DISK.FreeSpace > 2048 and SMS_G_System_LOGICAL_DISK... Posted Sep 24 2008, 03:56 PM by Garth with | with no comments Filed under: SMS, Code, WQL, ConfigMGr

• Blog Statistic – Part 2

  Just after posting the blog stats, I remember that I also want to check out that number of ping backs and comments. Since April 1 2007 there have been 181 ping backs and 22 comments select count(*) as '# of Comments' from cs_Posts cs_Posts, cs_Sections... Posted Jan 20 2008, 09:03 PM by Garth with | with no comments 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