Fortimanager Report

[Christian_89]

Hello everyone

I want to go to Fortimanager
Create a report that outputs the firmware status and system uptime as well as the host name.
Unfortunately my attempt below shows nothing.

SELECT
hostname AS "hostname",
SUM(sysuptime) AS "Total sysUptime",
version AS "Firmware Version"
FROM
$log
WHERE
$filter
GROUP BY
hostname, version
ORDER BY
"Total sysUptime" DESC

[ymorohashi]

You must enabled FortiAnlyzer feature, right?
FortiAnalyzer get value from logs uploaded from devices.
However, There is no log contains all of sysUptime, version, hostname..
So FAZ feature cannot generate data you want.

For the future, if you want to as about FortiAnalyzer feature, fortianalyzer tag is better than FortiManager tag.