Converting the Junos Space Audit Log File Timestamp from UTC to Local Time Using Microsoft Excel
You can unzip the compressed comma-separated values (CSV)
audit log file (extension
.csv.gz) and open the extracted CSV file as a spreadsheet in Microsoft Excel.
In Microsoft Excel, you can convert the entries in the Timestamp column
from UTC (GMT) to local time.
To convert UTC time to local time:
- Retrieve the audit log file from where you archived it.
If you archived the file locally, the file is located in
/var/lib/mysql/archiveon the active node.
- Unzip the audit log file (extension
- Open the unzipped audit log file (extension
.csv) in Microsoft Excel.
- To the left of the UTC Time column, insert a new column.
- Label the column header Local Time.
- Click the first cell of the new column and insert the
=XX/ 86400000 + 25569 - Y/24in the cell, where XX represents the cell letter and row number where you want to insert the local time-conversion function and Y represents the difference in hours between your local time and the UTC time.
- Press Enter.
The calculated local time appears in the cell.
- Format the local time by right-clicking the cell and selecting Format Cells.
The Format Cells dialog box appears.
- From the Category list, select Date.
- From the Type list, select a date format that you want.
- Click OK.
The local time and date are displayed in the specified format.
- Copy or apply the cell function and formatting to the rest of the rows in the Local Time column. The rest of the local times appear as shown Figure 1.
- Save the Microsoft Excel file.