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

Modern Dashboard SWQL Help

I have a modern dashboard setup to monitor the status of our diesel generators, when these are idle and not running the custom property shows the value of 0 and this is what gets displayed on the dashboard, ideally I would like this value to say either idle or running based on the custom property value.

I am currently using this swql statement below and the reported vales are 0 & Idle

select max(0+nodes.custompollerassignmentonnode.currentvalue) as Value,
case when nodes.custompollerassignmentonnode.currentvalue = 0 then 'Idle' else 'Running' end as Status
from orion.nodes
where nodeid = '1352' and nodes.custompollerassignmentonnode.custompollername like '%EngineSpeed'
group by nodes.custompollerassignmentonnode.currentvalue

Value	Status
0	Idle

I would like the dashboard to show the text rather than the numeric value, can someone please advise if this is possible and how I can achieve this?

Find more posts tagged with

SWQL

orion sdk

Accepted answers

All comments

dodo123

I think you may be limited to using numbers in the KPI widget on modern dashboard I assume your query works as expected in the SWQL Studio, may need to be a feature request or use the table widget but obviously wont look as nice.

dunky2k

Okay I managed to tweak the swql so that it now displays text rather than the value, however seeing as the output is now text and not a numerical value I can no longer use the warnings to change the colour of the widget when needed.

select case when nodes.custompollerassignmentonnode.currentvalue > 0 then 'Running'
else 'Idle' end as Value
from orion.nodes
where nodeid = '1352' and nodes.custompollerassignmentonnode.custompollername like '%EngineSpeed'

So need to think what is better, numerical value with warnings enabled or text to actually say Idle or Running.. hmm need to have a vote on that one internally.

TinyElvis

What about separate values: "# of Running" "# of Idle"