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

Showing Icons with SWQL Query

Good afternoon THWACK Community,

I apologize if this is an old topic but I have a question about adding Icons with the SWQL Query. I am using the following to get the vendor Icon to show with the node name. I am also attempting to get the status Icon of the node to appear as well but when I try to get both Icons I will either get no Icons or an error message. The question is Is it possible to get the Vendor Icon and the Node Status Icon to appear with the Node Name? My latest try is below

SELECT top 100 

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 

FROM Orion.Nodes N

Find more posts tagged with

swql query

Accepted answers

k1gaudineer

Ahhhh Yes..... There is the rub using the custom table doesn't give you the ability to use a paged display and with 4000 + devices we need pages. So went back to the ' ' AS [Status] idea again. This time what I did was I removed the word 'Status' and just left a blank space between the [ ] and then when I added this line 'CONCAT('/Orion/images/StatusIcons/Small-', N.StatusLED) AS [_IconFor_ ]' I also added one space at the end of _IconFor_ . Then end result was a display like the following:

The customer is happy because their requirements are met. They get node status, Vendor Icon, Node name, Interface Status, Interface type, IP address and IP Subnet mask. The good news is that I still have a little bit of realestate left and I can add response time or other metric of their choosing to make this display more meaningful for them.

Thank you to the THWACK community members for all of your input and ideas this has been fun and very educational for me. We have a large mix of equipment (Aruba, TrippLite, Cisco, Brocade, Synaptics) and its important for the customer to be aware of interface and devices status. If you are interested I have added my full SWQL query below......

SELECT
'' AS [ ],
CONCAT(' ', N.Caption) AS [Node], -- Adding spaces as separators
CONCAT(' ', ISNULL(I.Caption, '-- Interface not monitored --')) AS [Interface],
CASE
WHEN I.StatusIcon IS NULL OR I.StatusIcon = '' THEN '/Orion/images/StatusIcons/Small-Unknown.gif'
ELSE CONCAT('/Orion/images/StatusIcons/Small-', I.StatusIcon)
END AS [_IconFor_Interface], -- Adding Icon for Interface with fallback to Unknown.gif
CASE
WHEN ISNULL(IP.IPAddress, N.IPAddress) = N.IPAddress THEN CONCAT(ISNULL(IP.IPAddress, N.IPAddress), ' *')
ELSE ISNULL(IP.IPAddress, N.IPAddress)
END AS [IPAddress],
ISNULL(IP.Subnetmask, '-- No Subnetmask --') AS [Mask],
N.DetailsUrl AS [_LinkFor_Node],
I.DetailsUrl AS [_LinkFor_Interface],
I.StatusIcon AS [_LinkFor_Status],
CONCAT('/NetPerfMon/Images/Vendors/', N.Icon) AS [_IconFor_Node], -- Vendor Icon
CONCAT('/Orion/images/StatusIcons/Small-', N.StatusLED) AS [_IconFor_ ]

FROM
Orion.Nodes N
LEFT OUTER JOIN
Orion.NodeIPAddresses IP ON N.NodeID = IP.NodeID
LEFT OUTER JOIN
Orion.NPM.Interfaces I ON N.NodeID = I.NodeID AND IP.InterfaceIndex = I.InterfaceIndex

WHERE N.Category = 1
-- When setting search use the WHERE Clause Below and comment out the one above
-- WHERE N.Category = 1 AND (IP.IPAddress LIKE '%${SEARCH_STRING}%' OR i.caption LIKE '%${SEARCH_STRING}%' OR N.Caption LIKE '%${SEARCH_STRING}%')

ORDER BY
N.Caption, I.Caption

All comments

stuartd

How are you looking to do/present this?

Presenting icons won't work in a SWQL query directly within SWQL studio, but it should work when in a report or a modern dashboard for example.

k1gaudineer

I realize that the Icon won't display in the editor (SWQL Studio) only the path to the icon will show there. This isn't for presenting in the SWQL Studio because my customer doesn't use the editor. This is for presenting in a widget. The above code is just a short snippet from the actual query however its enough to show what I'm looking for. What I would like to see presented in the widget is Icon for the Status (Green or Red) --> the Icon for the vendor ---- Then the node Name. Right Now I've only been successful with showing the Vendor or Showing the status but haven't been able to get both to show together.

adam.beedell

What you're trying to do is doable for sure

Your code implies a classic dashboard, this is a rare space that's probably easier on a modern

In that particular snippet I think you'd need to also return a status column, also _IconFor doesnt have anything to apply to

stuartd

We don't use the combination you seek, but take a look at this example Overall Node Status Dashboard provided by Ben Keen. That definitely uses status and vendor icons in an MD setting.

OK - so he hasn't used a traditional column called status, but the node name itself is showing the status. It would be trivial to add a pure status column in.

k1gaudineer

I've seen that MD before but that not what I'm after. Sure if there was only one Microsoft Server or the Icon was used for more than 1 vendor it might be a good idea to have a separate column for 'System Vendor'. But the Icons are unique and to have a column for system vendor is a waste of screen realestate. When you have hundreds of Microsoft servers you don't need a column for 'System Vendor' showing you the icon is related to Microsoft Server hundreds of times. What I'm looking to do is add the Status Icon + Vendor Icon before the Caption or (System Name) then have any other column(s) of meaningful information after that. I guess what I'm after is to do something like:

SELECT

CONCAT(' ', N.Caption) AS [Node], -- Use CONCAT to Add spaces before Node Name for Icon spacing 
CONCAT('/Orion/images/StatusIcons/Small-', N.StatusLED) AS [_IconFor_Node], + -- Status Icon
CONCAT('/NetPerfMon/Images/Vendors/', N.Icon) AS [_IconFor_Node] -- Vendor Icon 

FROM Orion.Nodes N

I would like the widget to have a look like the one below:

But it looks like the _IconFor_{Alias} can only be anchored to one alias. That display is what the customer wants its clear, concise, visually pleasing and doesn't waste a lot of screen realestate