This started because I wanted to have multiple columns of nodes and their status in a NOC view. No such luck finding that as a built-in widget just yet.
So, I have a fairly simple SWQL query:
SELECT Caption as Server, '/Orion/images/StatusIcons/Small-' + StatusLED AS [_IconFor_Server]
FROM Orion.Nodes
WHERE Vendor = 'A OR Vendor = 'B' OR Vendor = 'C'
ORDER BY Caption
This works just fine however the monitor we're using won't display more than 17 rows before one needs to scroll to see the rest of the nodes. That kind of defeats the purpose of the wallboard. I was able to get the information trimmed down to the correct count by appending:
WITH ROWS 1 TO 17
to the end of the query. This works in SWQL Studio, but bombs out in the widget and just returns 'There was an error processing the request.'
Anyone have any pointers?
