navigation bar


Tuesday, October 10, 2017

Task sequence status message queries

You can use status message queries in the SCCM console to filter only task sequence messages. It is useful to have messages from multiple devices instead of targeting a specific computer in Monitoring / Deployments / Select task sequence / view status.

1. Go to Monitoring / Deployments
2. Add the DeploymentID column by right-clicking the top row. Note your DeploymentID, example 1PA2000A and 1PA2000B
3. Go to Monitoring / System Status / Status Message Queries
4. Right click Status Message Queries and choose Create Status Message Query
5. On the General tab, enter a desired Name and click on Edit Query Statement
6. On the Query Statement Properties window, click on Show Query Language
7. Enter the following query in the Query Statement window and click ok

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 = "1PA2000A" or SMS_StatMsgAttributes.AttributeValue = "1PA2000B")
and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by SMS_StatMsgAttributes.AttributeTime DESC

8. In the Status Message Queries node, find your newly created Query, right-click on it and select Show Messages
9. Select the desired Date and Time and click OK
10. All messages from your selected deployment will be displayed