Improve the view in converted SSL session .csv files for SSL Visibility Appliance
Article ID: 168591
SSL Visibility Appliance Software
Reviewing SSL session files and Wireshark captures to troubleshoot and analyze a problem can sometimes be daunting as the time fields for the two tools do not match up. This can be improved by changing the time format on the time_display column on the Excel spreadsheet.
Select the time_display column within the Excel spreadsheet, then right click; you are presented with a menu.
Choose the option Format Cells; a new pane displays.
Choose the Number tab, and select Custom at the bottom of the listed options.
Within the Type text box, enter the following value "m/d/yy h:mm:ss.00;@". This will change the format to date, hour, seconds, and milliseconds. You may add an additional zero on the end to bring it down to thousandths.