Report to show extensions never used

Unanswered Question
Jan 15th, 2008

I'm starting to run low on available extensions in my CCM 4.2(3) and wanted to know if there is a report that will tell me if an extension was ever used or not?



I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
rob.huffman Tue, 01/15/2008 - 16:47

Hi John,

Hope all is well with you!

Here is a method to list all the DN's (Used and Unused) in CCM;

Route Plan Report

The route plan report lists all assigned and unassigned directory numbers (DN), call park numbers, call pickup numbers, conference numbers, route patterns, translation patterns, message-waiting indicators, voice mail ports, and Cisco CallManager Attendant Console pilot numbers in the system. The route plan report allows you to view either a partial or full list and to go directly to the associated configuration windows by clicking the Pattern/Directory Number, Partition, or Route Detail fields.

In addition, the route plan report allows you to save report data into a .csv file that you can import into other applications. The .csv file contains more detailed information than the web pages, including directory numbers for phones, route patterns, pattern usage, device name, and device description.

From this good doc;

Hope this helps!


j.mccartney Tue, 01/15/2008 - 19:25

Thanks Rob!

I will look at this again. I think I ran this a while before but I couldn't find out if a user had logged in recently is really what I'm after. I'm trying to findout if an assigned ext has had no activity (ie: never logged in or used) so I can free them up for some new users that are coming into my facility soon. I will give this a look again. Thanks as always.

rob.huffman Wed, 01/16/2008 - 06:44

Hi John,

Sorry, I don't think this report is going to help you at all :( And I don't know of any "canned" report that will. This will entail some serious detective work on your part. The only place that is going to show Login/Logout activity is in the EM Trace Files. So if you suspect that a user is not making use of a DN, you will have to look here.

Locate the Cisco CallManager Extension Mobility application trace files at:


Or like suggested you might be better off looking in CDR/Art for calling patterns associated with the "suspect" DN's.

Hope this helps!


Rajesh Revuru Wed, 01/16/2008 - 07:21

I am not sure if this is of any help...Does unity have some user activity reports though, but it doesnt necessarily tell whether the user is using particular phone or something else.

j.mccartney Wed, 01/16/2008 - 07:23

I did run a report off Unity but as you stated it doesn't tell you the last time a user logged in. That's my dilema - Thanks to all who responded.



This Discussion