Announcement Banner
UNSOLVED

decsnz

updated

16 years ago

D

decsnz

3 Posts

0

10606

September 15th, 2010 17:00

calculating total client data protected

Hi,

  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.

  • 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.

  • decsnz

    3 Posts

    3137

    0

    Posted September 15th, 2010 21:00

    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.

    Cheers

  • JasonBailey

    147 Posts

    3137

    0

    Posted September 16th, 2010 02:00

    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

  • joka2

    1 Rookie

    •

    144 Posts

    3137

    0

    Posted September 20th, 2010 02:00

    I'm also working on a billing system for Avamar backups and we want to bill the total amount of data the client stores on the storage for Avamar.

    I haven't figured out yet how to sum that up.

    Johannes

  • JasonBailey

    147 Posts

    3137

    0

    Posted September 23rd, 2010 03:00

    Johannes

    Its pretty much impossible, currently.

  • chrisvemc

    50 Posts

    3137

    0

    Posted September 28th, 2010 19:00

    DPA offers chargeback.

    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.

  • JasonBailey

    147 Posts

    3149

    0

    Posted September 28th, 2010 20:00

    DPA can't do chargeback on the amount of data stored on Avamar for a single client, as this is not recorded in Avamar itself.

    DPA can do chargeback on "size protected" though

  • 3149

    0

    Posted September 30th, 2010 00:00

    Actually 'Bytes Protected' means the logical data backed up before dedup. That does not mean the physical bytes stored on Avamar server.

  • kddidsm

    10 Posts

    3149

    0

    Posted January 5th, 2011 02:00

    Same issue here...

    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.

  • aj2546

    49 Posts

    1042

    0

    Posted January 5th, 2011 06:00

    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).