Re: Is there a way to check past backup totals
2004-12-09 23:07:14
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stapleton, Mark
Sent: Thursday, December 09, 2004 11:00 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Is there a way to check past backup totals
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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 (stapleton AT berbee DOT com)
Berbee Information Networks
Office 262.521.5627
|
|
|