Storage Viewer for Backup Database Views > apt_v_leg_tape_library
  
Version 10.0.01
apt_v_leg_tape_library
The apt_v_leg_tape_library view contains a single row for each NetWorker tape library. This view is specific to NetWorker environments.
Table 3.97 apt_v_leg_tape_library
Column Name
Data Type
Description
auto_media_management_enabled
CHAR
Y = Yes, N=No
available_slots
STRING
Available slot numbers
cleaning_slot_numbers
STRING
Cleaning slot numbers
control_port_number
STRING
The path of the control port for the jukebox robotics
controlling_server_id
NUMBER
Foreign key to the media server that is controlling the library. (See apt_v_server)
controlling_server_name
STRING
Name of the controlling server.
current_operation
STRING
The operation currently being performed on the jukebox
current_operation_drive_id
NUMBER
Drive ID used by current operation.
current_operation_options
STRING
The mode of the volume used when the current operation will be performed
current_operation_slot_nbr
NUMBER
Slot number used by current operation.
default_nbr_of_cleaning
NUMBER
The number of uses assigned to a new cleaning cartridge during an inventory of a jukebox
description
STRING
Free-form text field
device_name
STRING
Device name that controls the tape library
first_slot_number
NUMBER
First slot number in the library
internal_name
STRING
Server’s internal name
is_auto_clean_devices_enabled
CHAR
Y = Yes, N=No
is_enabled
CHAR
Y = Yes, N=No
is_online
CHAR
Y = Yes, N=No
last_slot_number
NUMBER
Last slot number in the library
library_comment
STRING
Free form text field
library_id
NUMBER
Unique tape library ID.
library_name
STRING
Custom name that can be assigned to the library
loaded_slot_numbers
STRING
Slot numbers loaded.
media_capacity
NUMBER
Total number of tapes that could be loaded within this tape library.
model
STRING
The jukebox model
nbr_of_devices
NUMBER
Number of devices attached to the library
nbr_of_drives
NUMBER
Number of tape drives within the tape library
operation_error_msg
STRING
Error message from NetWorker log
read_server_id
NUMBER
ID of a read server
read_server_name
STRING
Host name that is used in selecting a storage node for recover and read side clone requests
serial_number
STRING
The serial number of the tape library
server_id
NUMBER
Foreign key to the server with which this library is associated (See apt_v_server)
use_barcode_labels
CHAR
Y = Yes, N=No
use_barcode_reader
CHAR
Y = Yes, N=No
vendor_library_nbr
NUMBER
Unique number assigned by NetWorker to each library
vendor_library_type
STRING
Vendor-specific library type name.