Storage Viewer for Backup Database Views > apt_v_nbu_tape_drive
  
Version 10.0.01
apt_v_nbu_tape_drive
The apt_v_nbu_tape_drive view contains a single row for physical tape drive. If a single tape drive is shared across multiple media servers using Veritas NetBackup Shared Storage Option (SSO), this view will contain a single row for each unique instance of the tape drive and does not replicate the tape drive information.
Table 3.139 apt_v_nbu_tape_drive
Column Name
Data Type
Description
controlling_server_id
NUMBER
Foreign key to apt_v_server for the media server that is the primary controller for this tape drive.
Note: This field is not relevant for SSO environments
device_name
STRING
Full pathname to the device that is controlling this tape drive
drive_id
NUMBER
Foreign key to the Tape drive on which this job/tape media was mounted and written (See apt_v_nbu_su_group_member)
drive_in_use
STRING
Y=Yes, N=No.
drive_name
STRING
Name of the tape drive as reported by NetBackup
drive_status_name
STRING
The overall status of the tape drive
drive_type_name
STRING
The type of tape drive
inquiry_string
STRING
SCSI inquiry string performed by NetBackup for this tape drive.
library_id
NUMBER
Foreign key to apt_v_nbu_tape_library. This is the library that contains the tape drive.
robot_drive_index
NUMBER
Index of this tape library within the library reference by the library_id field.
serial_number
STRING
Serial number as obtained from the SCSI inquiry against the tape drive
server_id
NUMBER
Foreign key to apt_v_server for the management server for this tape drive
vendor_drive_status
STRING
This field contains the overall status of the tape drive. The following is an enumeration list of the possible values:
P=Up and Online
D=Down or Offline
O=Up and online but in Operational Mode
vendor_drive_type
NUMBER
This field contains the type of the tape drive. The following is a list of the possible enumeration values:
1=Qtr Inch
2=Half Inch
3=Half Inch-type 2
4=Half Inch-type 3
5=4MM
6=8MM
7=8MM type 2
8=8MM type 3
9=DLT
10=DLT type 2
11=DLT type 3
12=DTF
13=Optical Library
99=Other