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
Home
Products
Network Performance Monitor (NPM)
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
Find more posts tagged with
Accepted answers
All comments
jtimes
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
jsanto
Right on. That works perfectly. Thanks for the quick response. I guess my SQL skills will just have to get better...
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of
