This post is more than 5 years old
1 Rookie
•
22 Posts
0
2001
November 21st, 2014 02:00
How to extract capacity reports from Avamar CLI
Hello
I need to extract the report for Activities - Bytes Protected Client.csv from the CLI. From the GUI, I can extract it but I need to do it from CLI.
The dpnsummary --days=n gives me the dpnsummary results but it doesnt list the server names.
My requirement is the CLI equivalent of Activities - Bytes Protected Client.csv
No Events found!
clevya
117 Posts
0
November 21st, 2014 04:00
To last command will give you a nice output for the screen. If you want it in csv format this may be better:
psql -p 5555 mcdb -U admin -A -F, -f /usr/local/avamar/lib/sql/rptActBytesProtCli.sql -o /tmp/output.csv
-U = User to access the database
-A = Unaligned output mode
-F, = Use comma as field delimiter
-f = File containing SQL query
-o = Output file
The above will save the output to a file /tmp/output.csv
Hope that helps
Adam
clevya
117 Posts
1
November 21st, 2014 04:00
Hello,
Running this as admin should work:
psql -p 5555 mcdb -f /usr/local/avamar/lib/sql/rptActBytesProtCli.sql
Regards,
Adam
aviraikkonen
1 Rookie
•
22 Posts
0
November 25th, 2014 01:00
Thanks Adam, works wonderfully.