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/archive on the active node.
- Unzip the audit log file (extension .csv.gz).
- 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
following formula =XX/ 86400000 + 25569
- Y/24 in 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.
Figure 1: Formatting the Local Times
Column in Microsoft Excel
- Save the Microsoft Excel file.
