how to download logs from Fortigate in CSV format

Forum|Forum|8 years ago
December 8, 2017
2 replies
31674 views

Hi,

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

appreciate any help.

Sebastan

mahesh_secure

New Member

Hi Sebastan

i try with fileviewer plus. its support .log file. once open it copy and past to excel and use data-->text to colums feature in excel to convert.

hope helps you

Regards

Mahesh

tmelton

New Member

That works great with CSV format, but these file are not in that format.

this format does not turn into a please set of columns.

date=2019-05-07 time=08:17:29 logid="0102043040" type="event" subtype="user" level="notice"

theArties

New Member

Hi there,

I know the last post has been a while back, but wondering if there's a latest answer to the question?

Having similar issue importing the log into excel. Or is it meant to be this way?

Thanks.

emnoc

New Member

I want to say you can export the logs form fortianalyzer and achieve this.

Ken Felix

aleg

New Member

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?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded