>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          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:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 854-0975