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

ICON Mapping issue on Widget

bjvariya

Dear Thwack

I have created a query and its result as follows, but unable to get icon on widget it seems only pink square.

Find more posts tagged with

Accepted answers

All comments

dodo123

Can you share the swql

bjvariya

SELECT Count(NodeID) as totalNodes , Vendor, VendorIcon as VIcon
FROM NCM.Nodes
where SNMPLevel >0
GROUP BY Vendor, VendorIcon
order by TotalNodes

jm_sysadmin

What you did seems right, and I can't get it to work in the proportional widget, but I can get it to work other places like tables. I also looked at it in other examples, they are using the same field. (examples I used from the article below)

All in on Modern Dashboards - Newsroom - Hybrid Cloud Observability - THWACK (solarwinds.com)

It looks the same if you pull the data out of Orion.Nodes as well.

If nobody has gotten it to work it might be broken.

bjvariya

Yeah.. correct.. but if we write an SWQL for node status, then we are able to get status icon,, however, i have searched for the path.. mutilple path found for status icon..but not found correct icon for status_up (which seems green tick)

SWQL

SELECT COUNT(1) as value, Status,
CASE WHEN Status = 1 THEN '9' WHEN Status =14 THEN 'status_down' WHEN Status =3 THEN 'status_warning' ELSE 'status_unknown' END as icon,
CASE WHEN Status = 1 THEN 'green' WHEN Status =14 THEN 'red' WHEN Status = 3 THEN 'yellow' ELSE 'gray'
END as color
FROM Orion.Nodes GROUP BY status ORDER BY value DESC

So it works for status only... i think so...

KMSigma.SWI

I don't have a server handy at the moment, but what happens if you bring it in using the VendorInfo entity?

SELECT COUNT(NodeID) AS [TotalNodes]
     , [Nodes].VendorInfo.Name AS [Vendor]
     . [Nodes[.VendorInfo.Icon AS [VIcon]
FROM NCM.Nodes AS [NCM]
JOIN Orion.Nodes AS [Nodes]
   ON [NCM].CoreNodeID = [Nodes}.NodeID
WHERE [NCM].SNMPLevel > 0
GROUP BY [Nodes].VendorInfo.Name
       , [Nodes[.VendorInfo.Icon
ORDER BY COUNT(NodeID)

^ Making best guesses from memory as to the names of the entities and properties.