I am trying to put together a report to show me a list of my nodes which have been frequently unavailable during the past 7 day period. I can go into any single node and see availability for different time frames, but I want one report that shows availability for 1 time frame for multiple nodes. What I have put together in the report writer [and attached here] shows me numbers, the numbers just don't add up with my observations.
I thought, maybe if there is a way I can get the total "up time" over the past 7 day period, I could divide that by total time in 7 days and get the percent availability during that period. Since these aren't default properties I am trying to figure out how (if) I can a) get up time from the last 7 day period b) make a custom property that uses the value from a and calculates the percentage.
The new report would then use the value in custom property b in the report.
