Browse By

Cisco CDR Reporting Tool Automated

Cisco CDR Reporting Tool Automated

When you are working on the CDR Dump either for reporting or troubleshooting, are you tired of converting Signed Integers to an IP Address or referring to the cause codes again and again and do your analysis? I have created an excel sheet for Cisco CDR which is actually handy while troubleshooting or reporting. The excel sheet can do the following task.

  • Converting origIpAddr to a readable IP Address. For Example. The value “-1139627840” is converted to an X.X.X.X IP Address which is 192.168.18.188
  • Converting destIpAddr to a readable IP Address. For Example. The value “-1139627840” is converted to an X.X.X.X IP Address which is 192.168.18.188
  • Converting origCause_value from Number to a readable error code. For Example. The value “16” is 16-Normal call clearing
  • Converting destCause_value from Number to a readable error code. For Example. The value “16” is 16-Normal call clearing
  • Converting dateTimeOrigination to a readable Time Format in GMT. For Example. The value “1436193921” is converted to a readable format “7/6/2015  2:45:21 PM” in GMT
  • Converting origCallTerminationOnBehalfOf from Number to a readable error code. For example. The value “12” is 12 – Device
  • Converting destCallTerminationOnBehalfOf from Number to a readable error code. For example. The value “12is 12 – Device
  • Converting origCalledPartyRedirectReason from Number to a readable error code. For example. The value “354is 354-Recording
  • Converting lastRedirectRedirectReason from Number to a readable error code. For example. The value “354is 354-Recording

To download the File, click on the the link here.

Please share your comments and let me know if you would like to add or modify something and i will try my best to achieve it.

Have fun!!

Published by Team UC Collabing

6 thoughts on “Cisco CDR Reporting Tool Automated”

Leave a Reply

Your email address will not be published. Required fields are marked *