This is not about monitor Task Sequence Deployment status, it is about monitor Task Sequence itself.
I use package ID instead of Deployment ID, because you might need to deploy same Task Sequence to many collections with different schedule, and you will have many deployments of same Task Sequence. I don’t want to create many queries for each deployments of same Task Sequence. So let’s be lazy and just create ONE query.
- Find you package ID, in my case it is ZIT0000F
- Create new Status Message Query
- I like to use Name “01. MDT Install Windows”, using numeric will put your custom queries ahead of other default queries, it’s a bit easier to find them later
- Click “Edit Query Statement…”
- Click “Show Query Language”
- Copy these codes and paste them in the query box. Change line 7 ZIT0000F to your own Package ID, then Next, Next.
123456789select SMS_StatusMessage.*, SMS_StatMsgInsStrings.*, SMS_StatMsgAttributes.*, SMS_StatMsgAttributes.AttributeTimefrom SMS_StatusMessageleft join SMS_StatMsgInsStringson SMS_StatMsgInsStrings.RecordID = SMS_StatusMessage.RecordIDleft join SMS_StatMsgAttributeson SMS_StatMsgAttributes.RecordID = SMS_StatusMessage.RecordIDwhere SMS_StatMsgAttributes.AttributeValue = "ZIT0000F" and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime##order by SMS_StatMsgAttributes.AttributeTimeDESC
- Right-Click you Status Message Query, click Show Messages
- Select date and time, then click OK
- Now you can monitor your Task Sequence status.