Column Name | Data Type | Description |
controlling_server_id | NUMBER | Foreign key to apt_v_server for the media server that is controlling the library. |
controlling_server_name | STRING | Name of the controlling server. |
device_name | STRING | Full pathname to the device that is controlling the tape drive |
drive_id | NUMBER | Foreign key to apt_v_tape_drive. For NetBackup, foreign key to apt_v_nbu_su_group_member. |
drive_in_use | CHAR | Y=Yes, N=No |
drive_name | STRING | Name of the tape drive as reported by the backup product |
drive_status | STRING | U = Online, D = Offline |
library_id | NUMBER | Foreign key to apt_v_tape_library. For NetBackup, foreign key to apt_v_nbu_tape_library. |
library_name | STRING | Name of the library that controls the drive |
management_server_id | NUMBER | Foreign key to apt_v_server for the library’s management server. |
management_server_name | STRING | Name of the library’s management server |
product_type | NUMBER | Enumeration field with the following possible values: 1 –Veritas NetBackup 2 – Veritas Backup Exec 3 – EMC NetWorker 4 – IBM Tivoli Storage Manager 5 – Commvault Simpana 6 – HP Data Protector |
product_type_name | STRING | Descriptive name associated with the product type, as above. |
server_instance_id | NUMBER | Foreign key to apt_v_server_instance. |
status_last_updated | DATE | Last date & time the drive status was checked |
vendor_drive_status | CHAR | Vendor-specific drive status |
vendor_drive_type | NUMBER | The type of 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 |
vendor_drive_type_name | STRING | The vendor’s name for the drive type |