ADSM-L

Re: Library full

2006-05-02 10:42:58
Subject: Re: Library full
From: goc <goran.k AT VIP DOT HR>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 2 May 2006 16:42:35 +0200
----- 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

<Prev in Thread] Current Thread [Next in Thread>