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

Garth Jones

April 2009 - Posts

  • Harrah’s short cut

    There is a short cut from Harrah’s to the Sands expo.

    1. Starting at the Reception desk , exit Harrah’s Turn left

    2. Go to the Bus area

    3. Near the end of the Bus area, look for the ramp to the Sands Expo (there is a sign)

    4. Like this


    5. Walk through the parking garage.

    6. Take the elevator to the 3rd level

    7. You end up near the blue star


    8. Go down the Escalator (next to 12 on the map above)

    9. Now this is where you should meet up with anyone staying at the Venetian as it is right next to the Elevators to their rooms. See blue star below.

    10. Finally keep to the right all the way to the Expo. This shaves off at least half the distance vs going the street way.


  • Using Datediff & GetDate in WQL

    Normally I wouldn’t post a reply to blog post but in this case I had too.

    So I was reading this blog Creating a Collection Query based upon Hardware Inventory, and this blog too and I notice that Chris posted a blog about editing your ConfigMgr / SMS database.

    1. You SHOULD never edit your database! This is just asking for trouble.
    2. Editing your database directly is NOT SUPPORTED by Microsoft; it is one thing to use the SDK to make changes to ConfigMgr / SMS but…
    3. The problem he is trying to solved was fixed in SMS 2003 SP1 or SP2.

    Now the problem as I see it, is he want to create a collection of all WS that have provided hardware inventory in the last 5 days. Well back in SMS 2003 SP1 (maybe SP2) Getdate(), DateDiff() and DateAdd() were added to WQL functionality. So there is no need to do this hack and it is unnecessary to do this.


    In Greg’s blog, He provide the WQL code to:

    • All systems that have reported a LastHardwareScan date within the last 30 days:
    • All systems that have been discovered since midnight:


    I have created this WQL query to more or less matching what Chris is looking for.





    SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId


    DATEDiff(DD, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan, Getdate()) < 5

    Posted Apr 22 2009, 08:35 PM by Garth with 1 comment(s)
    Filed under: , ,
  • When was a Software Update applied (SMS 2003)

    join dbo.v_GS_PATCHSTATEEX PSE on CS.ResourceID = PSE.ResourceID

    Posted Apr 16 2009, 07:30 AM by Garth with no comments
    Filed under: , ,
  • Get out and Vote!!! We need your Help!!


    As you know, BoF sessions are selected and scheduled based on popular “vote” through the MMS Commnet site.

    At this BoF session Steve Kaczmarek and Doug Eby from the Configuration Manager writing team will showcase several  of the newest SuperFlows currently in development or available for publishing. A SuperFlow is a downloadable interactive content model that provides troubleshooting, process flow and other data flow information in an interactive format. We will also demonstrate an authoring template we have developed that can be used to create SuperFlows.


    This session fell off the list somehow, and now is back on, so if you are attending MMS this year, would consider “voting” for it – and urging your fellow attendees to vote also? Voting is extended through the end of this week.


    Thanks for your help in this, and for your ongoing support!

    Posted Apr 07 2009, 08:22 PM by Garth with no comments
    Filed under:
  • Coffee and code (latte and lan)

    I got this note this morning that you will find interesting.

    BTW It is happening April 7th between 8am and 4 pm, I will be there from 2ish on, before I go to the user Group event that night, which starts at 5:30!

    From: Pierre Roman
    To: Garth Jones
    Subject: Coffee and code (latte and lan)

    Hey Garth,
    As we discussed this morning, here are the coordinates for the coffee and code.

    Coffee and code is an opportunity us and all professionals to meet in a casual settings and discuss technology issues, projects, etc...

    It will be at Bridgehead on the corner of Bank and Albert. Here’s the map:

    The web site for Bridgehead is right here:  - Free Wifi and lot’s of space.

    We hope to see a lot of you there. Thanks for spreading the word for us.
    Pierre Roman

  • software not installed

    Select Distinct
        v_R_System sys
        JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
        sys.ResourceID not in (select sys.ResourceID
                                    v_R_System sys
                                    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
                                    DisplayName0 =  @displayname)

    Posted Apr 01 2009, 08:47 AM by Garth with no comments
    Filed under: , , ,

This Blog




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