AVR - Collecting statistics

Hi, I’d planned to collect statistics for a month a certain traffic and apparently the AVR is synthesising that data.

I need that statistics to be daily plotted in the graph.

So, does Big-IP have data stored detailed or AVR process don’t keep that data and it means that I don’t have the detailed data anymore?

Is there any way to try this from mySQL database? I had no luck.

Thank you.

Did you try to show your data by tmsh commands ?

examle:

show /analytics report view-by country range now--now-30m

Another devcentral question should answer your question about storage limitations: AVR historical data

By design, external data is a requirement for the granularity. Internal data collection is limited to allow for storage and performance limitations. For this reason, AVR aggregates data according to the following:

First 2 hours it keeps data aggregated every 5 minutes
After 8 hours it keeps data aggregated every 1 hours (60 minutes)
After 2 days it keeps data aggregated every 4 hours (240 minutes)
After 2 weeks it keeps data aggregated every 24 hours
After 2 months it keeps data aggregated every 1 week
After 1 year it keeps data aggregated every 4 weeks


Other internal limits are;
chart capacity is limited to 1 year
Captured transaction data is limited to 1000 records and although new records are being displayed in the gui, the old records must be cleared before the new records are stored.

Greetings!
Andreas

Thank you for the informations. I realized this in a hard way. So, I made a query in AVR database and I retrieve detailed data for the last fifteen days and incomplete for the rest. Regards.