Here is one select statement that will give you the last 7 days summary in MB.
select entity, cast(sum(examined) as integer)as "Objects_Examined", cast(sum(failed) as decimal(18,0)) as "Objects_Failed", cast(sum(bytes) as decimal(18,0)) as "Bytes_Backed_up", cast(sum(affected) as integer) as "Objects_Backed_up", cast((1-(cast(sum(failed) as decimal(18,3))/ sum(affected)))*100 as decimal(8,2)) as "% Success" from summary where start_time >= current_timestamp - 7 day and activity='BACKUP' group by entity Hope this helps John Stephens STORServer,Inc -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stapleton, Mark Sent: Thursday, December 09, 2004 11:00 PM To: [EMAIL PROTECTED] Subject: Re: Is there a way to check past backup totals From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes >Is There a way for me to find out the total GB that I have been backing >up each night say for the last week or two? >or even the past couple of days a select query perhaps? > >I would like to increase my disk pool and would like to check each >nights backup say for the last couple days or more. Do you have TSM accounting turned on? If so, you've got a comma-delimited file that contains daily backup/archive stats broken down by node. The file is called dsmaccnt.log. Pull up your TSM administrator's guide and search for "dsmaccnt.log". -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
