how add vendor icon to my SWQL result?

hi,

how do i do add vendor specific icon to my SWQL results?

i saw this good video but i do not know is it still work on orion 2024.1.0 or not?
this is my code


SELECT 
     [node].MachineType
    ,[node].caption
    ,[node].Status
    ,'/NetPerfMon/Images/Vendors/' + [node].VendorIcon AS [_iconfor_machinetype]
FROM Orion.Nodes AS [node]
WHERE [node].Status != 1 
AND (
        ( [node].MachineType LIKE 'VMware ESX Server') OR
        ( [node].MachineType LIKE 'Integrated-Lights-Out')
    )

Find more posts tagged with

swql query

npm

icon

Accepted answers

bobmarley

I'm using a Custom Query Widget instead of a Table Widget

HerrDoktor

Modern dashboards work differently with the formatting.

here's the query:

SELECT n.Caption AS [Node Name]
, n.Status
, n.StatusDescription AS [Status Description]
, n.DetailsURL AS [Node Details URL]
, n.MachineType AS [Vendor Name]
, n.VendorInfo.Icon AS [System Vendor Icon]
, n.CPULoad AS [CPULoad]
, n.ResponseTime AS [Response Time]
, n.PercentMemoryUsed AS [Memory Usge]
, n.PercentLoss AS [Packet Loss]
FROM Orion.Nodes n
WHERE n.Status = 1

AND (
( n.MachineType LIKE 'VMware ESX Server') OR
( n.MachineType LIKE 'Integrated-Lights-Out')
)

you then format the different columns:

All comments

soheilamiri

in query result only path of icon are shown

bobmarley

SELECT 
     [node].MachineType
    ,'/NetPerfMon/Images/Vendors/' + [node].VendorIcon AS [_iconfor_machinetype]
    ,[node].caption
    ,[node].Status

FROM Orion.Nodes AS [node]
WHERE [node].Status != 1

soheilamiri

still the same issue

Jfrazier

Can you use an html img src tag to convert the path/filename to html and let the system process that in the output?

Just an idea.

bobmarley

I'm using a Custom Query Widget instead of a Table Widget

soheilamiri

so it works on classic dashboard.

thanks

cnorborg

Yes, I think the _IconFor only works in "Custom Query" or similar things. When trying to do something like this on a new dashboard, I find it easier to use the query builder, then under your "MachineType" in "Advanced" you'd need to choose a DIsplay Setting of "Vendor Icon (Watermark)" and it might complain about you needing that field in your query. When you add it, you can then hide it so it doesn't display the "9.gif" or something. Using this method there is no need to specify the path...

HerrDoktor

Modern dashboards work differently with the formatting.

here's the query:

SELECT n.Caption AS [Node Name]
, n.Status
, n.StatusDescription AS [Status Description]
, n.DetailsURL AS [Node Details URL]
, n.MachineType AS [Vendor Name]
, n.VendorInfo.Icon AS [System Vendor Icon]
, n.CPULoad AS [CPULoad]
, n.ResponseTime AS [Response Time]
, n.PercentMemoryUsed AS [Memory Usge]
, n.PercentLoss AS [Packet Loss]
FROM Orion.Nodes n
WHERE n.Status = 1

AND (
( n.MachineType LIKE 'VMware ESX Server') OR
( n.MachineType LIKE 'Integrated-Lights-Out')
)

you then format the different columns:

soheilamiri

it works with modern dashboard.

soheilamiri

there are very little resource about modern dashboard customization in the web.

if any would you please share the links?

HerrDoktor

An Adventure Into Modern Dashboarding: Introduction to SWQL Studio

Modern Dashboards

https://github.com/the-ben-keen?tab=repositories

from my experience, I was learning it best by tinkering around with it. i am not using the „Object Picker“ but build my queries in SWQL Studio first, then use the „Hand edit“ option and format to my needs.

soheilamiri

nice job @HerrDoktor
i love your mindset