Custom Widget Showing Boot Times in Group View

I am looking for a way to show a list of Nodes in a specific group and their LastBootTime. I found this link (https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/93863/custom-widget-for-default-group-view) regarding showing interfaces, but I am struggling to modify it to show the Node Name and Last Boot Time. Could anyone point me in the right direction?

Thanks!

Find more posts tagged with

lastboottime

custom query resource

groups

Accepted answers

All comments

stuartd

I can't even get that query in the linked page to run in SWQL Studio (nor a widget) s0 it's possible the backend has changed structure. In the meantime can you share what code you have done so far?

And secondly I'll tag in Marlie @marlief22 to see if she's around to assist.

marlief22

Hi there,

Thanks for the tag @stuartdc - first off, the old query has to be ran on a group details page which is probably why you didn't get anything displayed before.

Second off, here is a quick change around to make this work for nodes and then for the caption and last boot time:

select n.caption as [Node],  n.LastBoot from orion.Nodes n
where n.NodeID in (SELECT MemberPrimaryID
FROM Orion.ContainerMembers
where containerid = ${ID})
order by n.LastBoot DESC

Let me know if you have any questions.

Kind regards,

Marlie

bharris1

How would I add a column that would include "Last Boot Time" that is getting polled via ESX polling. This might be coming from the hardware table.

marlief22

Hi there,

Sorry, can you confirm that you want it to display the last boot time or, in the picture above, the last poll time of the hardware details? You've mentioned for an ESX box but the picture above is a Cisco machine so I'm a little confused.

Thanks, Marlie

bharris1

I'm sorry, I grabbed the wrong screenshot. This is the host boot time shown on the ESX Host resource.