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.