SMSUG.ca

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

Garth Jones

February 2009 - Posts

  • Twice in one week!

    OK What gives...? I have travelled a fair bit in the pasted but never have had so many problems with airlines! This week I have been on two trips and in BOTH cases the airline has lost my luggage!!!

    What up with that??

    BTW for those of you looking for me, I am checked into my room now.

    On a side note, in both case I have gotten a toiletry bag and I have to say that the Air Canada bag is better as you get a plain white t-shirt and laundry soap along with all the normal stuff. Continental Airlines you get the normal stuff (toothbrush, toothpaste, brush, shaving cream shaver and anti-perspirant) plus hair spray!

  • Patch compliance progression report

    select

          CS.Name0,

          CS.UserName0,

    case

    when (sum(case when UCS.status=2 then 1 else 0 end))>0 then ('Needs '+(cast(sum(case when UCS.status=2 then 1 else 0 end)as varchar(10))+ ' Patches'))

    else 'Good Client'

    end as 'Status',

          ws.lasthwscan as 'Last HW scan',

          FCM.collectionID--,

    from

          v_UpdateComplianceStatus UCS

    left outer join dbo.v_GS_COMPUTER_SYSTEM  CS on CS.ResourceID = UCS.ResourceID

    join v_CICategories_All catall2 on catall2.CI_ID=UCS.CI_ID

    join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID and catinfo2.CategoryTypeName='UpdateClassification'

    left join v_gs_workstation_status ws on ws.resourceid=CS.resourceid

    left join v_fullcollectionmembership FCM on FCM.resourceid=CS.resourceid

    Where

          UCS.Status = '2'

    and FCM.collectionid = 'SMS00001'

    Group by

          CS.Name0,

          CS.UserName0,

          ws.lasthwscan,

          FCM.collectionID

    Order by

          CS.Name0,

          CS.UserName0,

          ws.lasthwscan,

          FCM.collectionID

    Posted Feb 25 2009, 03:07 PM by Garth with 8 comment(s)
    Filed under: , , ,
  • 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 r,
        sms_r_user ru
    Where
        r.LastLogonUserDomain = ru.WindowsNTDomain
        and r.LastLogonUserName = ru.UserName

    Posted Feb 20 2009, 10:52 AM by Garth with no comments
    Filed under: , ,
  • EnergizeIT 2009: From the Client to the Cloud - Learn What's Possible!

    Hello Canadian IT Pros and Developers,
    Current economic realities are putting pressure on all of us to utilize technology in new ways. From increasing productivity, reducing costs, and providing clear benefit to the business, each of you play a key role in making this real. Your ability to understand the technology possibilities to help solve real-world requirements is more important than ever and is where you can make a difference.
    EnergizeIT 2009 is a national series of events to support you in learning what's possible. From sharing innovative solutions, connecting with peers and local experts you will learn how technology can help and in turn gain direction to take advantage of the Microsoft platform from the client to the cloud. You will see how Windows® 7 and Windows Server® 2008 R2 will provide a richer platform for Developers and IT Professionals, along with new virtualization options helping you solve key application compatibility issues.

    To see what's possible, connect and share, register now for one of the EnergizeIT 2009 events in your area!


     

     

    Ottawa

    User Group Connection: Future of the Platform

    April 7

    Learn more & Register

     

    Energize IT: From the Client to the Cloud

    April 8

    Learn more & Register

     

    Install Fest for Windows 7

    April 9

    Learn more & Register

  • Obama and OWSUG.ca event tonight

     

    YES!!! OWSUG.ca event is still on! ( I had to answer this question a few times today!) If you are really lucky you will spot Obama on your way to the event! Keep in mind that there are road closure and give yourself a bit more time to get to the MS office tonight.

     

    Also keep in mind that the main doors lock at 5:55 p.m.!

     

    P.S. I’m leaving now for the event, I should be at the MS office before 5 P.M.

    P.S.S. Free shirt to the first person who shows me a picture of him or his Limo on their cellphone tonight!

  • Groove not so Groovy!

     

    So I am add Groove to my current laptop. Groove, as part of its setup, ask the question do you have a Groove account I say yes, since I had one on my old laptop. I follow the prompts, anyway this is what I get, depending on what I pick. 

     

    image image

     

     

    Now the problem here is I have formatted my old laptop a long time ago, so there is no way to get this data back. Even better I used Windows Easy Transfer to transfer my data from one laptop the another.  So why didn’t it transfer the data? And Why doesn’t Groove give you any other options? This is very poor planning on the Groove Team’s part!  Now we will see what happens when I create an new account! I'm not holding my breath.

     

    If it doesn’t work I will go back to the old stand by and create an FTP account on my web site to get the data, that I need!

    Posted Feb 17 2009, 02:38 PM by Garth with no comments
    Filed under:
  • Count of Models by Collection

    select
        Model0,
        Count(*)
    from
        dbo.v_GS_COMPUTER_SYSTEM CS,
        dbo.v_FullCollectionMembership FCM
    Where
        CS.ResourceId = FCM.ResourceId
        And CollectionID = 'SMS00001'
    Group by
        Model0

    Posted Feb 16 2009, 09:54 PM by Garth with no comments
    Filed under: , , ,
  • I passed

     

    Today I completed my bartending course with a 88%, with some more practice I can even do some flair bartending too. So when I get tired of IT, I have another job to fall back on. J

    Posted Feb 15 2009, 08:35 PM by Garth with 1 comment(s)
    Filed under:
  • Pepe Deluxe – Cocktail Correction

    Original
    Becardi orange rum
    Banana Liqueur
    Strawberry kiwi Remy
    Pineapply Juice

     

    Update
    1 Oz. Rum
    1/2 Oz. Banana Liqueur
    1/2 Oz. Raspberry Liquor
    Strawberry Juice
    Kiwi Juice
    Pineapply Juice

    Posted Feb 14 2009, 08:13 PM by Garth with no comments
    Filed under:
  • Blue Wave – Cocktail Correction

    Original
    Grey Goose
    Raspberry Liquor
    Blue Curacao
    7up

    Update
    1 1/2 Oz. Vodka
    1/2 Oz. Blue Curacao
    1/2 Oz. Raspberry Liquor
    7UP

    Posted Feb 14 2009, 08:08 PM by Garth with no comments
    Filed under:
  • Fire Red Opal – Cocktail Correction

    Original
    Made with Ketel One Vodka
    fresh orange juice
    Cointreau
    cranberry juice
    fresh lime juice

    Update
    2 Oz. Vodka
    3 Oz. OJ
    3 Oz. Cranberry
    1 Oz. Lime Juice

    Posted Feb 14 2009, 07:37 PM by Garth with no comments
    Filed under:
  • Pomegranate Martini – Cocktail Correction

    Original
    2 Oz. Vodka
    6 Oz. 100% Pomegranate Juice- we reccomend POM brand
    1 Oz. Alize Wild Passion
    ¾ Oz. Orange Liquer
    1 Fresh Pomegranate to use seeds for garnish  

    Update
    2 Oz. Vodka
    6 Oz.  Pomegranate Juice or Cockatil
    ¾ Oz. Orange Liquer
    Optional 1 Fresh Pomegranate to use seeds for garnish  

     

    Steps
    Combine in cocktail shaker over ice.
    Shake & strain into a chilled martini glass.
    Garnish with Pomegranate seeds last.

    Posted Feb 14 2009, 07:32 PM by Garth with no comments
    Filed under:
  • John Collins - "Cocktail Correction"

    Original

    2 oz Bar Mix

    Sugar

    1 oz Rye

    Optionally topped with Soda

     

    Update 

    1 oz Rye

    Topped with Fresca

    Posted Feb 14 2009, 12:14 PM by Garth with no comments
    Filed under:
  • Old Fashion - "Cocktail Corrections"

     

    Original

    Orange, Lemon & Cherry – muddled

    Sugar

    Bitters

    1 oz Rye

    Optionally topped with Soda

     

    Update 

    Orange, Lemon & Cherry - muddled

    1 oz Rye

    Topped with Ginerale

    Posted Feb 14 2009, 12:03 PM by Garth with no comments
    Filed under:
  • Greyhound - "Cocktail Corrections"

    Original

    1 oz Vodka

    Topped with Grapefruit juice

    Update

    1 oz Vodka

    Topped with Fresca

    Posted Feb 14 2009, 11:57 AM by Garth with no comments
    Filed under:
More Posts Next page »

This Blog

Syndication

News

Training

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