have you tried the script /usr/openv/netbackup/bin/goodies/available_mediaMessage was edited by:
Bob Stump

The available_media script is a shell script so you can modify it to output your desired format.

#! /bin/sh
# $Header: available_media.sh,v 1.2.24.1 2004/01/15 15:39:08 $
#
#***************************************************************************
#* $VRTScprght: Copyright 1993 - 2004 VERITAS Software Corporation, All Rights Reserved $
#***************************************************************************
#
# available_media
#
# This script can be used by an administrator as a convenient way to
# list ALL NetBackup volumes in the Media Manager volume database, and
# augment that list with information on the volumes currently "assigned"
# to NetBackup.
# The major benefit of this script is that it eliminates the need to track
# information from multiple databases and do the correlation manually.
#
# This script can be used in a crontab entry to get periodic reports of
# available media.
#
# caveat:
# this script assumes that the Media Manager database and NetBackup
# media database are both resident on the host where this script is run.
#

# =============================================================================

Hya

First, let's have a look at some definitions :
A tape might also be called a media before NetBackup uses it, if u are an english speaker. Frenchies say "bande magnetique" for tape but never use the word media
A volume is how MediaManager (yes, that's a problem of terminology since VERITAS bought OPENVISION ... guess what, soon they'll be known as SYMANTEC) calls a tape after the robotic inventory. You can see the volumes from the gui under the media view (under Media and Device Management) ! Volumes are kept in the volDB ...volmgr/database/volDB.

A media is how NetBackup calls a Volume, when it has added data on it. You can see the medias from the gui under the NBU report view through Media List report. Medias are kept in the mediaDB of the media server which wrote on the tape ...netbackup/db/media/mediaDB.

A volume is assigned when NBU tries to add data.

An assigned Volume is therefore a Media !

Exception : a volume assigned for Catalog Backup is NOT a media ...

-------------------
Soooooooo, if you want to see all the known tapes in a pool, u must use a MediaManager command line :
vmquery -a
vmquery -a -b
vmquery -a -bx
vmquery -a -W

-a : for all tapes
-m : name the specific tape
-p : specifies the pool number
-pn : pool name
-rn : robot number

vmquery does not tell you anything about data on the tapes. It might only tell u if the tape is assigned or not ... and if its a catalog tape (status 1) or a data tape (status 0)
----------------
On the other way, if you want to see only the tapes WITH data (which are therefore considered as medias), you must use a NetBackup command line :

bpmedialist -l / -L / -U
bpmedialist -U -p poolname

There you will see the tapes in the mediaDB, means all the tapes NBU tried to write on. These are considered as medias !
You can get amount of data, status of the media, and expiration date of the longest living backup on the tape.

If you want to have both information from vmquery and bpmedialist, you can create your own script or you can use available_media from .../bin/goodies/ directory

And if you want a better version of this awfull script ... just ask !

Kerk the noob

Thanks Kerk for your answers!
It's very helpful and now I've learned the right terms.

Regards,
jerome

Bob,

This command answer my question, because I see really all media (in and out robot). It exactly what I need.
Thanks a lot for your tips.

Regards,
jerome