Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, July 8
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM Reports»SCCM report Count of packages available on Distribution Points

    SCCM report Count of packages available on Distribution Points

    Eswar KonetiBy Eswar KonetiAugust 01, 1:35 pm1 Min Read SCCM Reports 2,044 Views
    Share
    Facebook Twitter LinkedIn Reddit

    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.

    Packages count on Distribution Point sccm report SCCM report count of packages avilable on DP SQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    5 Comments

    1. Mark Hendrickson on November 18, 2015 5:00 AM

      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

      Reply
      • Eswar Koneti on November 23, 2015 11:07 AM

        I will look into when times permits.

        Reply
    2. Mark Hendrickson on November 18, 2015 1:40 AM

      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

      Reply
    3. Mark Hendrickson on November 18, 2015 1:36 AM

      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

      Reply
      • Eswar Koneti on November 23, 2015 11:05 AM

        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/

        Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.