>select volume_name, cast(last_write_date as date) as "Last Write Date", >cast(last_read_date as date) as "Last Read Date" from volumes where >stgpool_name='$1' and cast(last_write_date as date)<(current_date-180 >days) and cast(last_read_date as date)<(current_date-180 days) order by $2 > >$1 will be the storage pool name, remember all caps >$2 will be the column you want to sort by > >Good luck I hope this works for you.
Mark, Thanks for the reply. There is a very interesting problem I see with the return data. I can see there are 233 tapes in that pool, all of which are in the library at the moment. StgPool Name Status # Tapes ------------------ ------------------ ----------- ARCHIVE_TPOOL FILLING 5 ARCHIVE_TPOOL FULL 228 The statement only returns 90 tapes though. What am I missing as to why those other tapes don't show up?? Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 854-0975
