This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom Node Health widget

ioan_bucsa over 3 years ago

A while ago I came across this page W3Schools How TO - Code snippets for HTML, CSS and JavaScript and it gave me quite a few ideas on how I could improve our customer's overall Orion experience.

So I set out to create a custom Node Health widget that shows a few useful metrics right on the device summary page and came up with this:

And this is the view for a node that is down:

Or unmanaged:

The tiles also change colors based on thresholds (I hard coded the default Orion thresholds, but with a little bit of effort you can add in dynamic thresholds based on custom properties for example): green is normal, yellow for warning and red for critical.

Code is below.

I recommend the W3 Schools How to collection to anyone learning HTML/CSS or who already has a firm grasp of web design or if you are simply searching for inspiration.

A few useful resouces:

W3Schools How TO - Code snippets for HTML, CSS and JavaScript

Parents

0 rfroembgen over 3 years ago

Hi all,
i had the same issue.
Seems like if you copy it out of the file ioan_bucsa provided, it does something weird with the newlines in the swql statement.
Just edit the file and set the
var swql = "SELECT REPLACE(n.StatusIcon,'.gif','') as Status, CASE REPLACE(n.StatusIcon,'.gif','') WHEN 'Down' THEN CONCAT(FLOOR((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0)/24),' d ', FLOOR(round((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0),1) - FLOOR((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0)/24)*24), ' h ', FLOOR((round((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0),1) - FLOOR((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0)))*60), ' m') WHEN 'Unmanaged' THEN CONCAT(FLOOR((minutediff(n.UnManageFrom,getutcdate())/60.0)/24),' d ', FLOOR(round((minutediff(n.UnManageFrom,getutcdate())/60.0),1) - FLOOR((minutediff(n.UnManageFrom,getutcdate())/60.0)/24)*24), ' h ', FLOOR((round((minutediff(n.UnManageFrom,getutcdate())/60.0),1) - FLOOR((minutediff(n.UnManageFrom,getutcdate())/60.0)))*60), ' m') ELSE '0' END AS Since, n.ResponseTimeHistory.AvgResponseTime as ResponseTime, n.ResponseTimeHistory.PercentLoss as PacketLoss,n.PercentMemoryUsed as Memory, n.CPULoad as CPU FROM Orion.Nodes n WHERE n.ResponseTimeHistory.DateTime = (SELECT Max(Datetime) as Maxdate FROM Orion.ResponseTime WHERE NodeId= ${NodeId}) AND n.NodeId= ${NodeId} "
in one single line.
That just fixed it for me.
ioan_bucsa Awesome work on that widget!
Best Regards
Rene
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 rfroembgen over 3 years ago

Hi all,
i had the same issue.
Seems like if you copy it out of the file ioan_bucsa provided, it does something weird with the newlines in the swql statement.
Just edit the file and set the
var swql = "SELECT REPLACE(n.StatusIcon,'.gif','') as Status, CASE REPLACE(n.StatusIcon,'.gif','') WHEN 'Down' THEN CONCAT(FLOOR((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0)/24),' d ', FLOOR(round((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0),1) - FLOOR((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0)/24)*24), ' h ', FLOOR((round((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0),1) - FLOOR((minutediff(n.LASTSYSTEMUPTIMEPOLLUTC,getutcdate())/60.0)))*60), ' m') WHEN 'Unmanaged' THEN CONCAT(FLOOR((minutediff(n.UnManageFrom,getutcdate())/60.0)/24),' d ', FLOOR(round((minutediff(n.UnManageFrom,getutcdate())/60.0),1) - FLOOR((minutediff(n.UnManageFrom,getutcdate())/60.0)/24)*24), ' h ', FLOOR((round((minutediff(n.UnManageFrom,getutcdate())/60.0),1) - FLOOR((minutediff(n.UnManageFrom,getutcdate())/60.0)))*60), ' m') ELSE '0' END AS Since, n.ResponseTimeHistory.AvgResponseTime as ResponseTime, n.ResponseTimeHistory.PercentLoss as PacketLoss,n.PercentMemoryUsed as Memory, n.CPULoad as CPU FROM Orion.Nodes n WHERE n.ResponseTimeHistory.DateTime = (SELECT Max(Datetime) as Maxdate FROM Orion.ResponseTime WHERE NodeId= ${NodeId}) AND n.NodeId= ${NodeId} "
in one single line.
That just fixed it for me.
ioan_bucsa Awesome work on that widget!
Best Regards
Rene
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data