Version 1

    Here's a report I used to see requests for in terms of being able to filter an availability report.  Due to the aggregate function that Orion is doing, a filter in the Where clause will not work.  As such an Advanced SQL report is needed to put in a Having Clause to specify the availability filter.  This report displays any node that had 90% or less availability over the last month.  It's easily altered for different values by changing the number in the having clause.



    Matthew Harvey

    Loop1 Systems