Custom Table Resource Grouping Data with Expansion(+) Option Based On Site

kevin.adams

Hi  Guys

I have created a custom table resource to display node reboots for a period of 7 days...I am just wondering due to limited space on the Dashboard is their a way to add an expansion option on the Grouping of sites , as you can see below I have the one site that has a node that reboot a few times this week...It would be great if one can have an expansion option on the site name this will help with the space constraint on the display

mesverrum

All those dynamic/interactive resources are basically javascript.  You can use js to query the information service and build anything you can dream up, but to date I haven't seen anyone in the community really demonstrate any strong skill in doing those kind of resources. Just not that many web devs in here I guess.

Since I'm garbage in js but strong in SWQL the way I would get around this request myself would be to use a custom query resource where the first box was a count of the number of nodes that had rebooted, and a count of the number of times they rebooted, then for the "search" box I would do a different query that actually listed out each individual reboot event, and filter it where sitename like '%${SEARCH_STRING}%'

Something like

Box1

SELECT e.Nodes.CustomProperties.Site_Name, count(Message) as [Reboots]

FROM Orion.Events e

where e.EventTypeProperties.Name = 'Node Rebooted'

and daydiff(eventtime,GETUTCDATE())<7

group by e.Nodes.CustomProperties.site_name

Box2

SELECT e.Nodes.CustomProperties.Site_Name, Message as [Reboots]

FROM Orion.Events e

where e.EventTypeProperties.Name = 'Node Rebooted'

and daydiff(eventtime,GETUTCDATE())<7

and e.Nodes.CustomProperties.Site_Name like '%${SEARCH_STRING}%'

-Marc Netterfield

    Loop1 Systems: SolarWinds Training and Professional Services

•                 LinkedIN: Loop1 Systems
•                 Facebook: Loop1 Systems
•                 Twitter: @Loop1Systems