Try " and (start_time between current_timestamp - 24 hours and
current_timestamp)"


curtis.stewart AT lawson DOT com



"Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/12/2004 09:57 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: How long did each client take to backup?






Thanks to all who replied. ... Sofar I have

Select Entity,Start_Time,Stop_time,successful from summary -
where activity='BACKUP' order by entity

But I am having problems getting into the where clause the eqivalent of
        AND start_time > TODAY -1 at 08:00

Yes, I know the 'TODAY -1 at 08:00' syntax is wrong, but that is the
current
issue.

... Suggestions?

I am glad to post a summary for future reference when git is going if
there
is interest. (If you have interest, e-mail me directly rather than post
...
just keeps down non-list information on the list!)

-----Original Message-----
From: Coats, Jack [mailto:Jack.Coats AT BANKSTERLING DOT COM]
Sent: Thursday, August 12, 2004 6:12 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How long did each client take to backup?


Is there a query or SQL query I could run to get me that can tell me, on a
per client basis, how long the backup took from the servers perspective
for
each backup that ran in the last 24 hours?



TIA ... JC