Hey Wanda, If this does what I think it does check out the Tivoli supplied script fsnobackup. You can pass in any number you want to find filespaces with old backup dates.
Example run fsnobackup 183. Results in seconds. Won't give you the amount of space but you will see the old stuff if you're looking to do some housekeeping. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -----Original Message----- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 1:02 PM To: [EMAIL PROTECTED] Subject: Re: Select Stmts. in TSM Here is a script that does a join; it's just std SQL syntax. /* Show filespaces not backed up in 6 months w/space on server */ /* This query runs a long time; suggest writing output to a file */ /* Also strongly recommend running in commadelimited mode */ select oc.node_name, oc.filespace_name as filespace, - physical_mb as "mbytes " , stgpool_name as stgpool, - date(fs.backup_start) as bkup_date - from occupancy oc, filespaces fs - where oc.node_name=fs.node_name - and oc.filespace_name=fs.filespace_name - and cast((current_timestamp-backup_start)days as integer)>=183 - order by stgpool_name, oc.node_name, oc.filespace_name You can't do an "outer join" (whatever that is... I'm just learning this stuff...) ************************************************************************ Wanda Prather The Johns Hopkins Applied Physics Lab 443-778-8769 [EMAIL PROTECTED] "Intelligence has much less practical application than you'd think" - Scott Adams/Dilbert ************************************************************************ -----Original Message----- From: Peppers, Holly [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 12:43 PM To: [EMAIL PROTECTED] Subject: Select Stmts. in TSM Has anybody tried to do a join in the TSM tables? I went looking thru the help utility and the manuals, but did not see the syntax of how to do this. Let me know please. Thanks. Holly L. Peppers Blue Cross & Blue Shield of Florida [EMAIL PROTECTED] Blue Cross Blue Shield of Florida, Inc., and its subsidiary and affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.