THREE PART QUESTION for "select gurus" ;-)

1.  Can someone tell me what the timespan for this summary is based on the:
start_time>timestamp(current date - 1 day,'18:00:00')

Does this mean for the last 18 hours?


2. Also, is there a way to sum the various sessions for a single node? Some
of my servers, which have Informix databases, back up logical logs all day
long and there are dozens of entries per server such as:

AFCTEST                            10252976
AFCTEST                            10252976
AFCTEST                            10252976
AFCTEST                            10252976
AFCTEST                            10252976
AFCTEST                            10252976

(((plus a zillion more of these entries)))

3. and is there a way to place BACKUPS and ARCHIVES into this select statement 
and have
separate columns for both backups and archives associated with a node on a row? 
Such as:

NODE_NAME                 BYTES_XFRD(BACKUP)  BYTES_XFRD(ARCHIVE)
------------------     --------------------   --------------------
AFCPROD1                          1234567890             1234567890
AFCPROD1                          1234567890             1234567890


Thanks -

George Lesho
Storage/System Admin
AFC Enterprises






Joe Cascanette <Joe.Cascanette AT CUMIS DOT COM>@VM.MARIST.EDU> on 10/30/2001
08:28:27 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: George Lesho/Partners/AFC)
Fax to:
Subject:  Re: script: transferred bytes per node/day ????


select ENTITY as Node_Name, BYTES as Bytes_Transferred from summary where
activity='BACKUP' and start_time>timestamp(current date - 1 day,
'18:00:00')and bytes>0


This was posted by another user, just added some fields.

Joe Cascanette
The Cumis Group Limited