Convert systemuptime for Advance alert

Chandru

Hi,

Is there a possibility that i could convery systemuptime for devices to a more readable format value

${SQL:Select round((Inbps / 1024 / 1024),3) from interfaces WHERE FullName='${FullName}'} MBps${CrLf}

I use the above for converting Inbps to mbps which works fine

I think there should be a same way for converting the systemuptime to be sent in advance alert for weeks, days, hours & minutes

 

regards

Chandru

tdanner

I think something like this would work:

${SQL:SELECT convert(varchar, floor(Systemuptime/3600)) + ' hours, ' +
convert(varchar, (convert(int,Systemuptime)%3600)/60) + ' minutes, ' +
convert(varchar, convert(int,Systemuptime)%60) + ' seconds'
 FROM Nodes WHERE NodeID=${NodeID} }