I am attempting to use Crystal reports to generate call detail reports using the CDR database in call manager. I am having problems with the date/time fields. The values are integers, but I have no idea how to convert them to date/time format.
You see it all started when microsoft decided to change to use different starting date than Unix. The time desplayed in CDR is unix time called epoch. Take the time that CDR gives you and put it in an excel spread sheet than enter this fprmula in the field next to it, note that D2 is the field with the epoch in it.
Format the cell with the formula in it for time and you got it. This is Grenich mean time, you will need to add or subtract hours based on your location.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
[toc:faq]CUCM Database Replication is an area in which Cisco customers
and partners have asked for more in-depth training in being able to
properly assess a replication problem and potentially resolve an issue
without involving TAC. This document discusse...