Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Audit Report.

Hi All,

I am trying to create audit report . and I need 4 column in the report "Alert Trigger Time" "Alert Acknowledge Time" "Acknowledger Name" and "Alert Message"

Opened case with solarwinds they are unable to create this report.



Labels (1)
0 Kudos
7 Replies

Create a Advanced SQL Report and check if the below query provides the results that you are looking for:

select a.TriggeredDateTime as Alert_Trigger_Time, a.AcknowledgedDateTime as Alert_Acknowledge_Time,a.AcknowledgedBy,

c.Name + ' was triggered on Object: ' + d.EntityCaption + ' on the Node: ' + d.RelatedNodeCaption + ' at this time: ' + convert (varchar, a.TriggeredDateTime) as ALERT_MESSAGE_DETAIL

from AlertConfigurations c INNER JOIN AlertObjects d

on c.AlertID=d.AlertID INNER JOIN AlertActive a

on d.AlertObjectID=a.AlertObjectID

where a.Acknowledged=1

ORDER by a.TriggeredDateTime DESC

Hope it helps.

0 Kudos

How do I see the same data over a specific time period?  This is only showing active alerts.

0 Kudos

Bye bye Alert Central....

0 Kudos

This Query Shows No activity to report.

0 Kudos

I would suspect that no one has Ack'ed an alert. If you change the 2nd to last line to ->  where a.acknowledged is NULL

You will see the un-ack'ed Alerts.

0 Kudos

What version on NPM are you using ?

0 Kudos

NPM 11.5.3

0 Kudos