Solved

How to import Fortigate logs into Qlikview

Posted on 2014-09-23
5
758 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I found an issue or “bug” in the SonicOS platform (the firmware controlling SonicWALL security appliances) that has to do with renaming Default Service Objects, which then causes a portion of the system to become uncontrollable and unstable. BACK…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

911 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

22 Experts available now in Live!

Get 1:1 Help Now