Published 9 months ago
Published 9 months ago
Radi
Updated 9 months ago
0
I need to download statistics data for 30 days for WAF a baseline data , is it possible to do that and how .
Carrie
Updated 9 months ago
0
Exporting statistical reports directly is not supported.
But in the Statistics tab, you can select 30-day statistics — would taking a screenshot meet your needs?
Radi
Updated 9 months ago
0
screenshot does not meet our need , becuase it does not show values just a graph and we can not choose the data to present if we want to have a baseline of normal operations to compare to
kekw
Updated 9 months ago
0
If you have access to the containers you could help yourself easily:
docker ps | grep postgres -> identify your containers uuid
cat docker-compose.yaml | grep POSTGRES_USER -> identify your psql user
cat .env | grep POSTGRES_PASSWORD
docker exec -it PSQL_UUID bash
psql -U PSQL_USER
inside psql: \dt so list all tables, search for stastics
\copy (SELECT * FROM statistics WHERE timestamp >= NOW() - INTERVAL '30 days') TO '/tmp/waf_stats.csv' CSV HEADER;
I didnt test yet, but this should help along to adjust to your needs
Radi
Updated 9 months ago
0
Thank yoi Kekw, I will try and let you know the results