Make an average of a field

Question

This is another one driving me nuts!   I want to create a report showing the average size of full tapes for each backup server; however there does not appear to be a way of getting the report to produce an average for each backup server.  I start with the Media Details source and apply the Average operator but this results in a table which has server, volume name, size of volume (an average appears to be taken for all times that the volume details are recorded).  I have tried dropping the volume name and applying the Average function but no good.  Is there any way I can do this without having to import the results into Excel and produce the results there (very easily too).

ElvinKan · Accepted Answer

hey David

I would approach it differently. Using Media Details is inefficient as you would request DPA to retrieve ALL media rows and then perform the Average on it - this could take long to run and use a lot of memory at a large customer site.

I would use "Media Usage" with a State=Full condition, and Merge it with a "Media Count" (also with a State=Full condition) and Merge it then Divide the fields

(both datasources will be a point-in-time).

I've tried to attach a screenshot for you as well.

Regards

-Elvin

David_Hampson_90e289 · Answer

Just to clarify, after dropping the volume name and applying the average operator it still returns a table with server listed in one column and individual volume size in the other column; there is no averaging at all!

David_Hampson_90e289 · Answer

That's great Elvin, I wasn't aware that I could add conditions based on fields not in the data source.&#xa0; However, one further thing has occurred to me - several of these servers use two different tape technologies and I want to be able to estimate average media size for each tape type.&#xa0; Is there any way I could achieve this?&#xa0; It seems the nearest thing I can do is use either the Media Usage (Count) By Location or Media Usage (Count) By Pool and do the same thing, which is probably the same answer - I'll take a look at to configuration here and see what would be the best one to use.&#xa0; Thanks for your help, I think I owe you a coconut ice cream for that one

David_Hampson_90e289 · Answer

Looking at how things  are configured, different types of tapes are both in the same pools and the same libraries.

ElvinKan · Answer

If there is only two main types, I'd just have one report per type - and in each report just add in the relevant conditons on each datasource eg. State=Full AND Type=LTOx (or similar)

David_Hampson_90e289 · Answer

That was my initial thought, but Type is not available as a condition.

Data Protection Advisor

Make an average of a field

Was this post helpful?