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

Availability reports

I am trying to put together a single report that will be placed in a folder accessible from the menu bar with the following information.

1. Time of last outage
2. Number of days up since last outage
3. History maximum # of days up
4. Monthly availability %

The web interface node detail page gives the last time the device was rebooted but not the last time it was unreachable. I can make or use the existing monthly availability report to get group or individual node percentage, but including the first three queries on the monthly availability report is my issue. This would be useful for Internet circuit availablity monitoring.

Has anyone constructed an SQL statment that was succussful in pulling the neccessary data for number 1, 2 and 3 above from the event table to get the up time based on events?

Kim West

Find more posts tagged with

Accepted answers

All comments

rossw

Kim,
Take a look at this post/thread.

www2.solarwinds.net/.../topic.asp

rossw

Kim,
Any luck?

Ross Warren

KimWest

I had sent you and email directly on this but I was also waiting for your reply on how it would work using report writer and not SQL manager to make the statement.

Kim West

rossw

Kim,
I haven’t been back to report writer to get the query to work. I will try to get it done this week.

Enterprise Manager should be on your local machine if you aren’t using remote database.

Here are some answers (kinda)
Sort of 2/3 (from resources in the forum)

SELECT TOP 25
StartTime.EventTime,
Nodes.Caption,
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 Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')
ORDER BY StartTime.EventTime DESC

#4 (From Other Sources in the Forum)
SELECT CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
Nodes.Caption AS NodeName,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

WHERE
( DateTime BETWEEN 38561 AND 38592 )

GROUP BY CONVERT(DateTime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.Caption

ORDER BY SummaryMonth ASC, 3 DESC

Hope this helps.

Ross Warren