Delete Orphaned Distribution Points From SCCM Packages

/ March 9th, 2010/ Posted in Configuration Manager / 1 Comment »

1. Backup the database.

2. Find the entries for the DP package share:

Select * from pkgservers where NALpath like ‘%\\Server%’
Select * from pkgstatus where pkgserver like ‘%\\Server%’
Select * from contentdpmap where serverpath like ‘%\\Server%’
Select * from DPinfo where servername like ‘%Server%’
3. Delete any entries from any of the above tables that point to the nonexistent share:

Delete from pkgservers where NALpath like ‘%COMPUTERNAME’ 
Delete from pkgstatus where pkgserver like ‘%Server%’
Delete from contentdpmap where serverpath like ‘%Server%’ 
Delete from DPinfo where servername like ‘%Server%’


Tags: ,

One Comment

  1. swsron
    2012/05/15 at 03:28:40

    vague instructions

Leave a Reply

Name required

Please Submit Answer * Time limit is exhausted. Please reload CAPTCHA.