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

Alerting

I have a set 50 devices . Is there a report i can generate that will tell me the corresponding alerts to 50 devices?

Find more posts tagged with

Accepted answers

Unfortunately no, there is no way to generate a bulk report of that widget. Also you can't exactly trust that widget 100% because there are lots of ways to configure an alert and this widget basically only knows if you match the "Scope" section of the alert trigger.

All comments

SteveK

So are you looking for a report that would give you the alerts that the devices could trigger, or are you looking for a report that tells you the active alerts for those devices?

surnaihai899

I want this ,

mesverrum

surnaihai899

I tried this and results do look promising

SELECT TOP 250 AlertObjectID, AlertID, EntityType, EntityCaption, Name, RelatedNodeId, Enabled

FROM Orion AlertObjects ao

inner join Orion AlertConfigurations ac on ac AlertID ao AlertID

where EntityType like 'Orion. Nodes'

--and enabled = 'True'

--and RelatedNodeId like '7561'

--and AlertID like '164'

--where RelatedNodeId like '7561'

--and EntityType like 'Orion. Nodes'

order by EntityCaption DESC

mesverrum

The limitation of that logic is it will only show you alerts that have already triggered on each object before. So its not a report of all possible alerts, just the ones you have run into historically.

surnaihai899

No, this will give you the alert that the device will trigger..it will give you the panel i posted up there.