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,1,12)) like upper('$1'))
and -
(date(end_time) = current_date - 1 days and time(end_time) >='19.00.00' -
or (date(end_time)=current_date and time(end_time)<='18.00.00')) group by entity

I run this as a TSM macro, the $1 is the node you want to query, if you want to
query all nodes replace the $1 with a % (procent sign).

regards Walter Ridderhof.


-----------------------------------------------------------------
ATTENTION:
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------
=========================================================================