Unsolved
This post is more than 5 years old
1 Rookie
•
47 Posts
0
3501
January 24th, 2018 06:00
Avamar reporting - psql commands
My client wants to run queries from the SQL database on the Avamar utility node to gather reporting for the following:
performance
throughput
complete backups
restores
Could anyone suggest how we do that with direct psql queries on the database?
Avamar version is 7.4.1
thanks!
No Events found!
Avamar Exorcist
462 Posts
1
January 24th, 2018 23:00
Backup performance statistics and 'throughput' information, depending on what you consider that to be, can be found in the client side logs. This level of detail doesn't get recorded by MCS in the postgresql database.
When a backup task completes those statistics are wrapped into an end-of-backup summary. You can read more about them here
KB 335281 - How to interpret avtar backup log status lines
connolly
2 Intern
•
132 Posts
1
January 25th, 2018 06:00
If you're looking to "pull" data for those criteria, you could just run a DPNsummary report (which effectively pulls DB data for you), export it to a spreadsheet, and then run macros on it to calculate what you need.
You would have to perform those calculations even if you got data straight from the Avamar PostGreSQL database - as the other person mentioned, that level of detail isn't actually in the MCS database info. But the info used to calculate it is.
mikelavery69
1 Rookie
•
47 Posts
0
January 25th, 2018 07:00
yes DPNsummary looks good so far but will try and create custom reports and email them via running profiles