Hi,
I want to generate a specific FortiAnalyzer report as a PDF file, which contains all policy changes of my in total 10 fortigates. Each fortigate has in total 5-10 policies. My ambition is to get an monthly automatic generated PDF report of all policy changes from all policies and fortgates I've done during this time.
The report should list the following issues: Policy ID, Device ID, Device Name, Source IP, Destination IP, Source Interface, Destination Interface, Action, Log ID & the Timestamp of the change.
So I've seen in the FortiAnalyzer, that there is no pre-generated report like that.
I know this report is possible with SQL code/ dataset only. So I've started a small and non finish SQL code because I'm a SQL beginner. This ist my SQL code currently:
My question is, can anybody complete my SQL code so that all issues are included and the validation without any warnings?
And can anybody explain me the nessecary steps and settings I've to do in FortiAnalyzer to get a correct automatic generated PDF report?
Thank you guys!
Mike
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
Hi Mike
I'm not expert in FortiAnalyzer's Datasets but for your first question I guess you need to add an "order by" command at the end, in order to sort the result.
Something like this:
order by datestamp desc
Then I guess you need to create a chart of type "table" and use your dataset in it.
Alternatively you may use the chart builder (easier) from Log View:
Hope it helps
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1547 | |
1030 | |
749 | |
443 | |
210 |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.