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

Getting InError value using SQL for AlertAction

Rainevar

Hi,

Instead of getting InErrorThisHour which have been provided on system, I am trying to get the InError every 5 minutes from table InterfaceErrors_Detail

Here is my custom sql alert:

SELECT
Interfaces.InterfaceID AS NetObjectID,

Interfaces.FullName AS Name

FROM Interfaces INNER JOIN InterfaceErrors_Detail ON Interfaces.InterfaceID=InterfaceErrors_Detail.InterfaceID

/*SplitMarker*/

WHERE

(

(InterfaceErrors_Detail.In_Errors <> 0) AND

(DateTime > dateadd(minute, -5, getdate())) AND

(

(Interfaces.Critical = 1) OR

(Interfaces.ExchangeData = 1))

)

It works as a trigger...

Now I need to get the InterfaceErrors_Detail.In_Errors value on the action alert i.e. on the email sent or log to file.