As per document we are seeing date and Time in UTC format.

IP address also is showing negative.

As per document we need to convert it to hex and then to decimal.

How we will be able to see CDR table report in proper format(date,time and ip address).

Pls guide

Vaishali

just follow the instructions on the doc on how to transform the data.

a google on unity epoch time will give you the formula

If u mean that you want the exported data to have it all in a readable format thats not possible, that is the way the CDR dump is and there is no way to change that thru any parameters, thats why we provide the doc

HTH

javalenc

if this helps, please rate

hi

Thanks

We are able to convert date and time.

Is there any formula that can convert ip address as well ?

from the same doc i already sent:

IP Addresses

The system stores IP addresses as unsigned integers. The database displays them as signed integers. To convert the signed decimal value to an IP address, first convert the value to a hex number, taking into consideration that it is really an unsigned number. The 32-bit hex value represents four bytes in reverse order (Intel standard). To determine the IP address, reverse the order of the bytes and convert each byte to a decimal number. The resulting four bytes represent the four-byte fields of the IP address in dotted notation.

Note The database displays a negative number when the low byte of the IP address has the most significant bit set.

For example, the IP address 192.168.18.188 displays as -1139627840. To convert this IP address, perform the following procedure:

Procedure

Step 1 Convert the database display (-1139627840) to a hex value.

The hex value equals 0xBC12A8C0.

Step 2 Reverse the hex bytes, as shown below:

CO A8 12 BC

Step 3 Convert the bytes from hex to decimal, as shown below:

192 168 18 188

Step 4 The IP address displays in the following format:

192.168.18.188

HTH

javalenc

if this helps, please rate

I know this is old, but I spent forever looking for the function that converted the decimal IP address (how it appears right out of a CDR dump) to a dotted ip address. here's the Excel function:

=CONCATENATE(HEX2DEC(MID((DEC2HEX(ABS(I2),8)),7,2)),".",HEX2DEC(MID((DEC2HEX(ABS(I2),8)),5,2)),".",HEX2DEC(MID((DEC2HEX(ABS(I2),8)),3,2)),".",HEX2DEC(MID((DEC2HEX(ABS(I2),8)),1,2)))

Just replace the four "I2" with the cell you want to convert.