Required Availability report in Time ( hours/ minutes ) instead of percentage value.

Roja08

I need some help with creating a report to device availability in hours  instead of percentage. Could someone please help me?

Any help is appreciated.

Thanks in advance,

Roja

mesverrum

So this is a fun one and depends mostly on how much of a fudge factor you are willing to accept in your reporting. 

The simplest solution is to find out how many minutes would be in your reporting period and take the percentage of availability and multiply it against those minutes. 

So for example 1 day, 1440 minutes except on days where DST changes, with 98.5% availability

1440 × 0.985 = 1418.4 minutes of uptime, or you could call that 21m:36s of downtime. 

Now did you actually have exactly 21 minutes of downtime, almost certainly not because of polling periods and the way that the availability numbers are calculated by counting the number of individual missed pings, but given the constraints of the tool there isn't really a better way to track "real downtime." And taking it further, if you ever unmanaged a device during the month your numbers are basically wrecked.   Trying to factor out scheduled outages is the next question that almost inevitably comes, which is also incredibly difficult to do except by doing a lot of fairly tedious math after the fact. 

If you can't tell I've been dragged into these kinds of availability conversations often and the net result is that you just have to accept that a) the number is kind of made up BS or b) it will be a relatively complex math and data problem to get a "true" number.