Monthly WAN Availability and Reachability Reporting with FortiAnalyzer (without SD-WAN)

Hello everyone,

we have a customer who would like to generate a monthly report using FortiAnalyzer that includes the following information:

• WAN gateway availability over the reporting period (monthly uptime/availability)
• Reachability of defined WAN targets (e.g. public IP addresses or external services) from the FortiGate
• Information about when WAN failover events occurred, including timestamps
• A summary of all failover incidents within the reporting period

The environment does not use SD-WAN. Standard WAN interfaces and failover mechanisms are configured.

Is it possible to create such a report using FortiAnalyzer?

I don't have any knowledge of SQL, and despite extensive research, I have no idea how to implement this. If necessary, I would recommend Fortinet Professional Services to the customer.

Any guidance or best practices would be appreciated.

Thank you.

KR
Niko