Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How do I show the red or green LED icon for a node in a custom web report?

I am creating a web report that lists current open alerts on servers but I cannot get the Status to show as the green or red icon. Instead, it just shows the text "up.gif" or "down.gif".

What am I doing wrong?

Here is the code I am using:

SELECT

Nodes.Caption,

'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(Nodes.NodeID as varchar(256)) AS 'DetailsURL',

Nodes.StatusLED AS Status_Icon,

AlertDefinitions.AlertName,

AlertStatus.TriggerTimestamp

FROM

(alertdefinitions INNER Join alertstatus on (alertdefinitions.alertdefid = AlertStatus.AlertDefID) INNER JOIN Nodes on (AlertStatus.ActiveObject = Nodes.Nodeid))

WHERE

AlertDefinitions.ObjectType = 'Node'

Find more posts tagged with

Accepted answers

All comments

HolyGuacamole

Don't know if there is an easier way but if you modify your query as below, it works

SELECT

Nodes.Caption,

'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(Nodes.NodeID as varchar(256)) AS 'DetailsURL',

'<img src=/Orion/images/StatusIcons/'+ CAST(Nodes.StatusLED AS varchar(256)) + '/>' AS 'Status',

....

and for the column formatting, check the box 'Allow HTML tags'

devin.dao

make sure in the Orion Report Writer under Field Formatting you have StatusLED format as Icon.