Is there a way of calculating the total undepduped data protected for a client. This would include any changed data over the retention period. Avamar only seems to be able to report data after dedeplication and what the last backup size was. I am interested in reporting actual total data protected.
Hi, Yes I looked at that, but it only give the last backup and the bytes new. Which I beleive is after deduplication. I need to get bytes new before deduplication. I am trying to calculate the total amount of data protected. Which would mean calculating the last backup and adding the daily change to that over the retention period.
Here's a question for everyone. How does everyone else charge for Avamar backup. We are looking to offer this as a service to our customers.
there is a field in the v_actitivies_2 table on the mcdb of the utility node called "bytes scanned" for any backup job which sounds like what you want
in the avamar admin guide it describes how to setup ODBC postgres driver so you can query the MCDB directly via excel or whatever, it is very useful
the way I have done Avamar billing for MSPs is to use DPA which collects this field as "size scanned" which I rename to "size protected". There is a report which leverages a DPA source called "total size scanned MB" and it will total up protected data per client per day.
a lot of customers ask about billing on deduped data rather than protected data, however this usually turns out to be a flawed concept when you think it through
Maybe you could purchase DPA with the appropriate number of AVAMAR licenses for it and then utilize chargeback together with all of DPA's wonderful features.
DPA does not provide information regarding the total undedupped information and even if latest version 5.7 gives information about retention it still does not give the total space occupied by a client (including shared hash/chunk/atomic hash etc...)
I dont understand why a SQL query could not give this information as all informations are linked together at a point or another otherwise we should not even be able to restore data from a backup.
I have wondered the same thing also, although my issue was if I delete a backup how much space can I get back. The answer is it depends on what other clients are sharing the same data, and support was unable to answer that.
Avamar is great, but it is a mystery in a box, unless you have access to internal documents. I am surprised there isn't a conspiracy theory involving how Avamar was developed from alien technology. Just joking, Avamar is superb (if sized properly).
jxtliG76io12459
25 Posts
3137
0
Posted September 15th, 2010 18:00
Hi,
There is the report function which could meet your request.
Open Avamar Administrator Console,
Tools --> Manage Reports...
select 'Activities - Bytes Protected Client' or 'Activities - Bytes Protected Client - 2'
'Run'
'Retrieve'
You could see the report of total protected data by client. also could export the report if needed.
Hope the above information would be helpful.