Hot!how to download logs from Fortigate in CSV format

Author
sebastan_bach
Silver Member
  • Total Posts : 90
  • Scores: 3
  • Reward points: 0
  • Joined: 2008/04/03 11:04:47
  • Status: offline
2017/12/08 12:25:17 (permalink)
0

how to download logs from Fortigate in CSV format

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
#1

2 Replies Related Threads

    mahesh secure
    Silver Member
    • Total Posts : 83
    • Scores: 1
    • Reward points: 0
    • Joined: 2015/12/10 01:04:48
    • Status: offline
    Re: how to download logs from Fortigate in CSV format 2017/12/09 00:43:29 (permalink)
    0
    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
    #2
    tmelton
    New Member
    • Total Posts : 3
    • Scores: 0
    • Reward points: 0
    • Joined: 2019/04/17 10:45:53
    • Status: offline
    Re: how to download logs from Fortigate in CSV format 2019/05/07 07:08:41 (permalink)
    0
    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"
    #3
    Jump to:
    © 2019 APG vNext Commercial Version 5.5