?
Solved

How to import Fortigate logs into Qlikview

Posted on 2014-09-23
5
Medium Priority
?
891 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 43

Expert Comment

by:Rob
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 43

Expert Comment

by:Rob
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 43

Accepted Solution

by:
Rob earned 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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…

800 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