Uptime of Servers Report

I am trying to figure out how I can generate a report of uptime for a group of servers. I need to be able to go back and show uptime from Oct 2015 - Oct 2016 then generate a monthly or weekly report of uptime. I have been using this for a bit to generate some reports How to create custom SLA reports but it is not working out too well. Is this something I can go through the Custom Report writer and figure out? If someone could point me in the right direction that would help.

Find more posts tagged with

node_uptime

sla_reports

node reports

report

Accepted answers

All comments

brac

There is a new KB article that details how the custom SLA report SWQL query works. There may be something there that can help you create your server uptime report.

tdanner

Could you show us the query you have so far and tell us what issues you are running into?

martian_monster

I have been using the SLA report. One issue I have is I am not super famliar with report writing so I am trying to get up to speed right now. I was modifying the SWQL query to try to grab different times and dates and I was not getting anywhere. To make a long story short I got an email and for server uptime over the past year for a set of servers. Once I get that done the request was to send a monthly uptime report to a set of individuals. I can figure out how to send but the report creating is where I am having issues with. I watched SW quick video but it did not help too much. Besides Thwack are there any other resources that might be able to help with this so I can learn how it works?

Below was the SWQL query that I modified to try to give me the year uptime for a set of servers I created. This is based off the SLA query but if you have something else that is better I am all ears. Thanks a bunch!

select n.Caption, sub_query.sla_day, sub_query.sla_availability, n.CustomProperties.MedComRDS_From, n.CustomProperties.MedComRDS_To FROM

(

SELECT avg(Availability) as sla_availability, datetrunc('day',datetime) as sla_day, r.NodeID

FROM Orion.ResponseTime r

where hour(datetime) >= r.Node.customproperties.MedComRDS_From and hour(datetime)<= r.Node.customproperties.MedComRDS_To

group by datetrunc('day',datetime), r.NodeID

) as sub_query

inner join Orion.Nodes n ON n.NodeID=sub_query.NodeID

tdanner

Sorry, martian monster - I lost track of this thread and forgot to follow up. It's been a few weeks. Where are you with this now?