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:[EMAIL PROTECTED]] > Sent: Friday, December 27, 2002 8:59 AM > To: [EMAIL PROTECTED] > 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 >
