[cisco-voip] Report of calls transfered to voicemail.

[Erick Wellnitz]

WARNING!!!  Use at your own risk.  I am not responsible if  you blow up
your server or cause system issues by running SQL commands.  Always,
always, always test in a lab first.

Set your terminal program (putty, etc.) to log output.

In CUCM 6 it looks like this:

run sql select calledpartynumber, datetimeorigination,
finalcalledpartynumber from car:tbl_billing_data where
finalcalledpartynumber = <your VM pilot number>

In CUCM 8  you use "run sql car select"  instead of defining the CAR
database with the table name. It might look like this if the row names are
the same:

run sql car select calledpartynumber, datetimeorigination,
finalcalledpartynumber from tbl_billing_data where finalcalledpartynumber =
<your VM pilot number>

Open the saved output log with Excel as delimited (tab or space, I
believe).  Convert the epoch time to human readable time as described here:
http://www.blindhog.net/convert-epoch-time-in-excel/

Again, use at your own risk.


On Fri, Mar 2, 2012 at 5:03 AM, Robin Clayton <Robin.Clayton at rrfa.org.uk>wrote:

>  CCM7 & UC7
>
>
>
> Dear all,
>
>
>
> I am trying to get a report of how many calls are going to voicemail
> rather than being answered. I have looked in CDR but can’t find a way to
> get this information, I have looked in unity but can’t find it either.
>
>
>
> Any pointers???
>
>
>
> Cheers
>
>
>
> Robin
>
>
>
>
>
>
>
>
>
> *=========================*
>
> *Robin Clayton*
>
> * *
>
> *Network Transition Manager*
>
> *Richard Rose Federation*
>
> *Richard Rose Central Academy*
>
> *Victoria Place*
>
> *Carlisle*
>
> *Cumbria*
>
> *CA1 1LY*
>
> * *
>
> *Tel: 01228 822075*
>
> *www: www.rrfa.org.uk*
>
> * *
>
>
>
>
> --------------------------------------------------------------------------------------------------------------
>
> *Important Notice:*
>
> This e-mail and any attachment are confidentialand may be privileged
> or otherwise protected from disclosure. It is solely intended for the
> person(s) named above. If you are not the intended recipient, any
> reading, use, disclosure, copying or distribution of all or parts of this
> e-mail or associated attachments is strictly prohibited. If you are not
> an intended recipient, please notify the sender immediately by
> replying to this message or by telephone and delete this e-mail and
> any attachments permanently from your system.
> *The Richard Rose Federation <http://www.rrfa.org.uk/>*
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120302/7640eb22/attachment.html>