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
• CTE Solutions
• DevTeach
• EnergizeIT
• Enhansoft
• exam
• Flowcharts
• Fun Links
• Hyper-v
• Joke
• MCSE
• MDT
• Microsoft Canada
• 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
• SP2
• SQL
• Study group
• System Center
• TechDays Canada
• Training
• UK
• User Groups
• Virtual Server
• Vista
• VS 2008
• Windows 2003
• Windows 2008
• Windows 7
• WQL

• ConfigMgr / SCCM Documentation Script v1.24

  The ConfigMgr / SCCM documentation script has been updated to v1.24 for more details please see http://tinyurl.com/yfpgocw Posted Mar 02 2010, 09:58 AM by Garth with | with no comments Filed under: Code, System Center, ConfigMGr, Enhansoft, SCCM

• Office Count

  select     DisplayName0,     Version0,     Count(*) From     dbo.v_Add_Remove_Programs ARP Where     DisplayName0 like '%office%' Group by     DisplayName0... Posted Mar 01 2010, 03:45 PM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr

• Customized Report "computers with specific software registered in Add Remove Programs"

  SELECT Distinct         sys.Netbios_Name0,     fcm.SiteCode,     sys.User_Domain0,     sys.User_Name0,     sys.Operating_System_Name_and0,    ... Posted Feb 14 2010, 10:35 AM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr, SCCM

• 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

• Null and Not like

  SELECT     DisplayName0,     Count(*) AS 'Count',     Publisher0,     @CollID as CollectionID FROM     v_Add_Remove_Programs arp     JOIN v_FullCollectionMembership... Posted Dec 31 2009, 08:51 AM by Garth with | with 1 comment(s) Filed under: SMS, Code, System Center, ConfigMGr, SCCM

• management nightmare

  SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 , OS . Caption0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID INNER JOIN dbo . v_GS_OPERATING_SYSTEM OS ON OS . ResourceID = ARP . ResourceID... Posted Dec 23 2009, 02:31 PM by Garth with | with no comments Filed under: SQL, SMS, Code, ConfigMGr, SCCM

• OS version using v_R_System

  select R . Name0 , R . Operating_system_Name_And0 from dbo . v_R_System R Where r . ResourceId not in ( Select ResourceId from dbo . v_R_System R where r . Client_Version0 <> '' ) and R . Operating_system_Name_And0 <> '' order... Posted Dec 21 2009, 01:03 PM by Garth with | with 1 comment(s) Filed under: SMS, Code, System Center, ConfigMGr, SCCM

• Limiting to a Collection.

  SELECT Distinct R . Netbios_Name0 , ARP . DisplayName0 FROM dbo . v_R_System R INNER JOIN dbo . v_GS_ADD_REMOVE_PROGRAMS ARP ON R . ResourceID = ARP . ResourceID Inner Join dbo . v_FullCollectionMembership FCM ON R . ResourceID = FCM . ResourceID... Posted Dec 14 2009, 10:02 PM by Garth with | with no comments Filed under: SQL, SMS, Code, 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

• Servers Report Query

  SELECT         R.Netbios_Name0,     os.Caption0,     ARP.DisplayName0 As 'Softwarename',     ARP.Publisher0 as 'Publisher',     ARP.Version0... Posted Dec 04 2009, 08:14 AM by Garth with | with 2 comment(s) Filed under: SQL, SMS, Code, System Center, ConfigMGr, SCCM

• System Center Configuration Manager 2007 with Service Pack 2 (x86) - DVD (English) is now available on TechNet.

  The fully integrated ConfigMgr 2007 with SP2 is now available on TechNet. Now you can install with SQL 2008 from the start, no upgrading from SQL 2005.   Posted Dec 04 2009, 07:55 AM by Garth with | with 3 comment(s) Filed under: System Center, ConfigMGr, SCCM, SP2

• Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 (6451a) in Ottawa

  If you are looking to take this course, I have been told that CTE Solutions will be running 6451a course the week of Dec 14th - 18th 2009. http://www.ctesolutions.com/course/Systems-Center-Training/Systems-Center-Configuration-Manager-2007-Training.htm... Posted Dec 02 2009, 02:22 PM by Garth with | with 1 comment(s) Filed under: User Groups, ConfigMGr, Training, CTE Solutions, SCCM

• ConfigMgr and OpsMgr Exam Discounts

  Are you looking to become certified on ConfigMgr 2007 (70-401) or OpsMgr 2007 (70-400)?   Well you are in Luck! Prometric is offering a 20% discount on both exam! http://www.prometric.com/Microsoft/CareerOffer.htm#vouchers20   So what... Posted Nov 27 2009, 11:08 AM by Garth with | with 1 comment(s) Filed under: ConfigMGr, Training, OpsMgr, 70-401, 70-400, exam, SCCM