I'm working on a SWQL custom query for a widget that will show me all our applications in a "down-ish" mode. It works great, except I can't get the StatusLED to display for the application. Any ideas as to what the key might be to fixing this?
SELECT ACP.Application.StatusDescription, ACP.Application.Name as ApplicationName, Ticket, ACP.Application.Node.Caption as Node, 'https://orion.uwsp.edu/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:' + ToString(ACP.Application.NodeID) as [_LinkFor_Node],'/Orion/images/StatusIcons/Small-' + ACP.Application.node.StatusLED AS [_IconFor_Node], 'https://orion.uwsp.edu/Orion/NetPerfMon/NodeDetails.aspx?NetObject=AA:' + ToString(ACP.Application.ApplicationID) as [_LinkFor_ApplicationName], '/Orion/images/StatusIcons/Small-' + ACP.Application.StatusLED AS [_IconFor_ApplicationName]
FROM Orion.APM.ApplicationCustomProperties ACP
Where ACP.Application.Status <> 1 and ACP.Application.Status <> 9 AND ACP.Application.Status <> 12 and ACP.Application.Status <> 14
Order by ACP.Application.Node.Nodename, ACP.Application.name
