Cisco IP Telephony Troubleshooting Guide for Cisco CallManager Release 3.0(1)
© 2000 Cisco Systems, Inc.
80
Deciphering the Time Stamp
Using Microsoft Excel, you can write a formula to make converting this time stamp a little
easier. If the value is in cell A1, you can make another cell:
=A1/86400+DATE(1970,1,1)
There are 86400 seconds in a day.
Then format the resulting cell as a date/time field in Excel.
IP Addresses
All IP addresses are stored in the system 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 32bit Hex value
represents 4 bytes. The 4 bytes are in reverse order (Intel standard). To get the IP address,
reverse the order of the bytes, and convert each byte to a decimal number. The resulting 4 bytes
represent the 4-byte fields of the IP address in dotted notation.
Note: The database will display it as a negative number when the low byte of the IP address has
the most significant bit set.
Converting IP Addresses
For example: IP Address 192.168.18.188 would be displayed as follows
Database Display = -1139627840.
This converts to a Hex value of 0xBC12A8C0.
Reverse the Hex bytes = C0A812BC
CO A8 12 BC
Bytes Converted from Hex to Decimal = 192 168 18 188 which would be displayed as
192.168.18.188.
Example2: IP Address 192.168.18.59
Database Display = 991078592
This converts to a Hex value of 0x3B12A8C0
Reverse Byte order = C0A8123B
C0 A8 12 3B
Bytes Converted from Hex to Decimal = 192 168 18 59 which would be displayed as
192.168.18.59.
