How to delete obsolete Distribution Points?
How to delete obsolete Distribution Points?
(OP)
Hi All,
I get Error 2302 in the SMS_DISTRIBUTION_MANAGER for non-existing Distribution Points. These Distribution Points were removed from SMS long back. How to remove non-existing/obsolete Distribution Points completely from SMS?
-Keshav
I get Error 2302 in the SMS_DISTRIBUTION_MANAGER for non-existing Distribution Points. These Distribution Points were removed from SMS long back. How to remove non-existing/obsolete Distribution Points completely from SMS?
-Keshav
RE: How to delete obsolete Distribution Points?
http://www.myitforum.com/forums/m_158677/tm.htm
If so you can use this SQL syntax to locate the DP's in the DB and then you can remove them. In the display 1 syntax, replace the sitecode with the sitecode of site B. This should give you a list of known DP's to that site.
Display 1
Select * from pkgstatus where Sitecode = 'XXX'
Select * from pkgservers where Sitecode = 'XXX'
In display 2, choose the name of the DP you'd wish to remove.
Display 2
Select * from pkgstatus where Sitecode = 'XXX' and pkgserver like '%dp-name%'
Select * from pkgservers where Sitecode = 'XXX' and nalpath like '%dp-name%'
Once your satisifed that you have the DP you wish to delete listed in the syntax of Display 2, then enter that Dp's name into the Delete 1.
Delete 1
Delete from pkgstatus where Sitecode = 'XXX' and pkgserver like '%dp-name%'
Delete from pkgservers where Sitecode = 'XXX' and nalpath like '%dp-name%'
You can repeat the steps as many times as necessary. This should remove the DP's from SMS know list of DPs.
As always, double-check and make sure your deleting the correct one, otherwise all your DP's could be deleted.
RE: How to delete obsolete Distribution Points?
-Keshav
RE: How to delete obsolete Distribution Points?
Tim B
RE: How to delete obsolete Distribution Points?
-Keshav