Delete Orphaned Distribution Points From SCCM Packages
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: SCCM, SQL
2012/05/15 at 03:28:40
vague instructions