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.
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
ORDER by a.TriggeredDateTime DESC
Hope it helps.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.