How to convert the FortiGate firewall logs in csv format, please provide the solution.
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
Hey dayalan,
essentially:
1. Download the log from FortiGate
-> you should get a list of logs, with each field separated by a space
2. Open Excel, and open an empty worksheet
3. Click on 'Data', then 'From Text/CSV'
4. Select the downloaded log file (you might need to enable 'All Files' in the lower right corner, not just 'Text Files'
EDIT:
5. Set the delimiter to space custom
6. Click on 'Load'
7. This will broadly let you import the data to Excel and you can then export it as csv.
8. Please note that spaces in log messages or other log fields may cause issues with recognizing the individual log fields if you use space as delimiter
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1641 | |
1069 | |
751 | |
443 | |
210 |
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.
Copyright 2024 Fortinet, Inc. All Rights Reserved.