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

Alert Triggered

mahindra_varma

Hi All,

I need to Custom SQL query to get all triggered alerts(emailed alerts) in past 24 hours. I tired working in report writer as i am very new to SQL not able to completed. Can any one please help me out

Find more posts tagged with

Accepted answers

All comments

rschroeder

Was the output in Alert Manager insufficient or in the wrong format? It's very easy to display them there . . .

mahindra_varma

When i tried running the query no output is generated , even there are some email alerts on the same day.

pratikmehta003

There is one report available by default...did u check that?

njoylif

I ensure that any alerts I'm interested in reporting on are [trigger action] NPM Event logged with desired info, then I just query the events table with appropriate WHERE criteria

mahindra_varma

Yes, using that I am not getting all email triggered events

I am only getting website components alerts, not on custom SQL query, high CPU usage and etc

zackm

What products and versions of SolarWinds do you have installed currently?

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

mahindra_varma

I am using SAM 6.2 version

zackm

You could try these:

SQL for All Alerts per Object:

SELECT  Name 'Alert Name'  ,EntityCaption 'Object of Alert'  ,COUNT(1) 'Times Alert Triggered'FROM AlertHistoryViewWHERE EventTypeWord = 'Triggered'AND TimeStamp > (GETDATE()-1)GROUP BY Name, EntityCaption

SQL for All Alerts:

SELECT  Name 'Alert Name'  ,COUNT(1) 'Times Alert Triggered'FROM AlertHistoryViewWHERE EventTypeWord = 'Triggered'AND TimeStamp > (GETDATE()-1)GROUP BY Name

Both of these will count the number of times an alert has been triggered in the last 1 day.

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems