Monitoring ConfigMgr 2012 OS Deployment using State Messages

When troubleshooting OS Deployment in System Center 2012 Configuration Manager, I really miss the state messages from the advertisement status in ConfigMgr 2007.

You can find the same information in reports, but for this scenario, I really prefer the Status Messages.

This guide will help you create a Status Message Query for a Specific Deployment ID.

First you need to get the deployment ID of the Task Sequence you wish to monitor.

Monitoring -> Overview -> Deployments. (The Deployment ID are not displayed by default).

clip_image002

Navigate to the Status Message Queries:

Monitoring -> Overview -> System Status -> Status Message Queries, and click Create Status Message Query.

Give the Status Message Query a name, and click Edit Query Statement…

clip_image004

Click Show Query Language.

clip_image005

Copy the following Query into the Query Statement, and click OK.

Replace the site code (P01) and the Deployment ID (P01200ED), in the query.

select stat.*, ins.*, att1.*, att1.AttributeTime from SMS_StatusMessage as stat left join SMS_StatMsgInsStrings as ins on stat.RecordID = ins.RecordID left join SMS_StatMsgAttributes as att1 on stat.RecordID = att1.RecordID inner join SMS_StatMsgAttributes as att2 on stat.RecordID = att2.RecordID where att2.AttributeID = 401 and att2.AttributeValue = "P01200ED" and stat.SiteCode = "P01" and att2.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by att1.AttributeTime desc

clip_image006

Click OK, and complete the wizard.

Now we’re ready to launch the Query:

clip_image007

Select the date and time (default 1 hour ago), and click OK.

clip_image008

And now we’re ready to monitor the deployment like we did in the good old CM07 days J

clip_image010

Enjoy.

9 Comments

Ogeccut on March 8, 2012 19:28

Can you please explain a bit about the Query? Thank you.

- Ronni Pedersen on March 8, 2012 21:43
  
  Sure… All you need to do, is to copy the query at replace the Site Code and the Deployment ID. Then it should be working just fine.
  
Ogeccut on March 9, 2012 15:14

Thank you. I would like to know what is it doing? Maybe some details about the language?

John on October 23, 2012 03:42

Great query thank you I was looking everywhere for this..

Michael Simionato on November 7, 2014 05:46

Great Query. Is there any way of changing the system value from Minint-xxxxxxx to the actual machine name that is being configured.

- Ronni Pedersen on November 12, 2014 15:07
  
  Absolutely… You can change the ComputerName dynamically. I always recommend using the MDT Toolkit.
  Here is an example: https://www.ronnipedersen.com/2014/10/setting-osdcomputername-using-customsettings-ini/
  
jose on March 24, 2015 20:58

Thanks for this, have you seen any of these queries return results for “Application Model” apps?

- Ronni Pedersen on April 6, 2015 18:47
  
  I normally don’t use Applications in my Task Sequence. I always use packages.
  
Tom on March 26, 2015 21:06

Great query! I’ve been looking to do this within SQL and that’s how I landed on this page, I was thinking there was no other option but clearly there is 🙂 Thanks!