e's weirdo.' - ??
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Charles Anderson
Sent: Thursday, January 03, 2002 5:40 PM
To: [EMAIL PROTECTED]
Subject: Re: backup file list
I've got this SQL statement for backup, archive and restore stats.
&
I've got this SQL statement for backup, archive and restore stats.
"select activity,sum(bytes)/1048576*.001 from summary where activity in
('BACKUP','ARCHIVE','RESTORE') and start_tim>TIMESTAMP(CURRENT_DATE -1 DAY,
'08:00:00') group by activity order by 1"
I'm guessing that was at least partia
Does anyone have a query that will tell me the backup file lists
and the average amount of data transmitted a day?
CD DATA CORP. IDC TEAM. KIM IN YOP
14th Floor,Sam Jung Bldg.
237-11,Nonhyun-Dong,Gangnam-Gu,
Seoul,Korea 135-831
TEL: 82-2-546-3108
MOBILE: 016 9770-2032
FAX: 82-2-514-9007
