I'm trying to create a report where I can show nodes availability, then filter by peak time (8am - 6am). So basically the report should only show nodes that were down for the month between those times,
I tried filtering by Event Time but that only allows me to input the date, not a time.
Is there any way to filter by time and date?
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.
Thanks blsanner
That really helps, I will also look into the SQL reporting.
My SQL is really weak so it will take some time 
