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