Storage Viewer for Backup Database Views > apt_v_nbu_tape_media_detail
  
Version 10.0.01
apt_v_nbu_tape_media_detail
The apt_v_nbu_tape_media_detail view contains a single row for each NetBackup tape media detail data set.
Table 3.142 apt_v_nbu_tape_media_detail
Column Name
Data Type
Description
date_assigned
DATE
Date assigned
date_created
DATE
Date created
expiration_date
DATE
Expiration date
last_mounted
DATE
Last mounted date
last_mounted_drive_id
NUMBER
last_read
DATE
Last read date
last_written
DATE
Last written date
library_id
NUMBER
Foreign key to apt_v_nbu_tape_library.
library_slot_nbr
NUMBER
Library slot number
max_mounts_allowed
NUMBER
Maximum no. of mounts allowed
media_name
STRING
Media name
media_status
STRING
Media status
nbr_of_mounts
NUMBER
Number of mounts
nbr_of_restores
NUMBER
Number of restores
product_type
NUMBER
Product Type
server_id
NUMBER
Foreign key to apt_v_server for the server managing the tape media.
tape_media_id
NUMBER
Foreign key to apt_v_nbu_tape_media.
vendor_media_status
NUMBER
Vendor media status
vendor_media_type
STRING
Vendor media type
vendor_media_type_name
STRING
Vendor Media type with the following possible values: HCART, HCART2, HCART3, DLT, SDLT, Cleaning, UNKNOWN
volume_group_id
NUMBER
Foreign key to apt_v_nbu_volume_group.
volume_group_name
STRING
Volume group name
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
volume_pool_name
STRING
Volume pool name
written_kilobytes
NUMBER
Written in Kilobytes