SCCM SQL Query to get task sequence deloyment

Boopathi S 3,666 Reputation points
2023-07-21T10:28:15.2533333+00:00

Hello,

Please share SCCM SQL query to generate task sequence deployment report with all status [Waiting, Failed, Accepted, Running, No Status, Retrying, Cancelled and Succeeded] using task sequence package ID to a collection.

Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    2023-07-21T12:59:52.91+00:00

    Have you looked at the built-in reports?

    If you don't like them you can created your own, all the supported SQL views are listed in the docs site. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/sql-server-views-configuration-manager

    1 person found this answer helpful.
    0 comments No comments

  2. Simon Ren-MSFT 38,676 Reputation points Microsoft Vendor
    2023-07-24T07:49:50.3233333+00:00

    Hi,

    Thank you for posting in Microsoft Q&A forum.

    The below built-in reports will help and they are listed under the Task Sequence - Deployment Status category.

    Status summary of a specific task sequence deployment

    All system resources for a task sequence deployment in a specific state
    task sequence status

    Thanks for your time. Have a nice day!

    Best regards,

    Simon


    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.

    0 comments No comments

  3. Simon Ren-MSFT 38,676 Reputation points Microsoft Vendor
    2023-07-25T06:11:14.5+00:00

    Hi,

    If the response is helpful, it's appreciated that you could click "Accept Answer" and upvote it, this will help other users to search for useful information more quickly. If you have any questions in future, we warmly welcome you to post in Microsoft Q&A forum again.

    Have a nice day!

    Best Regards,

    Simon

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.