Monitoring Task Sequence Deployment

For more detail monitoring of the Task Sequence Deployment we can use the Status Message Queries in SCCM

Use the query below and change the AttributeValue (Task Sequence ID) and the SiteCode to your needs.

select stat.*, ins.*, att1.*, att1.AttributeTime from SMS_StatusMessage as stat left join SMS_StatMsgInsStrings as ins on stat.RecordID = ins.RecordID left join SMS_StatMsgAttributes as att1 on stat.RecordID = att1.RecordID inner join SMS_StatMsgAttributes as att2 on stat.RecordID = att2.RecordID where att2.AttributeID = 401 and att2.AttributeValue = “cs1205ee” and stat.SiteCode = “PS1” and att2.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by att1.AttributeTime desc

Screenshot of the query:

Show Messages: