nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

surnaihai899

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

mesverrum

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.

mesverrum

I've been living inside that database for about 10 years, I can guarantee you that the alertobjects table does not show alerts that have not triggered in the past before.

If you add a brand new node go look and see what it has in that table, it will be nothing until that node triggers an alert, and then it will only be adding the specific alerts that the device has already triggered when they trigger the first time. If your device has not yet triggered a BGP Neighbor Change alert but it could in the future, then reporting on the alert objects isn't really accurate.