Log Timestamp Format

From Swivel Knowledgebase
Jump to: navigation, search


Overview

The Swivel log Timestamp provides the date and time of an event, this can be converted into an easy to read format.


Prerequisites

What is required to resolve the issue, versions etc.


Symptoms

Swivel Log Timestamp is not easily readable


Solution

Use the following forumla in Excel and format the cell to as a date or time or a custom value of date and time:

=25569+value/86400000

Example for a timestamp of: 1266929100563

=25569+1266929100563/86400000

For the format dd/mm/yyyy hh:mm:ss This gives:

23/02/2010 12:45:01


Log File times

The timestamp in the log file is converted to a date and time using a JavaScript function on the client. This means that it always refers to local time for the client machine, not on the appliance itself.