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

color change - Modern Dashboard

How to color change dashboard modern solarwinds ??`

SELECT distinct aa.StatusDescription AS Status, COUNT(Status) AS Total FROM Orion.APM.Application as aa INNER JOIN Orion.ContainerMemberSnapshots cm on cm.FullName=aa.Node.Caption INNER JOIN Orion.Groups g on cm.ContainerID=g.ContainerID where aa.Template.Name like '%skype%' Group By aa.StatusDescription

Find more posts tagged with

solarwinds

SWQL

Modern Dashboard

Accepted answers

All comments

jm_sysadmin

Here is an example of how I added colors to a Windows OS pie chart. First I added a case statement to my SWQL for the colors I wanted.

Case 
   When ServerList.OS like 'Windows 2008 Server' Then 'Red'
   When ServerList.OS like 'Windows 2008 R2 Server' Then 'Red'
   When ServerList.OS like 'Windows 2012 Server' Then 'Red'
   When ServerList.OS like 'Windows 2012 R2 Server' Then 'Red'
   When ServerList.OS like 'Windows 2016 Server' Then 'Orange'
   When ServerList.OS like 'Windows 2019 Server' Then 'Green'
   When ServerList.OS like 'Windows 2022 Server' Then 'Green'
End as [Color],

Then I went back to the chart option and set the Color mapping.

mosikhan

I know that <case> should be used. According to the query I have written. For example, I want the output to turn green if I see (up) or red if I see (critical).

mosikhan

distinct NOt Working...

christopher.t.jones123

@mosikhan, try this query. Because you are trying to do a status you can just use the colors from the built-in StatusInfo table. Also your distinct not working statement is pretty vague, what are you seeing and what are your goals that lead to your statement?

SELECT distinct 
aa.StatusDescription AS Status
, COUNT(Status) AS Total
, SI.Color
FROM Orion.APM.Application as aa 
INNER JOIN Orion.StatusInfo SI on SI.StatusId=aa.Status
INNER JOIN Orion.ContainerMemberSnapshots cm on cm.FullName=aa.Node.Caption 
INNER JOIN Orion.Groups g on cm.ContainerID=g.ContainerID 
where aa.Template.Name like '%Skype%' 
Group By aa.StatusDescription