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

Associate the AlertHistoryView\AlertNote field to its individual AlertActiveID

For improved SLA reporting with SolarWinds:

Revamp the AlertHistoryView table so when an alert fires and it gets an individual “AlertActiveID” assigned (from the AlertHistoryView table), any notes added to an alert while it’s active will only get applied to its assigned AlertActiveID records within the table. Using this logic, when the company's NOC ack's an alert and enters details on the cause of the alert firing, thus being able to run a report listing alerts causing an outage and why. Currently the alert note is ONLY tied to the alert node, causing every AlertNote for its node to be appended, making it difficult to decipher which alert note applies to which alert when it fired.

Find more posts tagged with

sql

Reporting

Status: None

Comments

KMSigma.SWI

This looks to be a request for a change to the database itself. We (SolarWinds) does not recommend anyone report directly from the database as the structure can change between versions. You'd be better off using the SolarWinds Platform API and the SWQL Studio to develop SolarWinds Query Language (SWQL) queries for reporting.

-- Simple example linking AlertHistory and AlertObject entities
SELECT TOP 1000 [AH].AlertHistoryID
     --, [AH].EventType
     , [AH].Message
     , [AH].TimeStamp
     --, [AH].AccountID
     , [AH].AlertActiveID
     , [AH].AlertObjectID
     , [AH].ActionID
     -- Connecting the AlertHistory entity to the AlertObjects entity
     , [AH].AlertObjects.EntityCaption AS [Caption]
     , [AH].AlertObjects.AlertNote AS [Note]
FROM Orion.AlertHistory AS [AH]
WHERE IsNull([AH].Message, '') <> ''
ORDER BY [AH].TIMESTAMP DESC