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

How to add Watermark for a SWQL query on Custom Table

Can some one help me whit a SWQL query for Custom table

I need the status icon for the Custom poller to show up

I have make a SWQL

SELECT cp.UniqueName, cpsn.Status, TOSTRING(HOUR(TOLOCAL(DateTime))) + ':' + TOSTRING(MINUTE(DateTime)) AS [Last Poll Time]

FROM Orion.NPM.CustomPollers cp

JOIN Orion.NPM.CustomPollerStatusOnNodeScalar cpsn

ON cp.CustomPollerID = cpsn.CustomPollerID

WHERE NodeID = ${NodeID} AND (cp.UniqueName <> 'BatteryDays') AND (cp.UniqueName <> 'batteryVoltageValue') AND (cp.UniqueName <> 'loadCurrentValue') AND (cp.UniqueName <> 'batteryCurrentsValue') AND (cp.UniqueName <> 'rectifiersCurrentValue') AND (cp.UniqueName <> 'batteryCurrentValue') AND (cp.UniqueName <> 'BatteryHours') AND (cp.UniqueName <> 'batteryTemperatures') AND (cp.UniqueName <> 'batteryTime') AND (cp.UniqueName <> 'BatteryVoltage') AND (cp.UniqueName <> 'EltekcontrolUnitSwPartNr') AND (cp.UniqueName <> 'EltekcontrolUnitSwVersion') AND (cp.UniqueName <> 'LoadCurrentsValue') AND (cp.UniqueName <> 'RectifiersCurrent') AND (cp.UniqueName <> 'BatteryHours48V') AND (cp.UniqueName <> 'BatteryHours110V') AND (cp.UniqueName <> 'DoorOpen') AND (cp.UniqueName <> 'DirtyFilter') AND (cp.UniqueName <> 'MCBsF17F20') AND (cp.UniqueName <> 'MissingFilter') AND (cp.UniqueName <> 'SmokeDetector')

GROUP BY cp.UniqueName, cpsn.Status, DateTime

And getting this result

But it had been nice to get the Status LED icon for the Custom poller to show up, Any suggestions on how to fix this?

Find more posts tagged with

SWQL

npm

custom table

custom poller

Accepted answers

Seashore

I Think you are correct there.If you want icons in reports, or custom tables you can use one of two methods:

A complete html tag for the image and enable html code in the cell:

Or have a link to the icon and say that the column is an icon:

All comments

jm_sysadmin

I can't test it since I don't have your custom poller but I would try the Case statement I added below.
When you name a column [_IconFor_OtherColumnName] the icon you set will be the image added before that column's data. If you want a dedicated column, you can just add it to an empty result like ''

SELECT 
cp.UniqueName
, cpsn.Status
, Case 
    When cpsn.Status like 'normal' Then '/Orion/images/StatusIcons/small-up.gif' 
Else '/Orion/images/StatusIcons/small-down.gif'
End as AS [_IconFor_UniqueName]
, TOSTRING(HOUR(TOLOCAL(DateTime))) + ':' + TOSTRING(MINUTE(DateTime)) AS [Last Poll Time]

FROM Orion.NPM.CustomPollers cp

JOIN Orion.NPM.CustomPollerStatusOnNodeScalar cpsn

ON cp.CustomPollerID = cpsn.CustomPollerID

WHERE NodeID = ${NodeID} AND (cp.UniqueName <> 'BatteryDays') AND (cp.UniqueName <> 'batteryVoltageValue') AND (cp.UniqueName <> 'loadCurrentValue') AND (cp.UniqueName <> 'batteryCurrentsValue') AND (cp.UniqueName <> 'rectifiersCurrentValue') AND (cp.UniqueName <> 'batteryCurrentValue') AND (cp.UniqueName <> 'BatteryHours') AND (cp.UniqueName <> 'batteryTemperatures') AND (cp.UniqueName <> 'batteryTime') AND (cp.UniqueName <> 'BatteryVoltage') AND (cp.UniqueName <> 'EltekcontrolUnitSwPartNr') AND (cp.UniqueName <> 'EltekcontrolUnitSwVersion') AND (cp.UniqueName <> 'LoadCurrentsValue') AND (cp.UniqueName <> 'RectifiersCurrent') AND (cp.UniqueName <> 'BatteryHours48V') AND (cp.UniqueName <> 'BatteryHours110V') AND (cp.UniqueName <> 'DoorOpen') AND (cp.UniqueName <> 'DirtyFilter') AND (cp.UniqueName <> 'MCBsF17F20') AND (cp.UniqueName <> 'MissingFilter') AND (cp.UniqueName <> 'SmokeDetector')

GROUP BY cp.UniqueName, cpsn.Status, DateTime

Mrchasmann

Hmm, just getting * Query is not valid

chad.every

On line 7 there is a duplicate 'as'. try removing that

Mrchasmann

That works but i dont getting the status icon. Just the text. i have activated the "Allow HTML tag" but i just getting the same result