Cisco Support Community
Community Member

Determine What Extensions are Unused


I acquired an IPT system and we're running short on extensions that fall within our DID range. We have pub/sub CCM ver 4.1sr3c.

What I'm looking for is some way to easily determine unused extensions. I know there has been turn over and plenty of these numbers are unused. Is there a ways to see activity or another way to determine what numbers have not been in use for awhile?

Thank you,



Re: Determine What Extensions are Unused

Route Plan-> Route Plan Report-> Right Click on View in File -> save as CVS

Open the CVS using Excel, you now have an overview of your Dial Plan.

Use then CDR and see which number wasnt active for a time period you specify.

Hall of Fame Super Red

Re: Determine What Extensions are Unused

Hi Chris,

Try this method via the Route Plan Report;

Deleting Unassigned Directory Numbers

This section describes how to delete an unassigned directory number from the route plan report. Directory numbers get configured and removed in the Directory Number Configuration window of Cisco CallManager Administration. When a directory number gets removed from a device or a phone gets deleted, the directory number still exists in the Cisco CallManager database. To delete the directory number from the database, use the Route Plan Report window.



Step 1 Choose Route Plan > Route Plan Report.

The Route Plan Report window displays. Use the three drop-down list boxes to specify a route plan report that lists all unassigned DNs.

Step 2 Three ways exist to delete directory numbers:

a. Click the directory number that you want to delete. When the Directory Number Configuration window displays, click Delete.

b. Check the check box next to the directory number that you want to delete. Click Delete Selected.

c. To delete all found unassigned directory numbers, click Delete all Found Items.

A warning message verifies that you want to delete the directory number.

Step 3 To delete the directory number, click OK. To cancel the delete request, click Cancel.

From this good doc;

Hope this helps!


Community Member

Re: Determine What Extensions are Unused

Looks like 2 awesome suggestions that help give me a start. I did forget one little detail though, we use extension mobility. So I think I'll have to use a combination of both ideas to get this done right.

I think I'll use the "Unassigned" route plan report, that'll at least get me in a little better shape. Then I can proceed with look them up via CDRs.

Thanks for the help.

Take care,


CreatePlease to create content