SCCM Report Query which shows all Successes and Failures from all Task Sequences

So recently I had a requirement where I needed to see failures of all task sequences deployed in an environment and report on the success or failure rates. So I came up with a report just to do it.

To set it up go to Monitoring > System Status > Status Message Queries.

When you run this query it will report back all the successes and failures from all task sequences. You can then drill down into each step to get error codes and further details.

When using the query above make sure that you replace the “YOUR-SITE-CODE-HERE” with your site code.

So what does this report look like?