Where can I find the filter that I need to fix for the following report?
Could you elaborate on what you are trying to filter on for this report?
Thank you for helping me out.
What we ran into is a report that does not seem to work. From our "Home" screen we click reports, expand "Historical Traffic Reports" and select the report "Total Bytes Transferred by Node - Last 7 Days". we get a page that indicates the following:
It is a bug. What you will need to do is add the interface ID from the select Fields Tab- and make sure that it is above the Total Bytes Received field.
That worked for that report and I fixed the report for 7 days, last month and this month. However there is yet another report that I need your help to fix. Average and Peak Traffic Rates - WAN Interfaces Last 7 Days does not show any info.
I was running it from a web interface.
I just went into Report Writer from Net Perf Mon and hit the execute button. The window is now stuck with an Hour glass, the box indicates "formatting data..." It began counting down and is now stuck at 3000 records.
Well it sounds like one of two possibilities: The SQL Server is responding slowly and can't write the report query fast enough. Check the event logs of both the Orion and SQL Servers and see if there are any events such as "Main Task Data Reader" or "Connection Timeout". Also watch the CPU utilization on the servers when you pull a report - SQL can be a resource hog and perhaps the server just can't keep up with it. The other possibility is that there is just too much data to be sorted through in a reasonable amount of time. What are your settings as far as keeping old data? You can find these by going to File -> Orion Network Performance Monitor Settings in the System Manager. The Database tab should have this information on it.
You could also try to change the query a bit. Keep in mind that how you order the query has a big impact on the DB response time. Make sure you have the most specific query first. You can also try to incresae the DB timeout varibales.
The timeout settings for SolarWinds that can be adjusted as follows: Go to C:\Program Files\SolarWinds\Orion and find the file SWNetperfmon.db Open the file with Notepad. At the very bottom, there are two timeout values - Connection, and Database Command.Increase those to 1200 each, save and close the file.
Thanks again! It was the timers that fixed it for me. I set Connection to 60 and Database to 120 and the report runs fine.
I goofed something else up while i was working on this. I was in the Customize Menu Bar screen trying to edit the Top 10 list for one of our logins. I deleted the Top 10 when I wanted to edit it. Now it is gone form all of our Menu Bars. How can I get it back?
Thanks again! It was the timers that fixed it for me. I set Connection to 60 and Database to 120 and the report runs fine. I goofed something else up while i was working on this. I was in the Customize Menu Bar screen trying to edit the Top 10 list for one of our logins. I deleted the Top 10 when I wanted to edit it. Now it is gone form all of our Menu Bars. How can I get it back?
Mark,
We are having problems with our monthly utilisation reports post upgrade to the latest version of Orion.
Adding the interfaceID to the report does indeed resurrect the report, but it now forces the listing of every interface, not just one value for the whole node. What we need is the original format back.
Is there any other workaround - or any update when the bug will be fixed.
Thanks,
Julian
Opened support case for this one - and got a workaround :-
If reports containing interfaces stats dont work :-Add interfaceID to each report form, move it to 3rd position, change field to be SUM of interfaceID and then hide it.
Adding the interfaceID allows the report to be viewed (although it has to be moved up to 3rd position????? in the field list)
Changing the field to Sum of InterfaceID is necessary - otherwise the report generates a line per interface rather than one per node
Finally hide it.
With all due respect, "its a bug" is an extremly lame response. What seems to happen is, after upgrading to 9.0, the report writer losing its ability to filter on Custom Properties. This SUCKS for a million reasons! We have about 50 or so reports that are dependant on custom properties. Now none of them work. Invalid Filter.
For instance, I had a report that listed all enviromentals for our Cisco Routers. Ofcourse, I was filtering the resluts off of a custom node property that I had created; "Router".
Every Node added to Orion over the past 3 years has been added with a custom property. Every report we have ever created was filtered off of these custom properties. Now the report writer suddenly has no idea about all of the custom properties.
