Alternative to exporting the media list to txt file from GUI

[stubs]

I am trying to make our tape retrieval process easier, and part of it involves extracting the full list of media from the master server, including the pool information. Currently, I am exporting it from the java GUI to a .txt file, but this can be problematic if the order of the columns change.

Is it possible to run a unix command that would create the .txt file & send via FTP or email?

I would like the data to be aranged with each line being the next tape.. similar to this:

U40908 *NULL*

U40961 *NULL*

U40986 *NULL*

U40995 *NULL*

U41007 *NULL*

(with all the pool info etc following on the same line)

Any help would be great!

Thanks, Stuart.

[Stumpr2]

There is no NetBackup GUI equivalent for the Volume detail report. This is a command line method to get details for all tapes or a specific tape.  This can be used as a complement to other Media reports.
# cd /usr/openv/volmgr/bin
# ./vmquery -a
or
# ./vmquery -m <media_id>

[Rakesh_Khandelw]

You can try "avilable_media", which is in goodies directory . Alternatively, you can run "vmquery -w -a" but you may want to use it with awk to get the only columns you are interested in.

I usually use -

vmquery -w -a |awk '{print $1,$12}'

which gives me ID, Pool

Or you can use -

 vmquery -b -a

 bmedialist -summary

you may have to combine two outputs to get desired outputs.