...your virtual communITy
Welcome to Sign in | Join | Help
in Search

Garth Jones

May 2009 - Posts

  • June 18th 2009 User Group Meeting

    Topic: Introduction to Microsoft System Center Data Protection Manager 2007 SP1 (DPM).


    Through discussions and demonstrations, we will be covering installation and configuration in DPM . We will talk about common situations and look at how DPM can meet these needs.

    Presenter Bio:

    Islam Gomaa is a Senior Systems Administrator at e-academy. He has over eight years of experience in IT in a Windows Server environment.  Additionally, he has 3 years of experience deploying and implementing System Center Data Protection Manager in several sites. Islam is a member of the Ottawa Windows Server User Group executive committee and the Team Lead of the SharePoint study group.

    5:00 p.m.  Event registration
    5:30 p.m.  Presentation
    7:30 p.m.  Q & A
    8:00 p.m.  Door Prizes

    Microsoft Canada Co.
    100 Queen Street Suite 500
    Ottawa, ON K1P 1J9


    • Pizza and Pop will be served, Please RSVP to help us order enough of both.
    • Please note that no one will be admitted after 5:55 p.m.!


  • How to Start a User Group

    1. Don’t, it is a lot of work!

    a) Look for existing User Groups (UG) in your area. Even if they are not what you looking for (Developer, IT Pro, SQL, *nix, Apple, etc.). Contact them to see if they know of a groups in your area.

    b) Contact other User Groups that are not within your area and ask them if they know of any UG in your area.

    c) Ask your MS Technical Account Manager (TAM), what UG exist in your area.

    2. Start a Study Group (SG) (2-60 member)

    Once you have determine that there is no user group in your area, start a study group.

    a) Determine which exam you would like to do for yourself.

    b) Determine the rough cost

      • Book $65
      • Exam $125
      • Party $10; yes a party!
      • Extras ??? (awards; snacks; etc.)
      • Remember the SG is not TRAINING, members should have some experience with the product already and are looking to get certified.

    c) Determine rough Schedule (maximum 16 weeks, any long and people start to lose interest, but not too short < 8, otherwise if people miss one session they tend to drop out of the rest SG )

    d) Contact all UG and ask them to have people interested in join a study group contact you.

    e) Tell your TAM that you are creating a SG. Ask them to spread the word.

    f) Cap the SG at max 20 people, anything more is just too hard to manage.

    g) Find a location to host the event

      • Training centers (CPLS)
      • Your office boardroom
      • Library
      • Etc.

    h) Split the group into 3-4 teams

      • Elect a team leaders
      • The team leader is responsible to ensure that their team is ready for their respect week’s material. (~3rd week)

    i) Have each team write and present summaries of each section they are responsible for.

    j) Insist that all members help with the group and all of them present to the group.

    k) Try to find a MCT to help with the final review/ preparation for the exam

    l) Have a close out party

      • Invite all members
      • Invite who ever agree to let you host the SG
      • Invite local MS technical audience team
      • Give a plaque to the person that passed the exam first.
      • Give a plaque to the meeting place as a ”Thank you”; This will go along to getting you into their good books and maybe they will agree to let you doing it again.
      • Give a plaque to the MCT / person who helped out with the exam review
      • Give a plaque to team leaders
      • Pay for snacks

    m) Repeat for the next exam (keep it to no more that 3 exams per year.)

    3. Start a Special Interest Group (SIG) (30 – 300 members with 20 regular/key members)

    Now that you have a core group of people that have work together for a while, this is the time to move to the SIG. The reason for a SIG are clear, UG are allot of work! An established UG can help out with things like they already have:

    a) All ready have a base of users to draw from for event

    b) All ready have a web site with maybe:

    • Forums
    • Mailing list
    • Blogs

    c) Usually they already have a meeting place setup, that you might be able to use.

    d) You will be able to leverage the existing UG knowledge and resources such as:

      • Contacts (MS, Training Centers, Sponsors)
      • Other Events / UG / SIGs
      • Marketing (yes everyone needs to think about marketing)
      • Privacy statement
      • Access to

    e) Set a meeting date to create the SIG

    f) Ask the UG for an email address used for contacting the SIG

    g) Ask the UG announce in their newsletter / RSS / forums the creation of the SIG & the first meeting.

    h) Create an executive board

      • Give all Exec titles (don’t underestimate this! This allow them to put it on their resume, thereby making them more willing to help out more)
      • Get all Exec committee business cards

    4. Once the SIG is going

    a) First event

    b) Ask the UG what they typically do at an event, what you need for an event and how many people they generally get for an event.

    c) Ask to host one event. (60+ day away) This allows for time to set things up and the get the word out about the event.

    d) Ask EVERY to see if you can get money to host an event. (door prize / food / etc.)

      • MS marketing groups
      • MS technical audience team
      • Local contracting firms
      • Training centers
      • Etc.

    e) Select a topic

      • Avoid sales pitches!
      • Avoid marketing stuff

    I’m sorry to say but no one want to see market and sale pitch stuff. If they did then they would call the vendor themselves!

    f) Find an presenter

      • TAMs
      • Local contractors
      • MCT
      • MVPs
      • Yourself!

    g) Market the event!

    h) Create evaluation forms for the event

      • Ask what the next topic for the SIG should be

    i) Get a domain name and point it to your space on the UGs website (

    J) After the first event ask the UG if you can host one – three events a year

    k) Arrange to have some of the SIG executives on the UG executive board!

    l) After a while get your own bank account, make sure that you pay your fair share of UG costs

      • Website
      • Close out party
      • Your event costs
      • Etc.

    m) Don’t forget to keep the Study group going! This helps everyone.

    n) Partner with as many UGs as your can!

    5. Start a user group (UG)(100+ members, with 40+ regular/key members)

    Now that you have a strong base, This is where you need to start working on truly formalizing the group. This is also the place where the UG is likely to fail! Until now it was mostly run by a few people maybe even one person. The key task here is to help the UG grow and work on what happens if one or two of the key members (Executive Board) can no long continue working to help the User Group.

    a) Expand the UG Exec Board (12-20 people)

    b) Get UG member to help out with event and offload as much as possible so that no one person will bring the UG down if they stop helping out.

    c) Talk to the original UG, work out details so that neither group fails when the new UG spins off

      • Make sure that event date don’t overlap
      • Try to work with them on common dates UG1 on 1st Thursday of the month, UG2 on 3rd Thursday of the month

    d) Arrange for joint close of season party with all UGs. Many members will belong to more than one UG.

    A strong user group is one that serves the IT community at all technical levels and will survey the lost and any one key member. Remember these are guidelines there are no hard and fast rules. As the famous MS saying goes “Your mileage will vary”.

    Above all else, Have Fun! When any of this seem like work, this is when it will fail.

  • Adding collection name to query

    SELECT @CollectionID as 'collection', CS.Model0 as Model, COUNT(*) AS 'Count'
    inner join v_R_System R on CS.ResourceID = R.ResourceID
    inner join v_FullCollectionMembership FCM on FCM.ResourceID = R.ResourceID
    Where FCM.CollectionID = @CollectionID
    GROUP BY CS.Model0
    ORDER BY CS.Model0

    Posted May 22 2009, 08:51 AM by Garth with no comments
    Filed under: , , ,
  • Order by 2

    RIGHT(LEFT(R.Name0, 6), 3) AS 'Site',
    RIGHT(LEFT(R.Name0, 9), 3) AS 'Code'
    dbo.v_R_System R
    Order by

    Posted May 19 2009, 04:08 PM by Garth with no comments
    Filed under: , , ,
  • Replaced!


    To quote Ellen’s Facebook page..


    “We have a dog in the house again, and this one is finally ours to keep. Yesterday we brought home a four-year-old Labrador Retreiver (black of course). She's a country girl, and has lived all her life so far in the Lanark Highlands with lots of room to play, lots of playmates and a river to swim in, so there will be some adjusting to being in a one-dog household in the suburbs. She's pretty laid back, so she seems to be settling in so far. She's actually a retired show dog (Cdn. CH Hunterleigh's Mrs. McNabb) so she has spent some time "off the farm". The origin of her name is that she was born on Superbowl Sunday 2005. Apparently she is only called "Mrs. McNabb" when she's in trouble; the rest of the time she is "McNabby" or just "Nabby" for short.

    Garth is already saying that he has been replaced :) but it will be nice to have a dog around again, especially when he's away, and it will be even more incentive to go for our walks.”



  • Clients without Hardware information (WQL)

        SMS_R_System left outer join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId
        SMS_G_System_OPERATING_SYSTEM.CSDVersion is null

    Posted May 18 2009, 03:48 PM by Garth with no comments
    Filed under: , , ,
  • We are now +1

    Well not really but Ellen and I did drove out to the a Labrador breeder today and we picked up a new Labrador. She is not a puppy but a 4 year old dog who was a show champion show dog too! More to come on that later, or check out Ellen’s facebook page, I’m sure that she will have picture up there before I do.

    Also while driving we saw an ad for a restaurant that we are going to check out the next time we are in that neck of the woods Castlegarth, we will let you know how it is.

  • $300,000 worth of training

    CTE Solutions, (Yes, the same training center that helps out with both the User & Study Groups) will donate $300,000 worth of training to recently laid off tech workers in Ottawa, equating to around 150 participants to be instructed over the coming summer months.

    CTE Solutions was founded seven years ago during the depths of the last tech wreck, after its founders (yes, Kim was one of them! and so was Mia & Gerry, et al) were themselves laid off from a bankrupt firm – said late Monday that it will offer courses in various Microsoft and Java applications, among other areas, meant to increase the marketability of tech workers affected by the economic downturn.

    Each class will hold up to 14 participants and will be held weekly throughout the summer, CTE said. Potential participants will need to show proof of previous full-time tech employment and are asked to apply online at


    Examples of some of the course they are donating are:

    • Microsoft SharePoint Services 3.0 and SharePoint Server 2007 (5 days)
    • Configuring, Managing, and Maintaining Windows Server 2008 (5 days)
    • Microsoft Visual Basic .NET Programming (5 days)
    • Maintaining a Microsoft SQL Server 2008 Database (5 days)
    • Business Analysis Boot Camp (4 days)
    • ITIL V3 Foundation Training and Certification (3.5 days)
    • Java Programming Language (5 days)


    And don’t forget to join the user group too!

  • June 3rd 2009 User Group Meeting

    Topic: Windows 7 Security Tidbits & Understanding and Preventing Insider Threat


    Windows 7 Security Tidbits - Windows 7 is coming and the boss is asking you about all those new security features. Perhaps you've heard some buzz about AppLocker? What’s this about DirectAccess connecting securely to your corporate network without a VPN?  What’s up with BitlLocker To Go? In this fun and interactive session, Kai Axford, a Microsoft Senior Security Strategist with Microsoft’s Trustworthy Computing team, will demonstrate some of the new security features in Microsoft's newest desktop operating system. Bring your questions and get the scoop on these upcoming Microsoft security technologies!

    Understanding and Preventing Insider Threat – Many analysts have stated that the Number One issue facing corporate customers today is the threat of targeted corporate espionage coming from within the organization. Join Kai Axford, a security strategist from the Microsoft Trustworthy Computing team for an entertaining and engaging session, as he shares real stories from the trenches about the risk this threat presents for both you and your customers. He’ll demo the means by which these attacks occur and discuss the mindset of the attackers. Don’t miss the chance to see how this is done!


    Kai Axford (CISSP, MCSE-Security) is a Senior Security Strategist in Microsoft’s Trustworthy Computing Group.

    A ten-year Microsoft veteran, Kai is responsible for discussing and recommending security solutions for both private and public sector organizations. In addition, he conducts Chief Security Officer councils worldwide, taking executive feedback and affecting change within Microsoft’s security products and processes.

    Kai started with Microsoft in 1999 as a Server Support Engineer and then moved on to become an IT Pro Evangelist, focusing on his peers through the Microsoft TechNet Events program. Kai has delivered more than 300 security presentations on a variety of topics, including digital forensics, security management, incident response, and computer espionage. He is a frequent speaker at security conferences, executive meetings, and business seminars around the world.

    He is finishing an MBA in Information Assurance and is a member of ISSA, INFRAGARD, ASIS, and the North Texas Electronic Crimes Task Force. He was the recipient of the 2006 “Rising Star” award from the Information Security Executive council. Kai is interested in security management and hopes to become a Chief Security Officer one day.

    Prior to Microsoft, Kai served as a leader in several real-world operations with the U.S. Army's elite 75th Ranger Regiment. Originally from Wisconsin, Kai is a huge NFL Green Bay Packers fan.  He is based in Dallas, Texas with his lovely wife, a new baby boy, and a (very wet) yellow Labrador.

    Microsoft Canada Co.
    100 Queen Street Suite 500
    Ottawa, Ontario
    K1P 1J9


    5:00 p.m.  Event registration
    5:30 p.m.  Q & A
    8:00 p.m.  Door Prizes


    · Pizza and Pop will be served, Please RSVP to help us order enough of both.

    · Please note that no one will be admitted after 5:55 p.m.!


  • ITProtini

    At MMS there as a ITProtini for the closing party, I never has a chance to try it but there is the ingredients list. (Thanks you, to Paul T.) I have guessed that the proportions.

    Drink type: Martini

    Glassware: Martini

    Mixing: Shaken

    ¾ oz Blackberry vodka

    ¾ oz black cherry vodka

    ½ oz cranberry juice

    ½ oz pineapple juice

    ½ oz simple syrup

    Posted May 11 2009, 01:29 PM by Garth with no comments
    Filed under: ,
  • Report Tweaking Help - Installed Date

        v_R_System sys
        JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
        JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
        DisplayName0 = @displayname
        and fcm.CollectionID=@CollID

    Posted May 07 2009, 09:53 AM by Garth with no comments
    Filed under: , , ,
  • List of Device with SNMP string


    Posted May 07 2009, 07:19 AM by Garth with no comments
    Filed under: , , ,
  • Used HD Space

    (LD.Size0 - LD.FreeSpace0) as Used
    LD.ResourceID = CS.ResourceID
    AND LD.DriveType0=3

    Posted May 04 2009, 02:30 PM by Garth with no comments
    Filed under: , , ,
  • ConfigMgr Child Labor Video

    Jarvis did and excellent job again with his new video.


    Like Jarvis’ kids, I’m not just an PC, I’m a ConfigMgr Server!


    BTW, Rumour has it that Jarvis is working on a blooper reel too! I know that I want to see it!

  • Report including the AD Display name

    Select DISTINCT
        dbo.v_R_System sys
        JOIN dbo.v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
        JOIN dbo.v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
        join dbo.v_R_User ru on sys.User_Domain0 = ru.Windows_NT_Domain0 and sys.User_Name0 = ru.user_name0
        DisplayName0 = @displayname
        and fcm.CollectionID=@CollID

    Posted May 02 2009, 03:36 PM by Garth with no comments
    Filed under: , , ,

This Blog




Powered by Community Server (Non-Commercial Edition), by Telligent Systems