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

How to include unreachable time in an availability query?

Sorry if this has been discussed before, I tried searching thwack and couldn't find an answer to my question.

I need to calculate a node's availability as part of a SQL query I am writing. I am using the ResponseTime_Detail table to do so and averaging up the Availability column. I have found that the results within my query show a different percentage than what is displayed in the Availability Statistics resource on the Node Details view. The details view shows 96.575% for today whereas my query is showing 100% for today.

After looking through the database entries, I found that there was a gap of time missing in the ResponseTime table between 9:30 and 10:00 am this morning for this node. It turns out the node would have been in unreachable status during that time because the node it depended on was down for that period. There has been no other downtime for this node besides that time period.

So, my guess is that the availability statistics resource can somehow take the unreachable time into it's calculation, but I can't find what table that data would come from. Does anyone know how I write a query for node availability that will include the time it was unreachable?

Thanks.

Find more posts tagged with

Accepted answers

All comments

craigsg

Hi brandonccr,

Did you find an answer for this?

I have the same problem. I'm managing 3 networks where I'm using dependencies alot. Each one has a core 3750 switch, 6 or 7 2960's and then each 2960 has between 6 and 18 access points. So when the 3750 goes down I don't get 100 alerts. Great.

The problem is when I run an availability report I get an accurate uptime on the core 3750 but every other device says 100% when they should also be 98.784%

brandonccr

I realize it is a bit late to respond to your post, but just in case any one else happens to come across this, I never did find a solution to the issue I described in my post. If anyone else knows how to do this, I would still be interested in knowing how this can be done.