I need to make a Custom Dashboard to show total nodes count with Up and Down status. The dashboard should be like this: Also I only need the UP and Down Status and Icon, so there's no need for other status (Warning, Unknown, etc.). Thanks for any help!

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

Total Nodes Count Status

febriady.dgpratama

I need to make a Custom Dashboard to show total nodes count with Up and Down status.

The dashboard should be like this:

SWD Custom Dashboard 2a.jpg

Also I only need the UP and Down Status and Icon, so there's no need for other status (Warning, Unknown, etc.).

Thanks for any help!

Find more posts tagged with

Accepted answers

All comments

ejtc1488

I think this would best achieve on a scripting basis, as I have heard of a similar scenario where they are using Custom property but could not separate the a column for both Down and Up Status of the nodes

ejtc1488

You could try this SQL script

SELECT

concat('Of Defense - ',count(*),' Nodes') as [Department]

,sum(case when n.Status =1 then 1 else 0 end) AS [Up]

,sum(case when n.Status=2 then 1 else 0 end) AS [Down]

FROM Nodes n