I've updated the solarwinds installation to 2020.5 and my network availabilty KPI is changed to an unreadable decimal format. I have this SWQL query:
select avg(orion_responseTime_availability_avg) as Net_Avail
from (
SELECT TOP 2000 aggSub._avg AS Orion_ResponseTime_Availability_avg
FROM Orion.Nodes n
LEFT JOIN ( select i.nodeid, avg(i.availability) as _Avg from orion.ResponseTime i
WHERE (i.DateTime > ADDDATE('day', -15, GETUTCDATE()))
group by i.NodeID ) aggsub ON aggsub.nodeid=n.NodeID )
But the output is 99.91355529115035
I like to have it at
99.91%
