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

Interface outage report & availabillity?

This is SQL query for
Interfaces-outage-in minutes-monthly
please some one help me about creating Availabillity report for interfaces how to summ all outages (minutes) and give in percents for my manager ???? emergency
and how it will go on web?
************************************
SELECT
CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/01/' + LTRIM(YEAR(EventTime)),101) AS SummaryMonth,
Interfaces.NodeID,
Interfaces.Caption,
Interfaces.InterfaceID,
DATEDIFF(Mi, StartTime.EventTime,
(SELECT TOP 1
EventTime
FROM Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 11
AND EndTime.NetObjectType = 'I'
AND EndTime.NetObjectID = StartTime.NetObjectID
ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes

FROM Events StartTime INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
WHERE (StartTime.EventType = 10) AND (StartTime.NetObjectType = 'I') AND ( EventTime BETWEEN 38410 AND 38439 )

GROUP BY CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/01/' + LTRIM(YEAR(EventTime)),101),
Interfaces.NodeID,Interfaces.Caption, Interfaces.InterfaceID, StartTime.EventTime, StartTime.NetObjectID

zvanevski@yahoo.com
thanks