Solved!
Go to SolutionA
aviraikkonen
1 Rookie
•
22 Posts
0
2046
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
aviraikkonen
1 Rookie
•
22 Posts
1311
0
Posted November 25th, 2014 01:00
Thanks Adam, works wonderfully.
clevya
117 Posts
1311
0
Posted 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