Monitoring Task Sequences in ConfigMgr 2012 R2 console 4

When doing OSD in SCCM 2012 R2 you can view the deployment information in the Task Sequence reports, but the Status Messages is really the preferred place for this.

First thing you need is to get the deployment ID of the Task Sequence you wish to monitor. You have to setup a query for each Task Sequence.

Go to Monitoring, Overview, Deployments.

(The Deployment ID are not displayed by default so you have to select this. Right-click and select ) and take a note of the Deployment ID

 Deployment ID:

 Build the Status Message Queries:

  • Go to Monitoring, Overview, System Status, Status Message Queries, right click and choose Create Status Message Query.
  • Give the Status Message Query a name, and click Edit Query Statement

  • In the General Tab choose Show Query Language and paste in the following text (watch out with the quotes ;-));
    Replace the collection ID with the one you looked up.

from SMS_StatusMessage
left join SMS_StatMsgInsStrings
on SMS_StatMsgInsStrings.RecordID = SMS_StatusMessage.RecordID
left join SMS_StatMsgAttributes
on SMS_StatMsgAttributes.RecordID = SMS_StatusMessage.RecordID
where SMS_StatMsgAttributes.AttributeID = 401 and SMS_StatMsgAttributes.AttributeValue = “ODV20002”
and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by SMS_StatMsgAttributes.AttributeTime DESC


  • Click OK, and complete the wizard.

To launch the Query:

  • In the State Message, right click the query and select the date and time (default 1 hour ago), and click OK.


And an overview of the result!

4 thoughts on “Monitoring Task Sequences in ConfigMgr 2012 R2 console

  1. Reply Matt Sample Aug 21,2015 10:18 pm

    Great Stuff! Thanks for sharing this, too bad it does not report when the TS fails, but it does give the last successful step. So it is a big help.

    • Reply Matt Sample Aug 22,2015 3:04 am

      Need to amend my previous post – if the task sequence does post an error box it is recorded in here. If it terminates without posting an error box then it does not. Works great!

  2. Reply Edward Jan 18,2017 7:09 pm

    In the State Message, right click the query and select the date and time (default 1 hour ago), and click OK.

    What? I don’t see “State Message” and when I right click the query, there is now Date/Time

    Anyway when I right click and Show Messages, I get a dialog box that states it could not find a persistent query for the query ID and it will be invoked with a default query displaying all status messages.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.