SCCM 1806 CB- To Set the Task Sequence Status Message Query.

Task Sequence Status Message query.

select stat.*, ins.*, att1.*, stat.Time 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 where stat.Component = “Task Sequence Engine” and stat.Time >= ##PRM:SMS_StatusMessage.Time## order by stat.Time desc

select stat.*, ins.*, att1.*, stat.Time 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 where stat.Component = “Task Sequence Engine” and stat.MessageID = “11140” and stat.Time >= ##PRM:SMS_StatusMessage.Time## order by stat.Time desc

 

select stat.*, ins.*, att1.*, stat.Time 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 where stat.Component = “Task Sequence Engine” and stat.MessageID = “11141” and stat.Time >= ##PRM:SMS_StatusMessage.Time## order by stat.Time desc