The following SWQL code:
SELECT n.caption as Node, '/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node], n.ipaddress as IP_Address, n.ObjectSubType as Polling_Method, n.StatusDescription as Status, '/Orion/images/StatusIcons/Small-' + i.StatusLED AS [_IconFor_Interface], I.Caption as Interface FROM Orion.NPM.Interfaces I left join orion.nodes n on n.nodeid=I.nodeid
Can I make it look like:
I've tried grouping by node name, but cant seem to make it work.
As a value add, I'd like to have volumes added under the interfaces for nodes that have them.