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-669
• 70-671
• 70-672
• 70-673
• A+
• Canada
• Code
• ConfigMGr
• CTE Solutions
• DevTeach
• DPM
• 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
• SP2
• SQL
• Study group
• Training
• UK
• User Groups
• Virtual Server
• Vista
• VS 2008
• Windows 2003
• Windows 2008
• Windows 7
• WQL

• 70-669 study guide material

  While reading another forum this morning I found this tidbit. http://www.techexams.net/forums/virtualization/51260-70-669-resources.html Posted Mar 13 2010, 09:59 AM by Garth with | with no comments Filed under: System Center, exam, 70-669

• Query for a portion of a NetBIOS Name

  select * from dbo.v_GS_COMPUTER_SYSTEM where name0 like '___m%' Posted Mar 11 2010, 08:00 AM by Garth with | with no comments Filed under: SQL, SMS, Code, System Center, ConfigMGr

• 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

• 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

• 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

• 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

• Cal Tracking and ConfigMgr SP2

  Like many of you I applied SP2 a while back and promptly added   a few classes back to the sms_def.mof, however I had enable the Cal tracking too and it is enabled within the configuration.mof. Today I realized that it was disable (default setting... Posted Nov 25 2009, 10:18 AM by Garth with | with no comments Filed under: System Center, ConfigMGr

• What Virtual Labs, Labcasts, and Webcasts are there to help you with Preparing for Microsoft System Center Configuration Manager 2007 Exam (70-401)

  Based on the Microsoft Skills Measured web page for 70-401 , here is a list of items that can help you with your studying for the exam.   Deploying a System Center Configuration Manager 2007 (SCCM) Server (9 percent) · Set up and configure an Active... Posted Oct 27 2009, 07:51 AM by Garth with | with 1 comment(s) Filed under: System Center, ConfigMGr, 70-401, exam, SCCM

• How to Perform a Basic Software Audit

  Over on the Enhansoft Blog, we posted a blog on “ How to Perform a Basic Software Audit ”. This should help answer the question of how to perform a basic software Audit and why “I need a report of all software for all PCs” is a bad idea. Posted Oct 26 2009, 08:28 AM by Garth with | with no comments Filed under: SMS, System Center, ConfigMGr, Enhansoft, SCCM

• List Collections a PC belongs to

  select FCM.CollectionId, C.Name from dbo.v_R_System r join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where R.Name0 = 'ES-03' Posted Oct 22 2009, 01:34 PM by Garth with | with no comments Filed under: SQL, SMS, Code, System Center, ConfigMGr, SCCM

• Sept 17 User Group Event: How to protect SQL Server using Microsoft System Center Data Protection Manager 2007 SP1 (DPM)

  Topic: How to protect  SQL Server using Microsoft System Center Data Protection Manager 2007 SP1 (DPM). Through discussions and demonstrations, we will be covering  how DPM offers a continuous data protection for SQL Server with simple and advance... Posted Sep 09 2009, 10:22 AM by Garth with | with no comments Filed under: SQL, User Groups, System Center, DPM