Traffic analysis - Call Manager Extention Usage Report

Could anyone help with how to run a Call Manager report showing which phones have not been used for 30 days.

For example, we have no more extention numbers left, and we would like to know which lines can be re-allocated i.e. which lines are not being used.
Who is Participating?
using the CDR search by Phone Number page to find the number which is seldom used

or export the CDR raw data and sort out in excel file.
José MéndezCommented:
You may also want to double check if there are extension numbers unassigned to devices, therefore wasting resources. Go to Call Routing > Route Plan Report > Choose Unassigned numbers and then find.

If any, you may click one of the numbers and make sure the Active checkbox is not ticked. If it is, then it may be used to forward all or something of that sort. Otherwise you may use it or delete it.

Another recommendation is, that you can repeat numbers. You may have extension 4567 in partitionA and 4567 in partitionB, in case that helps.
SuncoreAuthor Commented:
Thanks both for your suggestions, ybyuen - I have exported the CDR data and imported into excel, however I cant see which column shows when each extention was last used?

Is this information included?
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

José MéndezCommented:
Ok, you can do this through the Command Line:

1- Log in through SSH with administrator creds to the Publisher server
2- run this command:

run sql select datetimeconnect from car:tbl_billing_data where datetimeconnect < 1321833600 and callingpartynumber = <the ext number you know is inactive>

or just

run sql select datetimeconnect, callingpartynumber from car:tbl_billing_data where datetimeconnect < 1321833600

The first one will throw all calls for an extension you suspect has been idle for at least 30 days. The 1321833600  number is the amount of seconds since 1970, or the so called epoch time which you can convert back and forth from here

The second query will throw any number which last call dates before November 21 2011.

Hope it helps
SuncoreAuthor Commented:
Perfect - Thankyou.
SuncoreAuthor Commented:
run sql select datetimeconnect, callingpartynumber from car:tbl_billing_data where datetimeconnect < 1321833600 <--- This was the solution we used, as suggested above by willlywilburwonka - thanks.
José MéndezCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.