Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, July 8
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM Configmgr delete retired orphaned distribution points

    SCCM Configmgr delete retired orphaned distribution points

    Eswar KonetiBy Eswar KonetiNovember 12, 12:59 pm2 Mins Read SCCM 2007 5,775 Views
    Share
    Facebook Twitter LinkedIn Reddit

    I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed to DP but the distribution point are really not on the network (retired ).Because of this, I see the red alerts on the system status with below error.

    Possible cause: The distribution point might not be accessible to SMS Distribution Manager running on the site server. Solution: If users are currently accessing the package files on the distribution point, disconnect the users first.

    you can see the below information from your site system status error messages.

    Package ID : IND0011B

    Distribution Point : ["Display=\\IND001\smspkgc$\"]MSWNET:["SMS_SITE=C01"]\\IND001\smspkgc$\

    How to check what servers are retired with specific package ? and check what packages targeted to specific retired DP ?

    Run the below SQL query on your SQL management studio:

    1.Select * from pkgservers where NALpath =path of NALpath
    2.Select * from pkgstatus where pkgserver =Path of Pkgserv

    Path should be replaced by this ,in this case = ["Display=\\IND001\"]MSWNET:["SMS_SITE=C01"]\\IND001\

    If you find any entries related with above quires then use the below syntax to delete them from Database.

    1. Delete from pkgservers where NALpath=path of NALpath
    2. Delete from pkgstatus where pkgserver =Path of Pkgserv

    This will remove the pending packages from the retied DP and allows the package refresh to occur as expected. Then try restart the SMS Distribution Manager component and monitor the distmgr.log for errors.

    If you are smart,you can identify the Bad Distribution points in your environment and take necessary actions before it triggers errors in component status node with the following query report easily:

    Here is the report which will shows you all the Bad distribution Points in your SMS/SCCM environment

    SELECT a.InstallStatus, a.LastCopied, a.PackageID,  a.ServerNALPath,
    a.SiteCode,a.SourceNALPath, a.SourceVersion, a.State, a.SummaryDate
    FROM
    v_PackageStatusDistPointsSumm a

     WHERE a.ServerNALPath IN (SELECT
    ServerNALPath
    FROM
    v_PackageStatusDistPointsSumm
    WHERE ServerNALPath NOT IN (

     SELECT NALPath AS 'ServerNALPath '
    from v_SystemResourceList ))

    You can also follow the this solution http://blogs.msdn.com/b/rslaten/archive/2006/03/01/removing-a-retired-dp-from-all-your-packages.aspx to remove retired DP from all the packages.

    bad distribution points Configmgr 2007 configmgr report Failed to distribute packages failed to remove packages fix the retired DP retired DP's SCCM SCCM 2007 SCCM Reports SMS SQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Investigating Co-Management Issues with Windows Endpoints in SCCM/Intune

    October 26, 10:45 pm

    3 Comments

    1. Ted Ng on September 12, 2012 3:01 PM

      Hi Eswar,

      Is it queries to be run in Configuration Manager Console under Query? When I try to check: Select * from pkgservers with and without the full link. It said that The configMgr provider reported an error. How can I delete the package manually? I got Removal Pending problem. Thank you in advance.

      Reply
      • Eswar Koneti on September 12, 2012 6:47 PM

        You would require to exexcute the query in SQL server management studio with correct NAL path else it will go worse.
        Test it before trying in lab and if you are experincec with SQL,should be okay.

        Reply
    2. Pingback: Eswar Koneti’s Blog Blog Archive SCCM report for SMS Distribution Manager failed to remove package « jbwelch

    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.