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

Pranay Kumar 16 Reputation points
2021-05-04T09:55:01.97+00:00

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.

Microsoft Intune Configuration
Microsoft Intune Configuration
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Configuration: The process of arranging or setting up computer systems, hardware, or software.
1,654 questions
Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
440 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. HanyunZhu-MSFT 1,836 Reputation points
    2021-05-05T07:28:40.49+00:00

    @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.
      93836-1.png
    2. Create a new status message query.
      Go to Monitoring > System Status > Right-click Status Message Queries and click Create Status Message Query.
      93788-21.png
      Select Edit Query Statement, then select Show Query Language.
      93837-22.png 93838-23.png
      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.
    93839-31.png
    Then you can check the start time and complete time of the task sequence.
    93790-4.png

    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.


  2. Pavel yannara Mirochnitchenko 11,411 Reputation points
    2021-05-05T08:02:53.577+00:00

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


  3. HanyunZhu-MSFT 1,836 Reputation points
    2021-05-06T08:00:03.407+00:00

    @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.
    94305-time.png 94354-filter.png

    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.