Storage Viewer for Backup Database Views > apt_v_tape_library
  
Version 10.0.01
apt_v_tape_library
The apt_v_tape_library view contains a single row for each tape library. This view is generic for all backup environments.
Note: Backup Exec data collection does not populate this table, so keep this in mind when you use this view in a query.
Table 3.12 apt_v_tape_library
Column Name
Data Type
Description
controlling_server_id
NUMBER
Foreign key to apt_v_server, for the media server.
controlling_server_name
STRING
Name of the controlling server.
description
STRING
Free-form text field
device_name
STRING
Device name that controls the tape library
instance_name
STRING
Name of the tape library instance.
is_disk_library
CHAR
Indicates if this is a disk library
is_online
CHAR
Y = Yes, N=No
library_external_name
STRING
External library name
library_id
NUMBER
Foreign key to apt_v_tape_library.
For NetBackup, the foreign key to apt_v_nbu_tape_library.
library_name
STRING
Custom name assigned to the library
library_type
STRING
Vendor-specific library type name.
media_capacity
NUMBER
Total number of tapes that could be loaded within this tape library.
nbr_of_drives
NUMBER
Number of tape drives within the tape library
server_id
NUMBER
Foreign key to apt_v_server.
server_name
STRING
Server’s internal name
vendor_library_nbr
NUMBER
Unique number assigned to each library