HI!

vmquery for one tape takes a lot of time.
Try this: vmquery into an output file.
Then work on it to awk/grep what ever u want.
I developed a fully monitoring web interface with this technique that
started with combining the two databases like that:

/usr/openv/netbackup/bin/admincmd/bpmedialist -l > /tmp/medialist
/usr/openv/volmgr/bin/vmquery -w -a | grep -v ID | grep -v media | grep : >
/tmp/mediaquery

After that you can easily have the mount time, media status, expiration
date, location (nonrobotic,robotic and where (robot,slotnumber)),size
allocated and more.

Let me know in case you are into the full script.

Boaz.


From: Darren Dunham [mailto:ddunham AT taos DOT com]
Sent: Thursday, May 23, 2002 1:32 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Finding volumes in attached libraries.


I'm writing a script to find "older" volumes that are part of an HSM
system so they may be moved out of the libraries for new tapes.

I can query HSM to give me the "last written" date on a tape.  I need
besides that a list of tapes in the robots, and possibly the "last
mount" time.

Because I have a lot of volumes, I don't think I want to feed them
one by one into 'vmquery'.  Is there a way to get a big list of all
the volumes, perhaps limited by robot (not a big deal if I can do
that in the script).

I suppose I could simply parse the 'available_media' report, but was
wondering if there were anything else that would get the information
a little bit quicker.

Thanks.

-- 
Darren Dunham                                           ddunham AT taos DOT com
Unix System Administrator                    Taos - The SysAdmin Company
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu