If you are performing SCCM cleanup activity on packages,this might help you to identify if there are any packages still available on DPs rather looking at each package manually also to check how many DP’s each package available so you can distribute the package to missing DP’s(if you have standards to ensure all packages should be on X many DP’s)
SELECT PackageID, Name, Version, Manufacturer, Language, Description,PkgSourcePath , LastRefreshTime,
(SELECT COUNT(PkgID) FROM vPkgStatusSummaryDistPts WHERE PkgID = v_Package.PackageID) AS [Total Number of DP’s]
FROM v_Package
order by [Total Number of DP’s] desc
P.S :Quotes in this post are fancy quotes,please replace them in your query while pasting.
5 Comments
Thanks again for the great report. Anyway to provide a link on each dP so that it calls another report that shows the actual Packages (Names and description) for that dp? Link to your report Report for packages which are Installed on DP. I have over 200 dps and this would be awesome!!
Mark Hendrickson
I will look into when times permits.
Any chance of getting a sccm 2012 rdl of this report, please. I have close to 200 dps and would love to quickly see which packages are present on each dp and/or missing. Not sure how to take the sql statement and create a new sccm 2012 report with it.
Thanks,
Mark
Hello,
I can't put into words how much I appreciate the knowledge and reports you pass on. Thanks!!
Any chance I could get a sccm 2012 rdl file for the report SCCM report Count of packages available on Distribution Points? Or if could give me a link to how to create a report based on the code you are showing. I have close to 200 dps and would love a report to show me the packages on each dp and/or the packages missing from each dp.
Thanks,
Mark
I will look into when time permits but meantime ,you can follow-up this guide to create your own using the query http://www.scconfigmgr.com/2014/01/24/create-custom-reports-for-configmgr-2012-with-report-builder/