Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Orion Report Writer Issues

Hi all,

Hope you guys have a great weekend.

I am trying to genearte reports for Resposnse time, Availability, Packet loss and Interface Utilization.

The time frame selected is for two weeks and i have four 6500's with close to 50 interfaces on each.

When i generate the preview, i dont get the complete data for the two weeks. It says formatiing 10000 records. I can see that the pdf which is exported can only have max of 10000 rows. Can this row limitation be increased. Also I want the report to have data for every one hour sample. The report actaully has details for every two minutes. I have attached the screen shots.

Hoping someone could help me out with this

Report 2.zip

Find more posts tagged with

Accepted answers

Questionario

I think report writer defaults to "Top 10000", there is an option tab (Top XX)where you can change this.

To make sure that it doesn't restrict it to 10k, you can also click on the "Report" in the menu bar and make sure that "Show SQL" is checked.

Your report will then have an extra tab which shows a read-only version of the sql it is going to use... if it says something like "Select Top 10000 *" then that would be the reason.

All comments

sanjumathen

screen shot - 2

Questionario

I think report writer defaults to "Top 10000", there is an option tab (Top XX)where you can change this.

To make sure that it doesn't restrict it to 10k, you can also click on the "Report" in the menu bar and make sure that "Show SQL" is checked.

Your report will then have an extra tab which shows a read-only version of the sql it is going to use... if it says something like "Select Top 10000 *" then that would be the reason.

sanjumathen

Hello Marie,

Thanks for your reply, that really helped. That option within topxx " select only the top XX" was a bit confusing. that could be rephrased as select top XX..

Currently the detialed retenction is for 7 days. IF i change that to 2 days, does the data for the previous 5 days get averaged on a hourly basis? Or is it that the system just retains the hourly stats and deletes all the rest?

I feel tweaking the retention timers will reduce the size of my reports for past two weeks as i dont need reports for every two mins. or i could change the polling timer and leave the retention to the default.

sanjumathen

In the Latency/Jitter reports that are generated, the values are close to 14 decimals.

How can i reduce this

Ralphr

if you change the detailed retention time the data will be summarized but that and tweaking polling times are normally done in response to overall DB size and performance issues. It sounds like you can get what you want without doing any of that by editing your report to "summarize data" either hourly or by day.