Create a report for all call activity

[capadonad]

Hello,
I have a need to create a report of all external calls that came into our Cisco phone system during a certain timeframe to specific numbers.  Also, they want to know which calls ended up in voicemail.  Any ideas on how to do that and have the report readable for an end user?  I did find something under CDR, then under Device Reports.  There are some reports form there, but they seem a little inaccurate.  Also, I don't know how to see if the call terminated into voicemail.  Any advice would be greatly appreciated.

Thank you!

Dan

[nathanjgrace]

Hi Dan, if you run a CDR dump for the time period, you'll be able to see the finalCalledParty column- if this is your VM pilot, you'll know these calls were forwarded to VM.  The only trick to this is that the date/time columns must be converted from epoch time.  Use the below formula to convert and you should have the date you need.

=CELL/(60*60*24)+"1/1/1970"

Hope this helps!

-Nathan

[capadonad]

Awesome, thanks Nathan.  I'll give that a shot!

Dan