Extension Useage Report

[Hesh]

Howdy all,

I was wondering if there is a way to configure a report that I can run to show extensions that have not been used within a set time period; ie no calls made/received within last 6 months, etc.
Looking to perform some capacity management as we have had quite a bit of departmental relocation's/closures.

Thank you
Hesh

[Zero]

Hi Hesh,

I believe there’s no such predefined report and specific definition that pertains on your requirements. However, I am thinking that you can define a report for your requirement as a workaround. Try to create a report that will generate last six (6) months records and show each extension. After the generation, you can identify the extensions that were frequently used then from your list of created extensions try to eliminate the extensions on your report to gather all not used in the last six (6) months. From here, you can also make other observation like generating the report per each previous month so you can trace the oldest extensions that were not being used.

I hope this helps.

Thank you.



Regards,
Zero

[Hesh]

Hi Zero,

Thank you for your response.

I figured as much. To be honest, I have no idea on how to create my own reports from scratch. The Report module is not exactly brimming with helpful tips.
Are there any freeware tools that may provide some guidance? I have messed around with some of the existing reports but have had no success.
Any guidance would be appreciated.

Thanks
Hesh

[Zero]

Hi Hesh,

1. Go to Report
2. Double-click Accounting folder
3. Choose the folder of [user account name] e.g. AdminNmc
4. Right-click [user account name] and choose Add\Definition…
5. After, choose Record\Grouped\
6. Input text on Definition Name e.g. Summary Report
7. After, click OK button
8. Refer to the created report definition e.g. Summary Report, click Querytool tab
9. Select Date folder and look for the Date item under and double-click to add
10. Select Organization folder and look for Extension item under and double-click to add
11. Select Records folder and look for No. of Calls item under and double-click to add
12. Now, focus on the added items as columns
13. Refer to column Date,
a. look for the Display parameter and change the value from Detailed to Group Header
b. look for Generation Time Filter parameter and put a check on the checkbox
c. look for Filter parameter and click the … button then set values as Date greater than or equal to [specify start date] and less than or equal to [specify end date]
14. Refer to column No. of Calls,
a. Look for Operation parameter and change the value from Group By to Sum
15. Save the created report definition by clicking the save disk icon on the upper left of the window


With this report definition, your report will show the extensions that has call records for the specific date.

I hope this information helps your concern.

Moreover, try to explore other fields and parameters to observe other related results that may have on report module.



Thanks,
Zero

[Hesh]

Thanks Zero! I now know how to do it and have managed to fiddle with those variables to provide a report that actually contains some meaning.
Your assistance has been greatly appreciated!

Cheers
Hesh