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 on TOP XX Alerted Nodes

Hi All,

I am trying to get a report where I could list say top 10 nodes which had the maximum alerts in last one month. So, it should list out NodeA had 20 alerts, NodeB had 19 alerts and so on....

I can do it manually in various ways but it would be nice to have it automated for problem management every month/week.

Any help here would be appreciated.

Many Thanks!

Find more posts tagged with

Accepted answers

All comments

amrita1690

Hi aLTeReGo,

Any suggestions here, please ?

Thanks!

aLTeReGo

You mean something like these?

dgsmith80

I'm not sure it will be that straightforward as the Alerts table doesn't store your alerts by NodeID, and not All alerts are directly related to a Node, so you would have to perform some sort of filter that excludes alerts that are not Node alerts, and then various joins to get the other data you need.

I'm sure it's possible, but not easy.

dgsmith80

I stand corrected - Although I would argue that there was a lot of work put into those reports but due to the awesomeness of this community we all get to benefit !

amrita1690

Thanks aLTeReGo,

This is not exactly I needed, but these helped add to the vision.

For now, I rather need a report stating Node1 has 20 alerts, Node 2 has 30 alerts, Node 3 has 10 alerts, and so on.