Re: Library full
2006-05-02 10:42:58
----- Original Message -----
From: "Meadows, Andrew" <AMeadows AT BMI DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Tuesday, May 02, 2006 4:31 PM
Subject: Library full
I have a 3584 library that us now full to the brim. I have been trying
to create a select statement that will let me move tapes that haven't
been accessed in X days out of the library. Anyone have a script like
this already? I would be happy with just identifying the tapes and
manually moving them....
Thanks in advance,
Andrew.
---
hi, if it's true that chg_time says when the tape was last changed (i mean
the data on it)
you can mingle with this ...
select volume_name,chg_time from volumes where devclass_name='LTO01G3_DC'
of course replace LTO01G3_DC with your tape devclass name
goran
|
|
|