I do not think it will give you correct values due to using just last session.
It will be correct for only very simple case running one incremental or full 
backup daily. It will be incorrect in case of:
- using a few backups per day (for example, running full and incremental backup 
will give you only incremental backup statistics;
- any TDP nodes, where you will see only last session statistics - it means 
nothing.

Grigori G. Solonovitch


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Saravanan Palanisamy
Sent: Wednesday, October 12, 2011 4:07 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Data change rate

The below query will give the changed data rate.


select sum(LASTSESS_RECVD)/1024/1024/1024 "Changed data in GB" from nodes

On Wed, Oct 12, 2011 at 3:53 PM, Ehresman,David E.
<deehre01 AT louisville DOT edu>wrote:

> Is there any way from the server side to get an estimate of overall client
> data change rate?
>



--
Thanks & Regards,
Sarav
Mobile: +974-3344-1538


Please consider the environment before printing this Email.

CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail 
message and any attachments hereto may be legally privileged and confidential. 
The information is intended only for the recipient(s) named in this message. If 
you are not the intended recipient you are notified that any use, disclosure, 
copying or distribution is prohibited. If you have received this in error 
please contact the sender and delete this message and any attachments from your 
computer system. We do not guarantee that this message or any attachment to it 
is secure or free from errors, computer viruses or other conditions that may 
damage or interfere with data, hardware or software.