Monitoring A Test Task Sequence

A great way to monitor a new task sequence is by using a custom Status Message query which grabs all the exit codes from every step of the TS and reports them out to the console. All you need is the following query and the Deployment ID for your task sequence. 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_StatMsgAttributes.AttributeValue = “ABC20001” and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by SMS_StatMsgAttributes.AttributeTime DESC Create a new Status Message Query from the Monitoring tab as follows. Give the query a new name, eg,…

Read More