Application and Package Deployments Reporting by Collection with SCCM

Ioan Popovici
MEM.Zone

--

Deployments reports for all collection members available get it while it’s hot…

🚨🚨 IMPORTANT NOTICE🚨🚨

🦄 We moved to our brand new blog at MEM.Zone 🦄

🚨🚨 IMPORTANT NOTICE🚨🚨

Report release history

There are no default reports that can display results for each collection member. There is a report that lists deployments for a specific collection but that’s it. If a collection member has a deployment on a different collection you are out of luck. Well not anymore…

I used the ‘All package and program deployments to a specified user/device’ as reference. One of the problem was that the ‘User’ report has a bug and returns ‘NULL’ for most packages. Since the views are so well documented, it took a while to get it right.

Import the SSRS Report

  • Download the report file
## Software deployments by Device or User
DE Software Deployments by Device or User.rdl

Notes
I’ve merged the original two reports in one unified report.

Report Queries

For reference only, reports already include these queries.

Application deployments query
Package deployments query

Report Preview

User application deployments
Device application deployments

Notes
I did not post screenshots with package deployments because of severe laziness but you get the picture.

Use Github for 🐛 reporting, or 🌈 and🦄 requests

🙏 Please subscribe or clap for this article, it makes a difference! 🙏

--

--