I am using Fortigate appliance and using the local GUI for managing the firewall. In the logs I can see the option to download the logs. But the download is a .log file format. How can I download the logs in CSV / excel format. Is there a way to do that. I am not using forti-analyzer or manager.
Or is there a tool to convert the .log file to csv format. I am using forti-OS 5.6.2
But, how? If you are viewing Forward Traffic, apply some filters, then click the Download button to get only the data you want, you can't get a CSV. It only gives you *.log file with the text saved as above.
Is there some other method?
Or, a pattern for importing into Excel to convert to columns with headers?
If you need CSV, just remove the tab and replace tab with commas
sed 's/ /,/g' tlog.tab > tlog.csv
You have hundred of options on what you can do. You just have to be creative.Also don't forget if you do not havr a remote-log like fortianalyzer you can export logs to a syslog and facility and then do any manipulation on the syslog host
oh to export logs via syslog in csv change the settings
config log syslogd setting set status enable set mode reliable set port 6514 set format csv set enc-algorithm high set ssl-min-proto-version TLSv1-1 set certificate "fgt1-new1"end
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.