SWQL Queries for widgets

I am attempting to make a widget to display a down situation for some of our nodes. This needs to be separate from the Down Nodes widget. I have the below SWQL query which works fine, but I would like for the widget to show the status icons and I am not sure how to get that to work.

SELECT IPAddress, Caption, Status FROM Orion.Nodes Where Caption LIKE '%imbox%' and Status LIKE '2'

Find more posts tagged with

Accepted answers

All comments

TerryHarding

Expand the Properties and formatting section for the column where you want to display the status icon and select Status for Icon

gadbekr

I am not sure what you mean by "expand the properties and formatting section".

TerryHarding

Sorry - didn't ask what type of Dashboard - Modern Dashboard or Classic? If it's a modern dashboard Widget properties as above.

If it's a Custom Query in a Classic dashboard:

SELECT

CONCAT(' ', N.Caption) AS [Node], -- Use CONCAT to Add spaces before Node Name for Icon spacing

CONCAT('/NetPerfMon/Images/Vendors/', N.Icon) AS [_IconFor_Node], -- Vendor Icon

CONCAT('/Orion/images/StatusIcons/Small-', N.StatusLED) AS [_IconFor_Status], -- Status Icon

n.IP_Address,

n.Status

FROM Orion.Nodes N

WHERE n.Caption LIKE '%imbox% AND n.Status LIKE '2'