Update to a previous post…
Provided as is – you break your box all on your own buddy! Lab this first.
The offending DNs can be queried using:
SELECT n.dnorpattern FROM numplan n LEFT OUTER JOIN devicenumplanmap m ON m.fkdevice = n.pkid WHERE m.fkdevice IS NULL AND n.tkpatternusage = '2' AND n.iscallable = 't'
- m.fkdevice is null assures the Route Plan element is unassigned
- tkpatternusage = ‘2’ matches DNs only
- iscallable=’t’ defines the “Active” checkbox on the DN page – and our offending behaviour.
Some help came from here.
Construct your own UPDATE SQL statement to fix it! As assistance – start here, it’s not too difficult.