Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
New Contributor III

Creating a report that uses contstants.

What is the correct syntax to  Include the following formula in a report


86400-SUM(System Downtime)

New Contributor III

In a report I want to have a return a field that uses a constant of 86400 and subtract the amount of system downtime. The Ultimate goal here is to have a column that shows total uptime over the last 24 hours(or period the the report is run for). Since Uptime in the PH_DEV_MON_SYSTEM_UPTIME is uptime since the machine was rebooted.

In most reporting software it would look something like this

86400-SUM(System Downtime)

This syntax is not allowed in the fortisiem, so what is the correct syntax?

I'm using the report 'Top Devices by Accumulated System Downtime' as the base for adding this new column


was able to get what I needed by doing this

(86400 + SUM(System Downtime) - SUM(System Downtime) ) - SUM(System Downtime))

why this works and why

(86400 - SUM(System Downtime) )

doesn't  is something a developer will need to look at


Select Forum Responses to become Knowledge Articles!

Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

Top Kudoed Authors