Henrik,

 I  now got what I wanted.....thanks to you  and  Ramakrishna

Regards

Bill








Henrik Wahlstedt <SHWL AT STATOIL DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/06/2006 12:04
Please respond to "ADSM: Dist Stor Manager"

        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: [ADSM-L] SQL Help


See if you can use parts from this one..

Select Node_name, FILESPACE_NAME, LL_NAME, state,
substr(cast(BACKUP_DATE as char(26)),1,10) as "BACKUP_DATE" from backups
where node_name='STO-W24-TDP' and filespace_name='STO-LNS01.DOMLOGS' and
cast((current_timestamp-backup_date)days as integer) <3


//Henrik

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Dourado
Sent: den 5 juni 2006 12:05
To: ADSM-L AT VM.MARIST DOT 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.



******************************* 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