1 of 1 people found this helpful
You haven't indicated whether you are trying to do this in a web-based or Report Writer report. The easiest way is going to be by creating the report in Report Writer. The Report Writer allows you to filter your availability reports on date, day of week, hour of day, or time of day. Here's as example for 8 AM to 6 PM:
Now, this report is still going to show the availability of all of your nodes during business hours for whatever time frame you choose. If you want it to only show you nodes that had downtime during business hours, then you are going to have to do an Advanced SQL report. I just did one of those last week.
If you are doing a web-based report, then you are most likely going to need to add a Custom Query resource to your report and write it in SWQL.
That really helps, I will also look into the SQL reporting.
My SQL is really weak so it will take some time