----- Original Message ----- From: "Meadows, Andrew" <[EMAIL PROTECTED]> To: <[email protected]> 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
