Weekly Tape Removal Notification

Question

In our environment we have two pools that are currently configured for cloning. Each pool clones to a separate clone pool. Every week (Friday's) we are trying to use a scheduled/scripted DOS batch file to check these two clone pools and inform us through an e-mail to our helpdesk which clone tapes are ready for removal from our autochanger to be stored offsite. E-mail is going well, but apparently the mminfo command we have set in our batch files isn't getting any results. Could someone please look at a couple of the below commands we have created and tell me what I've missed that isn't getting us the results we need? We have a master script that sets the clone pool to AXX, and the autochanger to CG. The master script calls upon a notification script which 'should' be pulling the tape information we're looking for. mminfo -r volume,location -q 'pool=%POOL%, written > 1 KB, location=%CHANGER_NAME%, !volrecycle' My interpretation is that the above will make a short report with volume name and location. It then queries the pool (set on the master script), looks for any tape in that pool with over 1 KB of data on it, located in our autochanger CG (from the master script), and all tapes not set to recyclable. Any one know what I'm doing wrong or missing? The scripts seem to run fine, but they obviously don't as they never return any results even though there are tapes that I know fit the criteria. Please help.

dpinink_silva · Answer

Shouldn't it be 'not volrecycle' instead of '!volrecycle' ?At least in Linux that's the way it works...

dpinink_silva · Answer

Shouldn't it be 'not volrecycle' instead of'!volrecycle' ?At least in Linux that's the way it works... !volrecycle, volrecycle=false, etc... different waysto get the same thing. Oops, I forgot that... I said that because '!volrecycle' did not work here, but I found that it should have a blank space, like '! volrecycle'.

ble1 · Answer

Shouldn't it be 'not volrecycle' instead of'!volrecycle' ?At least in Linux that's the way it works... !volrecycle, volrecycle=false, etc... different ways to get the same thing.

ble1 · Answer

! stands for NOT (like & for AND). Simple test on Wintel machine:

C:\>mminfo -av -q volrecycle -r volume
mminfo: no matches found for the query
 
C:\>mminfo -av -q !volrecycle -r volume
hcrvelin.001
hcrvelin.001.RO
 
C:\>mminfo -av -q volrecycle=false -r volume
hcrvelin.001
hcrvelin.001.RO
 
C:\>mminfo -av -q "not volrecycle" -r volume
hcrvelin.001
hcrvelin.001.RO

(I was impressed that !volrecycle worked without double quotes

- I know I had troubles with that in the past. On UNIX on the other hands single quotes are recommended)

ble1 · Answer

First, make sure that use running the query (and host if other than backup server) have permission to run the query.

Next, under assumtion that you don't manually label the tapes you can get skip written part in query. If yes, change it slightly.

Last thing, add -s switch just to be safe (and if query is not run from backup server then you are missing that).

So, query should be:
%NSR_HOME%\bin\mminfo -av -s %NSR_SERVER% -q "pool=%POOL%,written>0,location=%CHANGER_NAME%,!volrecycle" -r volume,location

gilbertoe · Answer

Thank you all for your help.What I think my problem is, and I did not mention this in the original post, is that the pool that I am trying to get recognized is two words. (Axx xxxx)When I set the pool to this in the master script, DOS doesn't like two word names.Unfortunately, I believe that in order for this script to work I'll have to change the pool's name to something without any spaces in between. =(Thanks for all your replies, suggestions, and effort.

NetWorker

Was this post helpful?