Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to import Fortigate logs into Qlikview

Posted on 2014-09-23
5
Medium Priority
?
986 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 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

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

Question has a verified solution.

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

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

564 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