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

Report Application status PER Poller

Has anyone generated a report that shows the Application status PER Poller (SAM Monitor UP/DOWN/Unknown count)? The Event Summary shows these counts overall on the system but when 3k components are showing down, it's good to know what poller is having issues quickly.

I have multiple APEs and have an issue that a poller will stop processing the application monitors properly and most/all the applications will show DOWN or UNKNOWN. Sometime services will recover due to a crash, but most of the time a HA failover or server reboot is required to restart services.

My problem is when this happens at night and another tech gets flooded with alerts.

I'd love to be able easily show how many components are UP/DOWN/Warning on a per poller basis.

Any input appreciated.

Thanks!

Find more posts tagged with

Accepted answers

All comments

m-milligan

Do you just want a count of how many apps are up/down/unknown per poller, or do you need a list of the apps that are down/unknown per poller?

gsibley

I want a count of app up/down/warning/unknown/unmanaged per poller. It would be great to map the poller ID to the poller name in the Engines table. I'm poking at SQL now, but it is not my strong point.

m-milligan

This SWQL query will give you the data you need (poller name, status level, number of apps on that poller with that status):

SELECT App.Node.Engine.DisplayName as [Poller],
App.StatusDescription as [AppStatus],
Count(App.StatusDescription) as [AppCount]
FROM Orion.APM.Application App
GROUP BY App.Node.Engine.DisplayName, App.StatusDescription
ORDER BY App.Node.Engine.DisplayName, App.StatusDescription

Set up your report table like this:

aldo56

Can you do that to display, instead of count a listing of effected nodes along with ip per poller?