Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
kcanalichio
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)

2 REPLIES 2
kcanalichio
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

kcanalichio

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

Labels
Top Kudoed Authors