SCCM SQL Query to get task sequence deloyment

Question

Hello,

Please provide a SCCM SQL query to get the report of a task sequence deployment to a collection with all the status [Waiting, Failed, Accepted, Running, No Status, Retrying, Cancelled and Succeeded]

Answer 1

Hi,

Thank you for posting in Microsoft Q&A forum.

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

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.

Answer 2

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