Re: How much data is being backed up per client?
2002-12-27 10:53:02
Give this a try:
1) "SELECT ENTITY, SUM(BYTES) FROM SUMMARY WHERE ACTIVITY='BACKUP' AND
START_TIME BETWEEN 'YYYY-MM-DD HH:MM:00.000000' AND 'YYYY-MM-DD
HH:MM:00.000000' GROUP BY ENTITY"
2) "SELECT ENTITY, SUM(BYTES) FROM SUMMARY WHERE ACTIVITY='MIGRATION' AND
START_TIME BETWEEN 'YYYY-MM-DD HH:MM:00.000000' AND 'YYYY-MM-DD
HH:MM:00.000000' GROUP BY ENTITY"
Replace the 'YYYY-MM-DD HH:MM:00.000000' with your desired time range, and
you can go back as far as your "SET SUMMARYRETENTION" option allows.
Colby
> -----Original Message-----
> From: Nelson Kane [mailto:TSMUser AT AOL DOT COM]
> Sent: Friday, December 27, 2002 8:59 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How much data is being backed up per client?
>
>
> Season's Greetings Tsm'ers,
> 1) Can someone tell me how to check the amount of data being
> backed up per client, and how to obtain the same info for
> previous days.
> 2) How much data was in my Disk pool before I migrated it
> all! Thanks -Kane
>
|
|
|