Thursday, April 30, 2009

MMS 2009

Well like many ConfigMgr people I am here in Las Vegas at MMS 2009. If you went to the SuperFlow sessions by Steve K then you heard about the newest superflows and when you can expect to see them. He also talked about the MVPs and the superflows they are creating. I have been working for about 4 to 5 weeks with some of the Docs people to setup the outline for a Native Mode Superflow. It might just be the most complex and biggest superflow. To release a good version we scale down what is publised in the first revision. It could take 2 or 3 to have everything published and linked. It think it will provide a great deal of insite to native mode deployment. I personally didn't find native mode very hard to deploy and the benifits are GREAT!!!!

Friday, April 17, 2009

Could the ConfigMgr console put you to sleep?

Well I am home because my wife is out of town and I have a sick 1 year old. Well he wanted to roam around so I sat down and remoted to my ConfigMgr server. Like all good IT personell, I "volunteer" alot. Well he wanted to be picked up so I placed him on my lap while I ran throuhg logs and status messages. It took about 15 mins before he started to do the head bob and 5 minutes later he was out. Now he has only been up for about 1 hour so either he really needs more sleep or that console is not for children under "5 years of age." We saw at MMS 2008 that even a 5 year old can image machines so I think we need a disclaimer for working with System Center products. Not recommended for childen under the age of 5 years of age. Drowsiness may occur.

Tuesday, April 14, 2009


Stop by the Birds of a Feather (BOF) session at MMS 2009 to hear what is going on with Superflows....

BY05 Configuration Manager SuperFlow Showcase
Tuesday 6:45 PM 7:45 PM, Casanova 606
Speaker(s): Steve Kaczmarek, Doug Eby
Track(s): Systems Management
Session Type: Birds-of-a-Feather
Products(s): Configuration Manager 2007
At this Birds-of-a-feather session we will showcase 6-8 of the newest Configuration Manager 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 that can be used to create SuperFlows.

Monday, April 13, 2009

Query to find computers with user missing application

This is something I did pretty quick, it could easily edited on a computer report

First you need to create a query with no object type (see image) Now paste this into the query editor. You will not be able to use the Query designer for any help. This particular example looks for computers missing a specific Version of Flash. Paired with it are the lasted logged in user, user, title, department. You may need to extened the AD User Discovery as mentioned in a previous blog for title and department information.


select SMS_R_SYSTEM.Name,SMS_R_User.Name,SMS_R_System.LastLogonUserName,SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM.UserName,SMS_R_User.title , sms_r_user.department from SMS_R_System
inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
inner join SMS_R_User on SMS_R_User.Username= SMS_R_System.LastLogonUserName
where SMS_G_System_COMPUTER_SYSTEM.Name not in (select SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Flash Player%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = "")