Monitoring Task Sequence Deployment

For more detail monitoring of the Task Sequence Deployment we can use the Status Message Queries in SCCM

Use the query below and change the AttributeValue (Task Sequence ID) and the SiteCode to your needs.

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 = “cs1205eeand stat.SiteCode = “PS1and att2.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime## order by att1.AttributeTime desc

Screenshot of the query:
StatusMessageQuery2

Show Messages:
StatusMessageQuery

Geef een reactie

Je e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *

Deze site gebruikt Akismet om spam te verminderen. Bekijk hoe je reactie-gegevens worden verwerkt.