NGFW CSV Export Question

[Josh990]

Hi there,

I'm trying to get the seconds counter to show in NGFW Threat Monitoring CSV log exports.

Currently, despite the seconds counter being displayed in the logs on the NGFW, these are not recorded in CSV exports of the logs - only the hour and minute counter is recorded.

Is there an option to enable this somewhere? I can't seem to find it.

Thanks

[BPry · Accepted solution]

@Josh990,

When you do a CSV output the Time Logged and Receive Time fields will display up-to the hour and minute, but the actual data within the field properly displays the second information. This is due to Excel formatting, and if you update the format to 'm/d/yyyy hh:mm:ss' it'll display the second data.

[Josh990]

Thank you - it was Microsoft all along 🙂