Try " and (start_time between current_timestamp - 24 hours and
current_timestamp)"
[EMAIL PROTECTED]
"Coats, Jack" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
08/12/2004 09:57 AM
Please respond to
"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To
[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 6:12 AM
To: [EMAIL PROTECTED]
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
