Solarwinds - Node uptime report as percentage

CiscoExpert1

Hello I am using the below for creating a report of node uptime but I need ths as percentage - what config needs amending to give me as percentage?

SELECT

      NodeID

      ,Caption

      ,VendorIcon

      ,Ip_Address

      ,DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp

      ,CONVERT(VARCHAR(40), DATEDIFF(minute, Nodes.LastBoot, GETDATE())/(24*60))

            + ' days, '

            + CONVERT(VARCHAR(40), DATEDIFF(minute, Nodes.LastBoot, GETDATE())%(24*60)/60)

   + ' hours, and '

   + CONVERT(VARCHAR(40), DATEDIFF(minute, Nodes.LastBoot, GETDATE())%60)

   + ' minutes.' AS 'Time Up'

FROM [Nodes]

ORDER BY 5 DESC

taylor.crowley

Hi CiscoExpert1, would this be the sort of thing you're looking for? https://documentation.solarwinds.com/en/success_center/npm/content/onboarding/custom_alert_report/npm_ob_create_custom_report.htm

It seems to me that you mean the availability of the node