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

Looking for an Alert owner (who has created and when?) with SQL Query

Hi,

I am looking for an Alert owner (who has created and when?) with SQL Query. And also let me know if manage configured alert does save somewhere in SolarWinds Server like Report (C:\Program Files (x86)\SolarWinds\Orion\Reports).

Find more posts tagged with

Accepted answers

All comments

yaquaholic

SQL query to see who created your alerts

/****** Who added the alerts? ******/

SELECT [AuditEventID] ,[TimeLoggedUtc] ,[AccountID] ,[AuditEventMessage]

FROM [SolarWinds].[dbo].[AuditingEvents]

WHERE [ActionTypeID] = 31 -- 31 = Orion.AlertAdded -- Look in the AuditingActionTypes table for all other types

By default alerts don't log to file, but you can make them very easily.

Go to your alert's Trigger Actions and add an Action called "Log the alert to a file", then configure the file destination.

er.vansh17091

Hi, Thank you! Is there any possibility to check like when an alert has been created in the system?

mesverrum

^ That report above would show you, but only if the alert was created within the last 30 days of the event retention period

yaquaholic

My Auditingevent table holds the last year of audit events.

Check your polling settings under /Orion/Admin/PollingSettings.aspx