This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Node_Availbility_-_Last_Month_-_90%_or_less.OrionReport

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.

Enjoy,

Matthew Harvey

Loop1 Systems

Node_Availbility_-_Last_Month_-_90%_or_less.OrionReport