• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 38 subscribers
  • Views 309 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report measuring acknowledgement time

jsanto
Does anyone know if there is a way to report on the time between an alert trigger and the time that alert was acknowledged?
(Writing reports is my least favorite thing to do, so if it isn't out of the box, I probably won't figure this one out on my own...)

Thanks for any help,
James
  • 0
    My DATEDIFF SQL skills are completely lacking, so no auto calculation of how long it took to acknowledge the alert; but with this report you can get the alert start and Acknowledged time (as well as by whom.) If you want all active alerts the remove the "WHERE & AlertStatus.Acknowledged = 1" statement at the end.

    File > New Report > Advanced SQL

    SELECT
    AlertStatus.ObjectName AS ObjectName, AlertStatus.TriggerTimeStamp AS EventStart, AlertStatus.AcknowledgedTime AS AcknowledgedTime, AlertStatus.AcknowledgedBy

    FROM
    AlertStatus

    WHERE
    AlertStatus.Acknowledged = 1



    No worries, there are some real SQL experts on this board, I'm sure someone can workout the DATEDIFF syntax.

    Hope that helps
  • 0
    Right on. That works perfectly. Thanks for the quick response. I guess my SQL skills will just have to get better...

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.