Re: Select for access date
2004-09-01 13:18:35
>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
|
|
|