Solved

How to import Fortigate logs into Qlikview

Posted on 2014-09-23
5
745 Views
Last Modified: 2014-09-29
Hi Experts,

I am trying to export Fortigate firewall logs and QLikview retrieve them. Is there any way that Qlikview can retrieve the Database of the Fortigate to pull out those logs?
Please advise
0
Comment
Question by:chenzovicc
  • 3
  • 2
5 Comments
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
ID: 40340420
it really depends on the file format but If it can't do it directly then the wizard should be able to parse the data. Do you have a sample log file I could test with?
0
 

Author Comment

by:chenzovicc
ID: 40344537
Thanks for your reply but I can't provide a sample file cause is company policy. I notice that when I export it manually is a log file which I tried to open in excel and I can see all the information. One of my co-workers made it delimited to be able to sort it out by columns.
Will QLikview able to import that data if I export it somewhere in  a folder?
0
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
ID: 40345133
Will QLikview able to import that data if I export it somewhere in  a folder?
based on what you said regarding excel, yes it will be able to import it.
If you have odbc access to the database it could access directly
0
 
LVL 42

Accepted Solution

by:
Rob Jurd, EE MVE earned 500 total points
ID: 40345195
I'm looking through the fortigate manual: http://docs.fortinet.com/uploaded/files/1048/fortigate-loggingreporting-40-mr3.pdf

Page 17: The SQLite log database

Qlikview will be able to connect to this via an ODBC driver (e.g. http://www.ch-werner.de/sqliteodbc/).  Use the wizard in your QV script to connect to it and you'll see all the tables in the database.
0
 

Author Closing Comment

by:chenzovicc
ID: 40350928
We have a Qlikview person and I will ask him base on the information you provided. Thanks a lot.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Imagine you have a shopping list of items you need to get at the grocery store. You have two options: A. Take one trip to the grocery store and get everything you need for the week, or B. Take multiple trips, buying an item at a time, to achieve t…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now