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

how to count total server on APM

zazaz

hai, i'm new on APM Solarwinds

i have 1 silly question actually : how to count total server, and how to count how many server are up?

ex :

group - Building C : 18/20 --> means 18 are up from 20 servers on that location

group - 17th floor : 44/44 --> means that all servers are up

thanks

Find more posts tagged with

Accepted answers

All comments

FormerMember

Try this query.

You might have to change the fields depending on your field names:

select isnull(a.bldg, b.bldg), isnull(TotalServers, 0) as 'UpServers', isnull(DownServers, 0) as 'DownServers' from ( select bldg, count(*) as TotalServers from nodes where vendor = 'windows' and status = 1 group by bldg) a full outer join ( select bldg, count(*) as DownServers from nodes where vendor = 'windows' and status <> 1 group by bldg) b on a.bldg = b.bldg

zazaz

thank you for repply,

can you tell me which component monitor should i add for this query?