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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

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:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Voice Over IP

From novice to tech pro — start learning today.