Report Writer Hourly Report on Historical Data

In report writer, we can't display the data in an hourly basis if we are generating a quarterly report. Is there a way we can retrieve the data? Our currrent setting for statistics summarization on the Network Performance Monitor Settings are the following:

For detailed statistics will be summarized into hourly statistics after 15 days
For hourly statistics will be summarized into daily statistics after 30 days.
For daily statistics will be deleted from the database after 90 days.
For network events will be deleted from the database after 60 days.

How can we generate or extract the data for 3 months in an hourly basis if this is our setting? Is there any other way for us to retrieve the data? Please reply immediately because we will be presenting the report to our supervisors in an hour.

Find more posts tagged with

report_writer_issue

Accepted answers

All comments

Yann

Hi,

It's probably too late...

How can we generate or extract the data for 3 months in an hourly basis if this is our setting?

You cannot because hourly statistics are stored 30 days and then averaged as a single value for a day range in the daily statistics.

You will be able to produce hourly statistics for the last 30 days, older than that you lose accuracy.

If you need to produce such reports every quarter, increase the "For hourly statistics will be summarized into daily statistics after XX days" to 90 at least. Note that it will increase your disk space requirements on the DB server.

Thanks,

Yann

rcrim

Where is this setting?

Nandish

I would completely agree with Yann's advice.Once you have started retaining the hourly data for 90 days this is where you could create a Report for the same.

Open Orion Report Writer-->click New-->select Advanced SQL option from the list and come up with the SQL query satisfying your needs.

To change the Polling settings,log into the GUI and select Settings(top right corner).And then select Polling settings under settings tab on that page.Then you can take control of the settings explained in this thwack.