Bill,
Try this instead:
select * from summary where activity like 'BACKUP' and entity like
'DOCCM_DB2' and (current_timestamp - start_time) <= 72 hours
Thanks & Regards,
Ramakrishna Choudarapu
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Dourado
Sent: Monday, June 05, 2006 6:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] SQL Help
Importance: High
Hi,
What do I need to add to this SQL statement, to only list backups done
in
the last 3 days ?
select * from backups where node_name = 'DOCCM_DB2'
I have had several unsuccessful attempts .
Thanks in Advance.
Bill
******************************* Disclaimer
*******************************
This email and any files transmitted with it contains privileged and
confidential information and is intended for the addressee only. If you
are not the intended recipient you must not disseminate, distribute or
copy this email. Please notify the sender at once that you have received
it by mistake and then delete it from your system.
Any views expressed in this email are those of the sender and not
necessarily those of ALSTEC or its associated companies.
Whereas ALSTEC takes reasonable precautions to ensure this email is
virus
free, no responsibility will be accepted by it for any loss or damage
whether direct or indirect which results from the contents of this email
or its attachments.
ALSTEC Group Limited - Registered in England No.3939840 - www.alstec.com
Registered office: Cambridge Road, Whetstone, Leicester. LE8 6LH.
England.
Telephone: +44 (0)116 275 0750
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender,
delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
|
