I use this in an Access DB that is linked via ODBC.
SELECT Sum([SUMMARY-NYC].BYTES) AS SumOfBYTES, [SUMMARY-NYC].ENTITY,
First([SUMMARY-NYC].ADDRESS) AS FirstOfADDRESS, Sum([SUMMARY-NYC].FAILED) AS
SumOfFAILED, Min([SUMMARY-NYC].START_TIME) AS MinOfSTART_TIME,
Max([SUMMARY-NYC].END_TIME) AS MaxOf
history programs sometime in the future. You can have it if you want it.
Matt
-Original Message-
From: Bill Robb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 7:22 PM
To: [EMAIL PROTECTED]
Subject: SQL for Amount Backed up Daily:
Folks...
I'm running TSM 4.1 on an S390 s
On the site www.coderelief.com I published a select statement I use to followup
the amount of data backuped up every night. You can take a look. If you have any
comments feel free to mail me.
Michel Engels
Bill,
I use the following SQL commando to display a nodes backup amount for the last
(and in our case longest possible) backup window.
select substr(entity, 1, 16) as "Node", sum(bytes) #Bytes, sum(examined) -
#Examined from adsm.summary -
where (upper(activity)='BACKUP' and upper(substr(entity,
t Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: SQL for Amount Backed up Daily:
Folks...
I'm running TSM 4.1 on an S390 server, and have 85 clients divided into two
domains - Novell and AIX. Many of the clients run multiple backup sessions
per day.
I'
We parse the Activity log and extract the data that way.
(using Perl)
Cheers, Suad
--
On Wed, Apr 18, 2001 at 07:22:09PM -0400, Bill Robb wrote:
> Folks...
>
> I'm running TSM 4.1 on an S390 server, and have 85 clients divided into two domains
>- Novell and AIX. Many of the clients run multiple
Folks...
I'm running TSM 4.1 on an S390 server, and have 85 clients divided into two domains -
Novell and AIX. Many of the clients run multiple backup sessions per day.
I'm new to SQL, and have been trying to write the command that will show me the amount
backed up, in MB per day, per client.
