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 Actions Reports

You can get the alert actions with alert name with this sql query.

SELECT
ac.Name
,aa.ParentID
,aa.[EnvironmentType]
,aa.[CategoryType]
,a.Description
FROM [SolarWindsOrion].[dbo].[ActionsAssignments] as aa
inner join Actions as a on aa.ActionID = a.ActionID
inner join AlertConfigurations as ac on ac.AlertID = aa.ParentID
where aa.EnvironmentType = 'Alerting' and ac.name like 'Turkcell%' --and a.ActionTypeID = 'SnmpTrap'

Find more posts tagged with

Reports

alertactionreports

alertactions

Comments

gemasw

Thank you so much sir. You just save my day

idriskerti

You're welcome

For other people some of the parts can change with environment. They need to change the Alertname part.

alok.malvi

This is very helpful. How can we get details on the action which executes external program? For email I see the recipient and other detauls which are very helpful but for program or netperfmon action I dont see additional details.

I have a external bat file command line which updates our splunk with the alert. but I only see "Execute a program when the Alert is Triggered or Reset: It would be nice to see if the command line and the argument passed are in the report.

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches