Hi,
First, try to avoid select statements against backup table since it take
some time to run... (and nobody mentioned it...)
Second, look at http://people.bu.edu/rbs/ADSM.QuickFacts, there are alot of
SQL links at the end.
Third, try select node_name, filespace_name, substr(cast(backup_end as
char(26)),1,10) as "Last Backup Date" from filespaces where backup_end
<current_timestamp - 24 hours order by "Last Backup Date". You can include
'and backup_end >current_timestamp -XYZ hours' if you want to narrow it.
//Henrik
Moses Show
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
TPAUL.COM> cc: (bcc: Henrik Wahlstedt)
Sent by: Subject: Re: Using select statements
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>
2004-06-30
13:58
Please
respond to
"ADSM: Dist
Stor Manager"
Hi,
I forgot to include the select statement that I have written. It takes the
following form.
"select node_name, filespace_name, date(backup_date) from backups where
((days(backup_date) - days(current_date))) >=-3"
==============================================================================
This communication, together with any attachments hereto or links contained
herein, is for the sole use of the intended recipient(s) and may contain
information that is confidential or legally protected. If you are not the
intended recipient, you are hereby notified that any review, disclosure,
copying, dissemination, distribution or use of this communication is
STRICTLY PROHIBITED. If you have received this communication in error,
please notify the sender immediately by return e-mail message and delete
the original and all copies of the communication, along with any
attachments hereto or links herein, from your system.
==============================================================================
The St. Paul Travelers e-mail system made this annotation on 06/30/2004,
07:54:24 AM.
-------------------------------------------------------------------
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.
