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

Modern Dashboard KPI Count Widget

Prineel

Hi there, need assistance please, looking to create KPI count widgets by Machine Type.

i.e. Count of vCenters, LUN's, etc as per image below.

I've tried the following in SWQL Studio which returns the count but widget is blank, not sure what the issue is.

Thanks

Find more posts tagged with

Widgets

kpi

Modern Dashboards

Accepted answers

christopher.t.jones123

@Prineel, you can use the below query

SELECT Count(*) as [Node Count]
from Orion.nodes
where MachineType = 'VMware vCenter Server'

All comments

christopher.t.jones123

@Prineel, have you tried making the count the first selection, I believe by default the KPI widget only brings in the first column and first row value.

Prineel

Hi Christopher, thanks for your response, sorry not exactly sure how to do that...

christopher.t.jones123

@Prineel, you can use the below query

SELECT Count(*) as [Node Count]
from Orion.nodes
where MachineType = 'VMware vCenter Server'

Prineel

@christopher.t.jones123 works great thanks!