SCCM - How to get the status of a old TS deployment in SCCM

Question

Hello All,

How can we get the result of task sequence deployment in SCCM for old task sequences that ran a month back on the machine. Basically, we wanted to record time of Task sequence start and end on the machines we use to go to get this detail form the monitoring tab under deployment status but the deployment is deleted for the TS.

In this case how can we find out the time of start and end of a TS (which was deployed a month back) from SCCM ?

Thanks,
Pranay.

Answer 1

@Pranay Kumar

You can view the status of the task sequence using Status Message Query, please refer to the following steps:

1. Go to Software Library\Overview\Operating Systems\Task Sequences, record the Package ID of the task sequence that you want to view its status.
   
2. Create a new status message query.
   Go to Monitoring > System Status > Right-click Status Message Queries and click Create Status Message Query.
   
   Select Edit Query Statement, then select Show Query Language.
   
   Paste the below query in Query Statement box and click OK. ( replace SCD0001D with the package ID of 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.AttributeValue = "SCD0001D" and SMS_StatMsgAttributes.AttributeTime >= ##PRM:SMS_StatMsgAttributes.AttributeTime##
   order by SMS_StatMsgAttributes.AttributeTime
   DESC

Then finish the wizard.
3) Right-click the query and select Show Messages. Choose the time that you want to view.

Then you can check the start time and complete time of the task sequence.

Hope the above information can help you.

---

If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Try to identify correct start and end timestamps from smsts.log.

Answer 3

@Pranay Kumar

Here is a method provided for your reference to find the package ID of the deleted task sequences.
You can launch the SCCM console and go to Monitoring > Overview > System Status > Status Message Queries > Right-click All Status Messages and click Show Messages > choose the period that you want to view.
Then use the filter option and enter the message ID as 30002 and click OK, the Descirption of the message will tell you the package ID of the deleted task sequences.

What's more, there is a more efficient way to help you find the package ID of the deleted task sequence.
Login SQL Server Management studio and expand Databases. Then right-click your ConfigMgr database and select New Query.
After that, run the below query to find out the deleted task sequence: *Select * from vStatusMessagesWithStrings where MessageID = 30002*
Normally, the InsStrValue2 column shows the package ID.

---

If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.