ConfigMgr: Task Sequence Status Message Query

Overview

Are you tired of digging and filtering through status messages to see why your task sequence is failing or hanging? Create a custom Status Message Query with the following query.

Code

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.AttributeID = 401 and (SMS_StatusMessage.Component = "Task Sequence Engine" or SMS_StatusMessage.Component = "Task Sequence Action" or SMS_StatusMessage.Component = "Task Sequence Manager") and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by SMS_StatMsgAttributes.AttributeTime DESC

Screenshots