Storage Viewer for Backup Database Views > apt_v_tape_media
  
Version 10.0.01
apt_v_tape_media
The apt_v_tape_media view contains a single row for separate piece of tape media independent of the location of the media (for example, onsite or offsite).
Backup Exec data collection does not populate this table, so keep this in mind when you use this view in a query.
Table 3.13 apt_v_tape_media
Column Name
Data Type
Description
instance_name
STRING
Instance name
last_updated
DATE
Last updated date
library_id
NUMBER
Foreign key to apt_v_tape_library, which contains this media.
library_name
STRING
Name of the tape library.
library_slot_nbr
NUMBER
Slot number within the tape library. This will be NULL for off-site tapes or tapes that are not within a library.
media_name
STRING
Native media name.
media_status
CHAR
This field contains the media status. The following is a list of the enumeration values:
Y = Deleted
E = Empty
D = Filling
F = Full
P = Error
X = Unavailable
C = Cleaning
V = Status in vendor media status column
media_status_name
STRING
Media status names as above.
product_type
NUMBER
Enumeration field with the following possible values:
1 - Symantec NetBackup
2 - Veritas Backup Exec
3 - EMC NetWorker
4 - IBM Tivoli Storage Manager
5 - CommVault Galaxy
6 - HP Data Protector
product_type_name
STRING
Names as above.
server_id
NUMBER
Foreign key to apt_v_server for the master server that is managing this media.
server_name
STRING
Name of the master server that is managing this media .
tape_media_id
NUMBER
Foreign key to apt_v_tape_media.
For NetBackup, the foreign key to apt_v_nbu_tape_library.
This is an internal ID and not the same as the tape media name/code or barcode in backup product.
vendor_media_status
NUMBER
Backup product specific media status codes.
vendor_media_status_name
STRING
Backup product specific media status names.
vendor_media_type
NUMBER
Codes for the media type (specific to backup product).
vendor_media_type_name
STRING
Backup product specific media type name.