Availability report for last 30 days based on the custom property with the unmanage time duration.

rajasekar

For example in need report like Env is our custom property:

Env Availability Unmanage duration
A 90% 10 hours
B 99% 2 hours
C 10% 1 hours

Find more posts tagged with

report

Accepted answers

All comments

mrxinu

Some clarifying questions about your requirements:

Do you want to include unmanage spans that haven't happened yet or are you only considering nodes that are currently in an unmanaged state? For example, if a node will be unmanaged for 12 hours but it won't happen until next week, is that added to the total minutes?
Do you want to include unmanage minutes that have already passed? For example, if you have 5 nodes that have been unmanaged for anywhere between 1 and 10 hours, but they all have varying time remaining, do you add up all the total ranges?
This report is grouped by environment, so if you have 10 devices each with 12 hours of unmanaged time (however that's calculated based on the above) would you expect that number to be 10*12*24 or 2880 minutes for Environment A?

rajasekar

Hi @mrxinu
Am looking for the report which need to show the availability % of a node for 30 days in a column and unmanage span total duration of that node within that same 30 days in a column and a custom property in a column.

Example:
Node, Availability, unmanaged duration, Env
ABC, 99%, 10 hours, x
XYZ, 90%, 10 hours 30 mins, y

mrxinu

In a 30-day period, there's no way to tell that node A was unmanaged for three different time spans of 30 minutes, 60 minutes, and 15 minutes for a total of 105 minutes. I assume that's what you're trying to get in that column. Is that right?

Update: As I submitted the above it occurs to me that it could be calculated by looking for events and getting the spans between them but that would be difficult. Let's clarify that's what you're looking for before going down that road.

rajasekar

I need to get the average availability and average unmanaged span time for last 30 days.