Website Migration Notice: SafePoint is now operated by CyberServal.Learn more →
DiscussionSLA

How can I export statistics data to excel sheet

Published 10 months ago

# SafeLine WAF
# ❓ question

Published 10 months ago

profile_photo

Radi

Updated 10 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 .

profile_photo

Carrie

Updated 10 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?

profile_photo

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

profile_photo

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

profile_photo

Radi

Updated 9 months ago

0

Thank yoi Kekw, I will try and let you know the results