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

SQL Query

I would like create a report that will show me what alerts are associated with each node.
I believe it can be done using an advanced SQL query from the Report generator but I am having difficulty building the SQL query.

Has anyone else done this?

Find more posts tagged with

Accepted answers

All comments

I answered my own question. You need 7.1 or better to see this report in the web interface.

Paste the following into a custom SQL report in report writer.

Select NodeName, ObjectName, Alerts.AlertName
From Alerts
inner join activealerts on alerts.alertid = activealerts.alertid

order by activealerts.nodename

Quick Links