Monitor SCCM Task Sequence Progress | Status Message Query

In this post I will show you how to monitor SCCM task sequence progress using Status Message Query. This should help you to monitor SCCM task sequence progress and will let you know at what step TS failed.

When it comes to troubleshooting task sequence issues, it’s not going to be simple. However with the help of SCCM log files and status message query, it should be bit easy.

When you deploy a task sequence, it basically executes one step after the other. So it is important that when you create a task sequence first, test it properly before you deploy it.

Microsoft released task sequence debugger tool with version 1906 which is essentially a troubleshooting tool. You deploy a task sequence in debug mode to a small collection. It lets you step through the task sequence in a controlled manner to aid troubleshooting and investigation.

You refer the following post to read more about SCCM task sequence debugger tool. To know the usage of status message queries, you can read the below posts.

Monitor SCCM Task Sequence Progress with Status Message Query

We will use the status message query to monitor SCCM task sequence progress. This should work with any version of Configuration Manager. We will also use the tasks sequence package ID instead of deployment ID.

Step 1 – Find the Task Sequence Package ID

To find the task sequence package ID, go to Software Library\Overview\Operating Systems\Task Sequences. Select your task sequence and look for the package ID.

Make a note of that Package ID because we will need this while creating the status message query. Now since I have got just 1 task sequence, I will monitor it with the package ID.

Find the Task Sequence Package ID
Find the Task Sequence Package ID

Step 2 – Create Status Message Query

In this step we will create a new status message query. Go to Monitoring > System Status > Status Message Queries. Right click Status Message Queries and click Create Status Message Query.

Create Status Message Query
Create Status Message Query

Specify the query name and click Edit Query Statement.

Edit Query Statement
Edit Query Statement

On the Query statement properties window, click Show Query Language.

Show Query Language
Show Query Language

Paste the below query in Query Statement box and click OK. Ensure you substitute the package ID with your TS package ID. Every task sequence that you create will have a package ID associated with it.

select SMS_StatusMessage.*, SMS_StatMsgInsStrings.*, SMS_StatMsgAttributes.*, SMS_StatMsgAttributes.AttributeTime 
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.AttributeValue = "TP10000B" and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## 
order by SMS_StatMsgAttributes.AttributeTime 
DESC

Enter the above query and click OK.

Enter the query to monitor task sequence
Enter the query to monitor task sequence

On the Summary window, click Next. Close create status message query wizard.

Create Status Message Query Wizard
Create Status Message Query Wizard

Step 3 – Use Status Message Query to Monitor SCCM Task Sequence Progress

Go to Status Message Queries, right-click the query that you just created in the above step and click Show Messages. This should now let you monitor SCCM task sequence progress.

Use Status Message Query
Use Status Message Query

Before you view the task sequence progress, ensure you select the date and time. You may also select specify a date and time. Click OK.

Monitor SCCM Task Sequence with Status Message Query
Monitor SCCM Task Sequence with Status Message Query

In the Configuration Manager Status Message viewer, you can monitor each step of the task sequence. If any of the step fails, you should get to know why it failed.

You may have several entries in the message viewer. What you need to look at is the system name and the task sequence description.

Monitor SCCM Task Sequence with Status Message Query
Monitor SCCM Task Sequence with Status Message Query

Need Assistance?

Send us a message or post your question in forums.

Leave a Comment