Hi Phillip,

I like the output of this.
I do have a question.
Can you explain,  days(current_date)-days(end_time)<=1

My backups start at 20:00 and end at 05:00 the next day.  How can I capture
just this?

Thanks,
Marc




                    "Guan, Phillip"
                    <Guan_P AT VDOT DOT ST        To:     ADSM-L AT VM.MARIST 
DOT EDU
                    ATE.VA.US>             cc:
                    Sent by: "ADSM:        Subject:     Re: Select Statement
                    Dist Stor
                    Manager"
                    <ADSM-L AT VM DOT MARI
                    ST.EDU>


                    09/25/2001
                    01:53 PM
                    Please respond
                    to "ADSM: Dist
                    Stor Manager"





Hi Marc,

A sample:

select start_time,end_time,activity ,entity ,bytes as
Bytes_transfered,successful as Successful from summary where
days(current_date)-days(end_time)<=1  order by entity

Phillip