Hallo, I use select node_name,filespace_name,backup_end from filespaces where cast ((current_timestamp-backup_end)days as decimal(3,0))>3
mit freundlichen Grüßen Ralf Behrendt WGZ-Bank Organisation und Betrieb - IT-Systeme - Ludwig-Erhard-Alle 20 D - 40227 Düsseldorf Telefon: +49 211 778 39 15 Telefax: +49 211 778 16 02 Handy: +49 170 576 44 15 mailto:[EMAIL PROTECTED] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> schrieb am 30.06.2004 13:33:20: > Hi everyone I need some help. > Was told by a colleague that you can run queries using SQL select > statements to obtain information regarding a TSM server. > I am trying to compose a select statement to display filespaces on the > server which have not been backed up in the last three days. However I am > not too sure how to create a statement that works, particularly the part > of the statement which deals with the coding for " greater then three > days" > Hope this is clear > ============================================================================== > 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:29:28 AM.