Export forwarded logs in csv format

[MORAMADAN]

Hello Bro,

              I have been trying to export "forwarded logs" in a csv format for filtration process but still don't know how? any ideas?

knowung that, fortigate software version 7.0.11, and no fortianalyzer

TIA

[srajeswaran]

While downloading the log file, save it as .csv file. Then we can try using "Text to Columns" option available on excel to move the data to separate columns. Use "space" as delimiter.

Ref: https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-t...

[MORAMADAN]

Hi Sraj,

          Thank you so much for your assistance, I have tried the MS excel text to data methde but it was not as expected since the downloaded logs are not equally when using spaces as a separator, ie... filds are not well suitable for beingseparated by spaces.

If any more ideas will be appreciated,

[srajeswaran]

I am not sure if there is a better way. Is there any specific filters that you are not able to apply directly on fortigate?

[MORAMADAN]

I am using no the logs filter on the firewall, but sometimes we need to work offline while we have no access to the firerwall, so we export the logs trying work on it in offline.

[srajeswaran]

Hi Ramadan, one issue I can see is with "dstcountry="United States"", the country has a space and that is breaking the delimiter function. Are you seeing the same issue or different?

[MORAMADAN]

Hello Sraj,

               Thank you for your response but it seems many other fields are affected and not delemited equally.

[Faiza_Emam_Delhi]

To export forwarded logs in a CSV format on a FortiGate device running FortiOS 7.0.11, you can follow these steps:

1. Log in to the FortiGate device web interface.

2. Go to Log & Report > Log Settings > Forwarding.

3. Click the Export button at the top of the page.

4. Select the log type that you want to export (e.g., Traffic, Event, etc.).

5. Set the date range for the logs that you want to export.

6. Set the format to CSV.

7. Click the Download button to download the exported logs in a CSV format.

With these steps, you should be able to export forwarded logs in a CSV format on your FortiGate device. Note that the exported logs may be limited to a certain number of records, depending on the device's settings. If you need to export a larger number of records, you may want to consider using a FortiAnalyzer device or another log management solution.

[MORAMADAN]

Hello Emam,

                   Thank you for your assistance but no "Forwarding --> Export button at the top of the screen".

[MORAMADAN]