Month: June 2009

TechDays 2009 Discount Code

This fall, TechDays returns with more deep technical training on the very latest Microsoft technologies, and I’m excited to be able to offer you a special VIP price of just $249 until July 1. After July 1st the early bird price will be $299. Don’t miss this chance to build your skills and share — […]

New use for Twitter

It summer! Last night I was sitting on a patio talking with some friends. The subject came up what things we like to do during a teen years. Well the drive-in was tops on everyone list. This reminded me that there is a drive-in about 45 minutes away from my place. So today, While working […]

Adding collection name to query

SELECT @CollectionID as ‘collection’, CS.Model0 as Model, COUNT(*) AS ‘Count’ FROM v_GS_COMPUTER_SYSTEM  CS 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

What is Your biggest pain point?

What is Your biggest pain point? Monitor power options Monitor serial number accuracy Native monitor resolution information Automatic documenting your environment (Servers, SQL, SCCM, etc) Printer Information (Local vs network, who is connected to which network printer) USB device data Other To vote please visit: (Only one vote per IP address)


  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 […]

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 […]

List PCs with Dup Serial Numbers

Select     CS.Name0,     Bios.SerialNumber0 From     dbo.v_GS_COMPUTER_SYSTEM CS     join dbo.v_GS_PC_BIOS Bios on CS.ResourceID = Bios.Resourceid Where     Bios.SerialNumber0 in (Select                                 Bios.SerialNumber0                             From                                 dbo.v_GS_PC_BIOS Bios                             Group by                                 Bios.SerialNumber0                             Having                                 count(Bios.SerialNumber0) > 1 )