Ottawa IT Community Awards Night Picture
Wednesday, July 01, 2009 7:24 PM

Here are the photos from last night awards night

http://www.flickr.com/photos/johnhansen/sets/72157620674477495/show/

 

Here are a few that I found interesting!

Twins?

http://www.flickr.com/photos/johnhansen/3677794776/in/set-72157620674477495/

 

Let’s make a deal!

http://www.flickr.com/photos/johnhansen/3676988847/in/set-72157620674477495/

 

Did Rick need another Zune? Nope!

http://www.flickr.com/photos/johnhansen/3677003983/in/set-72157620674477495/

 

Crazy Faces?

http://www.flickr.com/photos/johnhansen/3677833710/in/set-72157620674477495/

 

Partner of the Year (Finalists)

Robert Half

http://www.flickr.com/photos/johnhansen/3677856486/in/set-72157620674477495/

Redgate

http://www.flickr.com/photos/johnhansen/3677053919/in/set-72157620674477495/

CTE Solutions

http://www.flickr.com/photos/johnhansen/3677052271/in/set-72157620674477495/

Microsoft Canada Technical Community Team

http://www.flickr.com/photos/johnhansen/3677065089/in/set-72157620674477495/

 

Partner of the Year (Winner)

Dev Teach

http://www.flickr.com/photos/johnhansen/3677076955/in/set-72157620674477495/


Happy Canada Day! (2009)
Wednesday, July 01, 2009 11:15 AM

Happy Canada Day Everyone!

 

I hope you take some time to be with family and friends today!

As all of you know we stated Canada Day off early yesterday with the Ottawa IT Community awards night, the event was a success. As soon as Rick or John post the pictures from the event, I will blog about it.


New use for Twitter
Saturday, June 27, 2009 2:17 PM

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 on a MDT/OSD issue, (I’m starting to dislike MDT and OSD!) I need to hurry up a wait, so I when searching for the drive-in web site. I found it. http://www.portelmsleydrivein.com/

When you check out their web site you will see that they create a Twitter account to announce what movie will be on each week. www.twitter.com/ptelmsleydrivin. Well I’m signed up, so now I will know which movie will be at the drive-in this year! Does you drive-in do this?


by Garth Jones
Filed under:
TechDays 2009 Discount Code
Saturday, June 20, 2009 12:33 PM

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 — Reference this code TDUGVIP and you can buy your tickets now and please share the code with whom you think would enjoy this year’s event.  Please just pass on the promo code and they’ll receive the same exclusive price!

I know this is a busy time for everyone and I commend each of you for the time you give back to the community and that why we wanted to get this out early to you as our hope is that this offer at some level can help you show more value with your user group, community and help support technical readiness across Canada.

TechDays 2009

As budgets get tighter, TechDays is the perfect way to get the Tech-Ed experience without the travel expense , with two days of skill-strengthening education to help you position yourself for success by:

· Learning the technology—with a customizable agenda from over forty skill-strengthening sessions across five technical tracks you can get the exact knowledge you want on the hottest new products.  Get the knowledge you’re looking for on both current technologies and new products, like Windows® 7, and Microsoft® Exchange 2010;

· Connecting with Experts and Peers—with Birds-of-a-Feather lunches and the new Windows 7 Lounge , you’ll have lots of opportunities to share your ideas with those who know the products best; and

· Applying what you learn—with a Learning Kit packed with products and resources so, you can continue to grow your skills long after the event has finished.

 

Dates

The final TechDays dates and cities are as follows:

• Vancouver – September 14 & 15, 2009

• Toronto – September 29 & 30, 2009

• Halifax – November 2 & 3, 2009

• Calgary – November 17 & 18, 2009

• Montreal – December 2 & 3, 2009

• Ottawa – December 9 & 10, 2009

• Winnipeg – December 15 & 16, 2009

Prices

The pricing for TechDays is as follows:

· VIP pricing – now until July 1st - $249.99

o This pricing is by invite code (TDUGVIP) 

· Early Bird pricing – July 1st until 6 weeks prior to event date - $299.99

· Full Conference price - $599.99

MS is still working on the learning kit and hope to send that information out as I get it.  MS already have a good start and right now I know that every guest of TechDays 2009 will get a Tech·Ed Online subscription with access to premium learning content worth over $250.00....nice start!


What is Your biggest pain point?
Saturday, June 20, 2009 11:42 AM

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)

http://support.enhansoft.com/Forum/default.aspx?g=posts&t=9


by Garth Jones
Filed under:
OWSUG invitation to the Ottawa IT Community Awards Night
Thursday, June 18, 2009 8:09 AM

Register to attend!

clip_image002

Presents

The Ottawa IT Community Awards Night

Tue June 30th 2009 on Elgin Street

Free food • Prizes • Awards Presentation • Celebration

Hosted by

clip_image003clip_image005

clip_image007clip_image008

With summer almost officially upon us, these 4 IT community organisations are teaming up to host the Ottawa IT Community Awards Night, honouring the partners and members that helped to make 2008/2009 another great season for developers, IT pros and DBAs.  The celebrations will include free food and some great competition and draw prizes.

Space is limited so check your calendar and register early for a great lead into Canada Day.

Follow this link to registration and event details - you must register to attend and qualify for prizes:

https://www.clicktoattend.com/invitation.aspx?code=139081

Funding and/or prizes for the event provided in part by the following generous event sponsors

clip_image009

clip_image010

clip_image011


ConfigMgr / SCCM / SMS site server documentation Script v1.14
Tuesday, June 16, 2009 5:00 PM

The ConfigMgr / SCCM / SMS site server documentation script has been updated, for more details see Enhansoft blog post.

 

http://support.enhansoft.com/Blogs/post/2009/06/16/ConfigMgr-Documentation-script-v114.aspx

 

Remember that the command line is cscript sydi-sms114.vbs


by Garth Jones
Filed under: ,
List PCs with Dup Serial Numbers
Tuesday, June 16, 2009 8:40 AM

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 )


by Garth Jones
Filed under: , ,
TechDays 2009
Tuesday, June 16, 2009 8:20 AM

Last year with your help we launched TechDays as a Canada-wide program to drive technical readiness across the ICT ecosystem.  The feedback was very positive and it turned out to be our largest ever technical education conference series for IT Professionals and Developers in Canada.   While the customers feedback was positive there was still more we could do to support you.  As user group members and key industry influencers it’s important that we give you early notice, get you involved and I have many emails which highlight that we needed to provide a special offer for you to share. 

So, here’s your early notice, as well we’ve included a “stimulus” offer for you to share and please connect with Damir, Rodney or John to get involved with the event, online portal, content and sessions. 

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 — Reference this code TDUGVIP and you can buy your tickets now and please share the code with whom you think would enjoy this year’s event.  Please just pass on the promo code and they’ll receive the same exclusive price!

I know this is a busy time for everyone and I commend each of you for the time you give back to the community and that why we wanted to get this out early to you as our hope is that this offer at some level can help you show more value with your user group, community and help support technical readiness across Canada.

TechDays 2009

As budgets get tighter, TechDays is the perfect way to get the Tech-Ed experience without the travel expense , with two days of skill-strengthening education to help you position yourself for success by:

· Learning the technology—with a customizable agenda from over forty skill-strengthening sessions across five technical tracks you can get the exact knowledge you want on the hottest new products.  Get the knowledge you’re looking for on both current technologies and new products, like Windows® 7, and Microsoft® Exchange 2010;

· Connecting with Experts and Peers—with Birds-of-a-Feather lunches and the new Windows 7 Lounge , you’ll have lots of opportunities to share your ideas with those who know the products best; and

· Applying what you learn—with a Learning Kit packed with products and resources so, you can continue to grow your skills long after the event has finished.

Dates

The final TechDays dates and cities are as follows:

• Vancouver – September 14 & 15, 2009

• Toronto – September 29 & 30, 2009

• Halifax – November 2 & 3, 2009

• Calgary – November 17 & 18, 2009

• Montreal – December 2 & 3, 2009

• Ottawa – December 9 & 10, 2009

• Winnipeg – December 15 & 16, 2009

Prices

The pricing for TechDays is as follows:

· VIP pricing – now until July 1st - $249.99

o This pricing is by invite code (TDUGVIP) 

· Early Bird pricing – July 1st until 6 weeks prior to event date - $299.99

· Full Conference price - $599.99

We are still working on the learning kit and hope to send that information out as we get it.  We already have a good start and right now we know that every guest of TechDays 2009 will get a Tech·Ed Online subscription with access to premium learning content worth over $250.00....nice start!


Newsletter June 2009 - Update
Tuesday, June 09, 2009 9:38 AM

clip_image001

June 18th 2009 User Group Meeting

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

Description:

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.

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

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

Notes:  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.!

RSVP: http://www.clicktoattend.com/?id=138745

 

Ottawa IT Community Awards Night

Summer is around the corner and the Ottawa Windows Server User Group is teaming up with the Ottawa .NET and the SQL Database User group for an Awards Night to honour the organizations and individuals that helped make 2008/2009 another great season for Developers, IT Pros, and DBA’s. The event will be taking place on Tuesday evening (June 30th) on Elgin street. Pencil this date into your calendar and get ready to kick off the Canada Day celebrations with a BANG! More details to follow shortly.

Links

OWSUG.ca Web Site          http://owsug.ca/

OWSUG.ca Mailing list     http://lists.owsug.ca

OWSUG.ca Blog                  http://owsug.ca/blogs/MainFeed.aspx

OWSUG.ca Forums            http://owsug.ca/forums/default.aspx


Enhansoft re-launches website with new look and services.
Saturday, June 06, 2009 11:21 AM

Come visit the newly redesigned Enhansoft web site. Visitors to the revamped Enhansoft website will find a new look, content, graphics and design.

The redesigned site also features a wiki and blog to keep clients up-to-date.


by Garth Jones
Filed under:
How many certified System Center people are there? (April 2009)
Friday, June 05, 2009 9:04 AM

Here is something interesting that last time (July 2008), I did this blog post there were more OpsMgr certified people than ConfigMgr. Well as of April 9, 2009 there are more Certified ConfigMgr People than Opsmgr.

 

Microsoft System Center Configuration Manager 2007: Configuration      2,166

Microsoft System Center Operations Manager 2007: Configuration      1,545

Microsoft System Center Virtual Machine Manager 2008, Configuration      400

 

BTW, here are the number from April 8 2008


More System Center Training
Thursday, June 04, 2009 8:38 AM

I’m a little behind in reading some of my RSS feeds, anyways here are few more “free” training / “On Demand Web Seminar” that might interest you.

TechNet Webcast: How Microsoft does IT: Using Virtualization with Hyper-V to Deploy System Center Configuration Manager 2007 (Level 300) On Demand Web Seminar

 

TechNet Webcast: Developing Custom Reports and Operational Dashboards with Operations Manager 2007 R2 (Level 400) On Demand Web Seminar

 

TechNet Webcast: Operations Manager 2007 R2 Deployment and Upgrade Best Practices (Level 300) On Demand Web Seminar

 

Understanding Microsoft Virtualization, WS2008, and Hyper-V vs. VMware On Demand Web Seminar


Training : How Microsoft does IT: Using Local Policies to Solve Complex System Center Configuration Manager 2007 Client Challenges
Thursday, June 04, 2009 8:32 AM

 

I saw this note come from “Microsoft Canada Technology Partner Training” RSS Feed. Since I have not seen anyone else post a not about this training I thought that I would.

 

“Any organization can have special-case scenarios where some clients must be managed differently. For example, software distributions or agent cycles may require special scheduling options. You might not want to use a separate site for large-scale client settings testing. Some clients may have special inventory reporting requirements. All of this, and more, is enabled by using local policies on designated clients. The solutions are often complex, and require scripting skills.  However, solutions for complex special-case scenarios are possible.”

Click here to access the training

 

For more information see Airlee blog post.

http://blogs.msdn.com/mscantraining/archive/2009/06/01/9678358.aspx

 

And remember anyone can apply to be a MS Partner.


Forum / Mailing list / Newsgroup Etiquette
Monday, June 01, 2009 10:40 AM

Since I have not seen anyone else post this to their blog I will. There is some good advices listed within these links for everyone.

How to ask a question

http://support.microsoft.com/kb/555375

How to answer a question

http://www.freebsd.org/doc/en/articles/freebsd-questions/x218.html

 

I will also add to this:

  • Don’t “Bump”, if you need to bring the message to people’s attention again then try re-writing the subject and provide more details. People are willing to help if they think they understand the issue. But WAIT more than 1 business day before reposting!

 

  • Don’t post the same question to multiply forums! It is annoying to see the exact same post in multiply places and ONLY posted a few second apart. Pick one place an post there, if you don’t get an answer within a reasonable time frame (more than 1 business day) post to another forum. (This is one of my new pet peeves)

 

  • Forums and Mailing lists list are NOT for urgent issues, if this is the case contact the vendor and seek support from them, that is what they are there for. If you don’t have a support contract in place then management has decided that they can live with the downtime and you should not worry about it. The problem will get fixed when it gets fixed, if it is that urgent then management will gladly pay for support.

 

  • Read the Docs! RTFM, etc.. Recently there has been allot of I need “bla” or does ConfigMgr do bla. However if this same person enter “bla” into the help file or Live / Bing / Google / Yahoo / Ask / etc. They would have found the answer. Instead they are just too lazy to RTFM. I will gladly help out anyone you says “I looked at the docs but I can’t find bla” or “The docs say bla, but does that mean bla bla?” (BTW it is nice to include the link or topic heading, so that we can see what you are talking about”)

 

  • Don’t call out a particular person and say “Hi Garth, I need your help to …”. Understand that some of the other people that might answer a post and will overlook it because you have called out person X. (I do it all the time when someone say “Hey Sherry” or “Hey Mark” or “Hey Michael”, to me it mean that they only want to hear from that person). Remember that everyone has their own lives and job, this means that person X might not get to your post ever! This could be due to holidays, business tasks, personal issues, new PC, etc., particularly don’t get mad if they don’t answer you. (This has happened to be back in the day, I got a phone call (my phone number was listed within my sig) from someone on the mailing list that got mad at me for not replying to them within 20 minutes. They needed an answer to give to their boss so that they would not look bad. The funny part was I was in a meeting and never saw the message until after their phone call! Needless to say I don’t help that person anymore! They don’t pay me therefore I’m not at their beck and call.)


June 18th 2009 User Group Meeting
Monday, May 25, 2009 3:22 PM

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

Description:

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.

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

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

Notes: 

  • 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.!

RSVP: http://www.clicktoattend.com/?id=138745


by Garth Jones
Filed under: , ,
How to Start a User Group
Monday, May 25, 2009 11:40 AM

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 ClicktoAttend.com

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 (www.70-400.com)

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
Friday, May 22, 2009 9:51 AM

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


by Garth Jones
Filed under: , , ,
Order by 2
Tuesday, May 19, 2009 5:08 PM

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


by Garth Jones
Filed under: , , ,
Replaced!
Monday, May 18, 2009 10:45 PM

 

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.”

 

Nabb


by Garth Jones
Filed under: , ,
Clients without Hardware information (WQL)
Monday, May 18, 2009 4:48 PM

select
    * 
from 
    SMS_R_System left outer join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId
where
    SMS_G_System_OPERATING_SYSTEM.CSDVersion is null


by Garth Jones
Filed under: , , ,
We are now +1
Sunday, May 17, 2009 7:50 PM

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.


by Garth Jones
Filed under: , ,
$300,000 worth of training
Tuesday, May 12, 2009 4:36 PM

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 http://www.makememarketable.ca/.

 

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
Tuesday, May 12, 2009 1:52 PM

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

Description:

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!

Speaker:

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.

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

Agenda:

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

Notes:

· 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.!

RSVP: http://www.clicktoattend.com/?id=138491


ITProtini
Monday, May 11, 2009 2:29 PM

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


by Garth Jones
Filed under: ,
Report Tweaking Help - Installed Date
Thursday, May 07, 2009 10:53 AM

Select
    sys.Netbios_Name0,
    fcm.SiteCode, 
    sys.User_Domain0,
    sys.User_Name0,
    sys.Operating_System_Name_and0,
    arp.DisplayName0,
    ARP.InstallDate0
FROM
    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
WHERE
    DisplayName0 = @displayname
    and fcm.CollectionID=@CollID


by Garth Jones
Filed under: , , ,
List of Device with SNMP string
Thursday, May 07, 2009 8:19 AM

select
    Name0,
    Community_name0
from
    v_r_system


by Garth Jones
Filed under: , , ,
Used HD Space
Monday, May 04, 2009 3:30 PM

SELECT
CS.Name0,
LD.DeviceID0,
(LD.Size0 - LD.FreeSpace0) as Used
FROM
v_GS_COMPUTER_SYSTEM CS,
v_GS_LOGICAL_DISK LD
WHERE
LD.ResourceID = CS.ResourceID
AND LD.DriveType0=3


by Garth Jones
Filed under: , , ,
ConfigMgr Child Labor Video
Saturday, May 02, 2009 4:47 PM

Jarvis did and excellent job again with his new video.

http://verbalprocessor.com/2009/04/29/configmgr-child-labor-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
Saturday, May 02, 2009 4:36 PM

Select DISTINCT
    sys.Netbios_Name0,
    fcm.SiteCode,
    sys.User_Domain0,
    sys.User_Name0,
    sys.Operating_System_Name_and0,
    arp.DisplayName0,
    ru.Full_user_Name0
FROM
    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
WHERE
    DisplayName0 = @displayname
    and fcm.CollectionID=@CollID


by Garth Jones
Filed under: , , ,
More Posts Next page »