By creating a separate query with the Deployment ID it is simpler to follow status of a running OSD Task Sequence:

 

(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 = “PS12001E” and stat.SiteCode = “PS1” and att2.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by att1.AttributeTime desc)

 

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 = "PS120004"
and stat.SiteCode = "PS1" and att2.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime##
order by att1.AttributeTime desc