Close Menu
    Facebook X (Twitter) Instagram
    Monday, June 23
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM Report Compare packages on 2 DPS

    SCCM Report Compare packages on 2 DPS

    Eswar KonetiBy Eswar KonetiSeptember 22, 1:38 pm1 Min Read SCCM 2007 4,123 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Once you are done with installation/configuration of the sites/Distribution Point,you start distributing the content to it.sometimes you may have to check if the site which you configured has all the content that serve for clients to receive packages. For this,you can compare the newly configured server with already existing server  which has all the content including packages,drivers,SUP ,OSD etc .

    Here is simple report compare the list of packages missing from newly configured server:

    sccm2012sec is considered as base server which has all the content in it

    sccm2012nor is newly configured one

    select s.SiteCode,s.PackageID,p.Name,(p.sourcesize)/1024 as "size(MB)",s.sourceversion as "DPVersion",p.storedpkgversion as Latversion,s.Installstatus as 'Package Status',
    Case v_Package.PackageType
    When 0 Then 'Package'
    When 3 Then 'Driver'
    When 4 Then 'Task Sequence'
    When 5 Then 'software Update'
    When 7 Then 'Virtual'
    When 8 Then 'Application'
    When 257 Then 'Image'
    When 258 Then 'Boot Image'
    When 259 Then 'OS'
    Else ' '
    END AS 'Type'
    from v_PackageStatusDistPointsSumm s
    inner join smspackages p on s.packageid = p.pkgid
    inner join v_Package on v_Package.PackageID=p.[PkgID]
    where s.PackageID not in (select PackageID from v_DistributionPoint where ServerNALPath like  '%sccm2012nor%') and ServerNALPath like '%sccm2012sec%'
    order by 8

    To distribute the missing packages,use the powershell script via http://eskonr.com/2013/11/configmgr-2012powershell-script-add-packages-applicationsdrivers-to-distribution-point/

    check the missing apps from other DP compare packages Distribution Point sccm report SCCM report compare packages SCCM Report Compare Packages on 2 DP's SQL SQL code
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Addressing SCCM Software Update Deployment Challenges with PowerShell – Remote install

    October 23, 10:23 am

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    6 Comments

    1. Pritam on September 27, 2018 1:13 AM

      I am new to SQL can u help me out on the above mention query..I want to know how it will compare both dps.

      Reply
      • Eswar Koneti on September 30, 2018 10:41 PM

        You can copy the SQL code and run it in SQL server management studio or create SSRS report with prompt for DP's.

        Thanks,
        Eswar

        Reply
    2. ian on September 11, 2014 1:58 AM

      Where is the report generated? is it in one of the SCCM built in reports or should I be looking somewhere else?

      Reply
      • Eswar Koneti on September 11, 2014 10:50 AM

        The query posted on the blog is sql and you can run it via management studio or business intelligence /visual studio. Did you get the sql query from http://eskonr.com/2012/09/sccm-report-compare-packages-on-2-dps/

        Reply
    3. JS on June 12, 2014 2:03 PM

      Is it possible to make this script so it checks all DPs and list all packages that are missing on all dps? I have about 20 dps.

      Reply
      • Eswar Koneti on June 12, 2014 6:17 PM

        Did you try this ? http://eskonr.com/2014/02/configmgr-2012powershell-script-add-packages-applicationsdrivers-to-distribution-point-2/

        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.