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:ralf.behrendt AT wgz-bank DOT de

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 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.