SCCM Configmgr delete retired orphaned distribution points

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.