Hello,
The following SWQL code:
SELECTn.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 InterfaceFROM Orion.NPM.Interfaces Ileft join orion.nodes n on n.nodeid=I.nodeid
produces
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.
Thanks
Stuart
