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

4 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 : 4
    • 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
    theArties
    Bronze Member
    • Total Posts : 22
    • Scores: 2
    • Reward points: 0
    • Joined: 2017/04/04 00:04:32
    • Status: offline
    Re: how to download logs from Fortigate in CSV format 2020/06/30 07:06:18 (permalink)
    0
    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.
    #4
    emnoc
    Expert Member
    • Total Posts : 5732
    • Scores: 371
    • Reward points: 0
    • Joined: 2008/03/20 13:30:33
    • Location: AUSTIN TX AREA
    • Status: offline
    Re: how to download logs from Fortigate in CSV format 2020/06/30 08:26:03 (permalink)
    0
    I want to say you can export the logs form fortianalyzer and achieve this.
     
    Ken Felix

    PCNSE 
    NSE 
    StrongSwan  
    #5
    Jump to:
    © 2020 APG vNext Commercial Version 5.5