-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Mark D. Rodriguez
Sent: Tuesday, August 31, 2004 9:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Select for access date
Geoffrey,
You asked for access time which really isn't tracked but both read and
write times are so I used
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
Gill, Geoffrey L. wrote:
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
The reason the select statement only returns 90 tapes is that you asked
for only those tapes that have not been accessed for more than 6 months
(actually I used 180 days). I defined accessed as read or written in
that time period. If you wanted to make the script more flexible you
could replace
I'm wondering if anyone has a select or query that can be tailored for a
specific tape pool that will show me last access date of the tape. I have
quite a few archive tapes I want to start getting out of the library, to
make room for scratch, and would like to start by removing tapes from that
Geoffrey,
You asked for access time which really isn't tracked but both read and
write times are so I used them.
Ok this is sort of a long one. It is all one line so if you put it into
a Admin Script keep that in mind. Also, I am giving it to you as if it
where going to be a script where you
What's wrong with move media? Something like
move media * stg=somepool days=180 wherest=mountableinlib wherestatus=full
ovflo=tape racks remove=yes
Steve Harris
Queensland Health,
Brisbane Australia
[EMAIL PROTECTED] 01/09/2004 9:21:36
I'm wondering if anyone has a select or query that