How to bulk delete the unused/inactive DIRECTORY Numbers

[RAVIKUMAR J K]

Hi All,

Can anyone shed some light on how to find out and delete unused DNs. not unassigned . Because there could be some virtual DNs used for some forwarding purpose.

Is there a way we could do this?

Any suggestions please...

[Manish Gogna]

Hi Ravi,

You can run a report under Call Routing > Route Plan Report to search for all Unassigned directory numbers and then delete them in one go from there.

HTH

Manish

[RAVIKUMAR J K]

Hi Manish,

Thanks for replying.

I have a requirement like this.

I have list of DNs not associated to any device to be deleted. In unassigned report, it will show up all DNs , even the ones actually being used as virtual DN for forwarding etc.

So is there any possibility like creating a custom file for the DNs I have and delete them in one shot.

Thanks

Ravi

[Manish Gogna]

Hi Ravi,

You can use the following sql query to get a list of DN's with VM enabled

run sql select dnorpattern,cfadestination,cfavoicemailenabled from  CallForwardDynamic c, numplan n where c.fknumplan = n.pkid and  (cfadestination != '' or cfavoicemailenabled ='t')

Then you can compare that with the output from Route plan report and delete them.

HTH

Manish