Morning everyone..

I'm trying to retrieve Category info under Enforcement status for a ConfigMgr 2012 based application deployment.

I used Application Deployment Statistics report in Software Distribution-Application Monitoring and it does show me all the results in a pie-chart however my intent is to have a basic SQL query that can let me gather these categories for a specific deployment.

SQL Query given in the following blog was very useful however for I'm trying to get category info added to it as well.

http://blogs.technet.com/b/umairkhan/archive/2014/10/03/the-case-of-the-unexplained-application-deployment-monitoring-reports-which-one-to-rely.aspx

thanks..

Hi,

You could try to use Report Builder to edit the default report in SCCM.

Configuration Manager 2012 Editing built-in reports using Report Builder

Best Regards,

Joyce