Monitor SCCM Task Sequence Progress with 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.
Contents
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.
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.
Specify the query name and click Edit Query Statement.
On the Query statement properties window, click 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.
On the Summary window, click Next. Close the 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 above step and click Show Messages. This should now let you monitor SCCM task sequence progress.
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.
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.