DPA Report Challenge

Question

Hello Every day I do a backup of 20 clients. Now I need DPA to report to me the largest backup of the month for every single client and in the end add up these results and send me the report. Is this possible at all? It is important that it is the biggest amount for each client per month. if example is needed: Client Name GB Backed up Day 1 GB Backed up Day 2 GB Backed up Day 3 GB Backed up Day 4 Client1 20 1 1 1 Client2 1 300 1 1 Client3 1 1 4000 1 Client4 1 1 1 50000 Now I don't want a result that says 50003 (1+1+1+50000) which is the sum of day 4. What I need is a report with the result 54320 (20+300+4000+50000) which is the largest backup for every single client for a period of time all, added together. I really hope someone can help me on this. I use DPA v. 5.8.4 Thanks /Tommy

Michael_Real · Accepted Answer

This should be relatively simple,

It requires using the "GroupBy" Operator found in the Aggregate section

Your source data would be the table "Backup Job Details"

Your then group the source data by "client, setting the "default Number Operation" to Max

If you just wanted one line of the report showing the Total number of all clients you can add another GroupBy operator with the "Default Number Operation" set to Sum this time.

Otherwise you can add a Total field in the report to add all the clients up.

Data Protection Advisor

Was this post helpful?