All 1 minute and 15 minute data is stored in files in the ReaperArchive and ReaperArchive15 directory and accessed through a Custom Mysql Storage Engine running on port 3307 on the Harvesters.
We generally do not recommend trying to query this database directly as its not your standard mysql database and the data is stored in files instead of tables.
If you are running NFA 10.0.x you can use the OData API to query a single interface's AS Numbers, and example is in the link below:
https://docops.ca.com/ca-network-flow-analysis/10-0-0/en/reference/network-flow-analysis-odata-api/query-options/system-query-options/navigation#Navigation-NavigationwithasNum
Original Message:
Sent: 09-06-2019 06:26 AM
From: Pedro Filipe Lourenco
Subject: CA NFA - AS Numbers metrics
Hi,
Anyone know in which database/table we can find the AS metrics for one interface?
BR,
Pedro Lourenço