Technical Tip: How to Export Firewall logs in CSV ...

FortiGate

FortiGate Next Generation Firewall utilizes purpose-built security processors and threat intelligence security services from FortiGuard labs to deliver top-rated protection and high performance, including encrypted traffic.

Article Id 329044

Description

This article describes how to export Firewall logs in CSV format.

Scope

FortiGate v6.4.X, v7.0.X,v7.2.X and v7.4.X.

Solution

There is no option available to export logs in the CSV format. The 'log' is the only format available. One workaround exists to import it in the CSV format.

Prerequisite:

Make sure the FortiGate is sending the logs to the FortiGate Cloud.
Follow this KB article Technical Tip: Sending logs to FortiCloud.

Solution:

Once the account is set up, log in to https://login.forticloud.com/ and 'double-click' on the FortiGate to import the logs.

Go under Logview -> Traffic.

Select Export.

The file that will be downloaded is in the CSV format.

Note: There is only a limit of up to 2000 log entries that can be exported in CSV format.

615

Broad. Integrated. Automated.

The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.

Technical Tip: How to Export Firewall logs in CSV format