Storage Viewer for Backup Database Views > apt_v_leg_disk_media
  
Version 10.0.01
apt_v_leg_disk_media
The apt_v_leg_disk_media view contains a single row for each NetWorker disk media. This view is specific for NetWorker environments.
Table 3.91 apt_v_leg_disk_media
Column Name
Data Type
Description
barcode
STRING
Barcode
disk_media_id
NUMBER
Unique Disk Media ID
expiration_date
DATE
Expiration date of media
expiration_status
STRING
Expiration status of media
first_label_date
DATE
Date when media was first labelled
instance_name
STRING
Name of the instance
last_access_date
DATE
Date media was last accessed
last_relabel_date
DATE
Date when media was re-labelled
last_updated
DATE
Date last updated
library_id
NUMBER
Foreign key to the Tape Library that contains this piece of tape media (See apt_v_tape_library)
library_name
STRING
Name of the Library
library_slot_nbr
NUMBER
Slot number of the Library
media_availability
STRING
Availability of media
media_capacity_mbytes
NUMBER
Capacity of disk media
media_name
STRING
Name of the media
media_state
STRING
State of media
media_status
STRING
Status of the media
media_type_family
STRING
Media type family
nbr_of_mounts
NUMBER
Number of mounts on media
nbr_of_recycle
NUMBER
Number of recycle
nbr_of_savesets
NUMBER
Number of save sets
percent_used
NUMBER
Percent of disk media used
read_kilobytes
NUMBER
Kilobytes read from disk media
server_id
NUMBER
Foreign key of the server ID for host details
server_instance_id
NUMBER
Unique ID for the server instance
server_name
STRING
Server internal name
vendor_disk_media_id
NUMBER
Vendor disk media ID
vendor_media_status
NUMBER
Status of vendor media
vendor_media_type
NUMBER
Type of the vendor media
volume_flags
STRING
Volume flag
volume_pool_id
NUMBER
Foreign key to the default volume pool for this disk media
volume_pool_name
STRING
Volume pool name for this disk media
written_kilobytes
NUMBER
Kilobytes written to disk media