Storage Viewer for Backup Database Views > apt_v_tape_drive_log
  
Version 10.0.01
apt_v_tape_drive_log
The apt_v_tape_drive_log view provides tape drive log details.
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.11 apt_v_tape_drive_log
Column Name
Data Type
Description
drive_id
NUMBER
Foreign key to apt_v_tape_drive.
For NetBackup, foreign key to apt_v_nbu_su_group_member.
drive_name
STRING
Name of the tape drive
drive_status
STRING
TSM:
In-Use
Mounting
Dismounting
Empty
NetBackup:
Up
Down
Up Opr Mode
NetWorker:
Offline
Online
HP DataProtector
Disabled
Online
in_use
CHAR
Y=Yes, N=No
is_online
CHAR
Y=Yes, N=No
media_name
STRING
Native media name
poll_time
DATE
The time that this drive was polled and status collected
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
The descriptive name associated with the product type, as above.
tape_media_id
NUMBER
Foreign key to apt_v_tape_media.
For NetBackup, the foreign key to apt_v_nbu_tape_media.
This is an internal ID and not the same as the tape media name/code or barcode in backup product.