+ Post New Thread
Results 1 to 5 of 5
Internet Related/Filtering/Firewall Thread, Fortinet and SQL in Technical; Has anyone used the SQLite logging tables within Fortinet to create some dynamic web pages with traffic info? Wes...
  1. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Fortinet and SQL

    Has anyone used the SQLite logging tables within Fortinet to create some dynamic web pages with traffic info?


    Wes

  2. #2

    Join Date
    Apr 2012
    Location
    Leeds
    Posts
    302
    Thank Post
    0
    Thanked 67 Times in 53 Posts
    Rep Power
    36
    personally no, but may engineers may have. Let me know exactly what you are looking to do and I'll go ask the chaps and see if we can give you some free help. They are Fortinet qualified so should be able to

    Dave

  3. #3
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    I would like to query the box to get hourly, daily, weekly, monthly, termly and yearly usage reports however there isn;'t much info in the basic documentation there may be more in-depth info hidden away but I haven't been able to find it as yet (probably typing in the wrong search parameters). Really all I need to know is how do I connect to fortinet's sql db and which tables/records i should look at?


    Thanks,


    Wes

  4. #4

    Join Date
    Apr 2012
    Location
    Leeds
    Posts
    302
    Thank Post
    0
    Thanked 67 Times in 53 Posts
    Rep Power
    36
    Quote Originally Posted by wesleyw View Post
    I would like to query the box to get hourly, daily, weekly, monthly, termly and yearly usage reports however there isn;'t much info in the basic documentation there may be more in-depth info hidden away but I haven't been able to find it as yet (probably typing in the wrong search parameters). Really all I need to know is how do I connect to fortinet's sql db and which tables/records i should look at?


    Thanks,


    Wes
    ok, your best bet is to use FortiAnalyzer that does all this via a really easy to use GUI. You can buy a box or use our remote logging service via an ADOM (as we do this for our own clients anyway)

    Fortianalyzer is their Fortinets advanced reporting service and compliments the Fortigate firewalls. See Network Security Reporting, Logging and Analyzing | Fortinet

    Thanks

    Dave

  5. #5
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30
    How would I go about using your system via an ADOM?

    I'm still interested to see if I can connect to it myself and setup a web server to report on it if you can help?


    Wes

SHARE:
+ Post New Thread

Similar Threads

  1. CMIS and SQL 2008 install
    By sgavan in forum MIS Systems
    Replies: 2
    Last Post: 9th July 2009, 02:31 PM
  2. php and sql ?
    By mac_shinobi in forum Web Development
    Replies: 15
    Last Post: 21st October 2008, 09:43 AM
  3. SIMS and SQL Express
    By interele in forum MIS Systems
    Replies: 3
    Last Post: 2nd February 2008, 05:43 PM
  4. SIMS and SQL, which version
    By andrewsmart in forum MIS Systems
    Replies: 4
    Last Post: 14th June 2007, 08:13 PM
  5. unix and sql commands
    By danIT in forum General Chat
    Replies: 9
    Last Post: 14th February 2007, 01:19 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •