Hi,
I am suprised that this has not been done already and I am having a hard time trying to figure this out with limited SQL query experience. I need to create a report that does the following for an application that we are monitoring. I have a report that I use for nodes but it does not work with the applications.
For each reporting period Monthly and weekly, Report on system availability service level reporting will include:
Total Availability Minutes,
Total Number of Outages,
Total Outage Minutes,
Target Availability and Actual Availability.
Production System / 99% availability per month / 99.5% availability per month
Test System Availability / 95% availability per month / 99% availability per month
Business Continuity / 95% availability per month (1 business day recovery) / 99% availability per month
I have found some reports simular on the content exchange that do outage minutes for ALL applications like this one below - Thanks whomever wrote this.
If someone could figure out how to streamline this for just one appliaction and report the node it is on and business hours only that would be awesome and we would all praise their screen name since I believe this would help manymany people out who have to meet an SLA for not only node up time but also application up time.
Thanks again whomever wrote this below.
SELECT
StartTime.EventTime,
Name,
StartTime.Message,
DATEDIFF(Mi, StartTime.EventTime,
(SELECT TOP 1
EventTime
FROM Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes
FROM Events StartTime INNER JOIN APM_Application ON StartTime.NetworkNode = APM_Application.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') AND
eventtime between dateadd(month, -1, getdate()) and getdate()
ORDER BY Name ASC
Thanks in advance if somene can help with this.
