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

Need custom report

Would anyone be willing to help me get a custom report into Orion? Or if someone has a similar report I would be verrry grateful if you would share it with me. This would be a daily uptime report over 30 days broken down by each day and then summarized over a period of 30 days.

It might look some what like this:

Find more posts tagged with

uptime

custom_report

Accepted answers

All comments

r0berth1

Do you have to report which day had the problem? otherwise just use a report that shows uptime for the month. I have a monthly report that your can use.

forks

That's the kicker, they want to see uptime each day of the month and then total uptime for the month. That way they can know which day the issue occurred that caused uptime not to be 100%.

If you'd be willing to share your uptime report with I'd apprciate it. Can't have too many reports. If it's the same as what is in the canned reports then I already have it.

r0berth1

This one shows % Availability for the month but only for M-F between the hours of 7A.M. - 7P.M. I have a report for each state. just change the AL in (Nodes.State = 'AL') to whatever you want. I added a custom property to each circuit for State.

SELECT TOP 10000 CONVERT(DateTime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS SummaryMonth,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability,
Nodes.Branch AS Branch

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

WHERE
( DateTime BETWEEN 39537 AND 39566.9999884259 )
AND
(
(Nodes.State = 'AL') AND
(DATEPART(weekday, DateTime) = 7) AND
(Convert(Char,DateTime,108) >= '08:00') AND
(Convert(Char,DateTime,108) <= '14:00')
)

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

ORDER BY SummaryMonth ASC, 3 ASC

-----------------------------------------------------------------------------------------

This one shows the Monthly % availability in min.

Select NodeCaption, IsNull(Sum(DownTime),0) As DownTime From (
SELECT
      Nodes.Caption As NodeCaption,
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 Downtime
FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')
AND eventtime between dateadd(month, -1, getdate()) and getdate()
) dt
Group By NodeCaption
Order By NodeCaption
Select NodeCaption, IsNull(Sum(DownTime),0) As DownTime From (
SELECT
      Nodes.Caption As NodeCaption,
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 Downtime
FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')
AND eventtime between dateadd(month, -1, getdate()) and getdate()
) dt
Group By NodeCaption
Order By NodeCaption

forks

Thanks r0berth1. I'll give those a test drive.