@Kalyan Sundar That was super helpful. that's a great way of monitoring. i love it. thanks for sharing. just an FYI, the first article you referenced got me 90% of the way there. but i think his message ID (401) might not have been right with newer versions. i ended up using the query from the second link instead.
and in case that link isn't accessible in the future. here is the query. (Just modify your Task Sequence ID)
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.AttributeValue = "TP10000B" and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime##
order by SMS_StatMsgAttributes.AttributeTime
DESC