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.

Orion Report Writer - Question

User227 over 11 years ago

I have a historical report created in Orion Report Writer for the last 7 days. It has the Report Grouping Tab to display the Average Availability of the nodes so when the report is run it lists lowest available percentage nodes first then eventually any node which has been completely available under the sub heading of 100%.

My question is how do I parse off all devices that have the availability of 100%? We are only interested in the small number of nodes that have issues instead of all nodes (majority of which are fine).

All editing seems too incorrectly manipulate the data.

Is there a way to do this?

Thanks,

0 zkahl over 11 years ago

It sounds like you don't want to display the devices that are 100% available.
Add this line under the "filter results" tab
Records where Availiblity is not equal to 100
Zak Kahl
Loop1 Systems
Http://www.loop1systems.com
Cancel
Vote Up 0 Vote Down

Cancel
0 User227 over 11 years ago in reply to zkahl

Zak,
Thanks for the reply. Yes that is the desired result, however we have tried the filter where Availability is not equal to 100 and various other combinations, but the data is not being parsed.
I was not sure if there was a known bug in the SQL design for this.
Thanks,
Scott
Cancel
Vote Up 0 Vote Down

Cancel
0 zkahl over 11 years ago in reply to User227

Scott,
I tested this with NPM 10.4 and it worked. Can you drop a snapshot of your report writer screens. Also, if you are trying to modify a existing canned report, you should try to recreate an new report. If you haven't yet. You can make it identical to the existing one. I have seen that resolve issues like this.
Zak
Cancel
Vote Up 0 Vote Down

Cancel
0 mharvey over 11 years ago in reply to User227

With the report using an aggregate function to calculate availability, you have to in turn use an Advanced SQL report and use a HAVING clause, rather than using the Filter tab. This is due to how limited SQL is when filtering where statements when using an aggregate function. Here is a link to a report that should suit your needs. You just need to change the 90 in the having to the number you want to filter by.
Regards,
Matthew Harvey
Cancel
Vote Up 0 Vote Down

Cancel
0 User227 over 11 years ago in reply to mharvey

Thanks Matthew.
Will give it a try
Cancel
Vote Up 0 Vote Down

Cancel