Hi, What information do you want? To check if the backups are run: q ev * * begind=-3 endd=today n=DOCCM_DB2
To check if some files are backuped, you can check backup table, but your select will take a long time to compute... That is the fun part with the backup table. Add filespace name in the select, "...from backups where node_name='STO-W24-TDP' and filespace_name='STO-LNS01.DOMLOGS'..." //Henrik -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: den 5 juni 2006 12:05 To: ADSM-L@VM.MARIST.EDU Subject: 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 ------------------------------------------------------------------- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.