Do a "q script fsnobackup'.  I think that might be a TSM supplied script
that does what you want.  Matter of fact, do a "q script" and get
familar with the supplied scripts.  Some of them are quite useful and
others serve as a good starting point for writing your own queries.

David

>>> Moses.Show AT STPAUL DOT COM 6/30/2004 7:33:20 AM >>>
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.