February 2009 - Posts

Twice in one week!
Saturday, February 28, 2009 3:30 PM

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
Wednesday, February 25, 2009 3:07 PM

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

by Garth Jones
Filed under: , , ,
Adding Display name to "All Systems" query
Friday, February 20, 2009 10:52 AM

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

by Garth Jones
Filed under: , ,
EnergizeIT 2009: From the Client to the Cloud - Learn What's Possible!
Thursday, February 19, 2009 11:44 PM

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
Thursday, February 19, 2009 3:59 PM

 

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!

by Garth Jones
Filed under: , ,
Groove not so Groovy!
Tuesday, February 17, 2009 2:38 PM

 

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!

by Garth Jones
Filed under:
Count of Models by Collection
Monday, February 16, 2009 9:54 PM

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

by Garth Jones
Filed under: , , ,
I passed
Sunday, February 15, 2009 8:35 PM

 

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

by Garth Jones
Filed under:
Pepe Deluxe – Cocktail Correction
Saturday, February 14, 2009 8:13 PM

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

by Garth Jones
Filed under:
Blue Wave – Cocktail Correction
Saturday, February 14, 2009 8:08 PM

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

by Garth Jones
Filed under:
Fire Red Opal – Cocktail Correction
Saturday, February 14, 2009 7:37 PM

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

by Garth Jones
Filed under:
Pomegranate Martini – Cocktail Correction
Saturday, February 14, 2009 7:32 PM

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.

by Garth Jones
Filed under:
John Collins - "Cocktail Correction"
Saturday, February 14, 2009 12:14 PM

Original

2 oz Bar Mix

Sugar

1 oz Rye

Optionally topped with Soda

 

Update 

1 oz Rye

Topped with Fresca

by Garth Jones
Filed under:
Old Fashion - "Cocktail Corrections"
Saturday, February 14, 2009 12:03 PM

 

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

by Garth Jones
Filed under:
Greyhound - "Cocktail Corrections"
Saturday, February 14, 2009 11:57 AM

 

Original

1 oz Vodka

Topped with Grapefruit juice

 

Update 

1 oz Vodka

Topped with Fresca

by Garth Jones
Filed under:
More Posts Next page »

This Blog

Syndication