Started rolling out MS office 2013 to Users few weeks ago.For this ,created collection to get computers with MS office 2010 ,created application for MS office 2013 upgrade and deploy to collection .This collection consists of computers from different departments,business units etc.
Colleague of mine asked me if there is way to get report for deployment status of specific application for specific OU. The reason for this requirement is that ,he wanted to get the deployment status per business unit (location)for the deployed application. OUs in AD are named with location names .
A single collection (MS office 2013 upgrade ) consist of computers from several business units and he wants to see the status per business unit for reporting.
The default report ‘All Application Deployment (basic)’ from software distribution—Application monitoring category works on specific collection and this collection contains the computers from different business units (Locations which are nothing but OU’s ) did not work for this requirement. Must create new report to get the deployment status results for specific application for specific business unit.
So I started looking out for the Configmgr 2012 R2 SQL tables/sql views using the Configmgr 2012 R2 SQL views spread sheet .
I created report which can be used to find the deployment status of any application (but not packages) for specific OU.
Note: This report will list the computers on which the deployment ran or atleast the computer received policy about the deployment. For ex: An OU contains 200+ computers but the collection contains only 50 Computers from this specific OU so when you run this report,you may only see results for these 50 computers but not 200+. Also remember that,this report will not give you the error description for the computer when did the deployment is failed . It requires little more work to get the description from dll files in SSRS and will update this post when am done.
When you run the report ,you will have to select the OU ,you will see list of all OU’s from your AD .It may look ugly with all OUs and sub OU etc but you can fine tune the SQL query this to get the child OU only.
Report is based on the Deployment status :
Requirements Not Met
This report contains 2 sub reports 1)Overall deployment status results with nice pie chart for specific application for specific OU 2) sub report to get the list of computers with specific specific for the selected application .
Deployment chart summary for specific application :
Sub report to list computers with specific status for application for OU (click on the Pie chart to get list of computers with specific status):
Download the RDL files from TechNet gallery here ,upload the RDL files to your SSRS Folder (keep both these files in same folder as they are linked),change the Data source and run it.