Storage Viewer for Backup Database Views > apt_v_nbu_job_tape_media
  
Version 10.0.01
apt_v_nbu_job_tape_media
The apt_v_nbu_job_tape_media view contains a single row for instance that a piece of tape media was used within a backup job, for example, if there were 10 backup jobs in the system and each job used a total of 3 tapes, then there would be 30 rows in this view.
Table 3.115 apt_v_nbu_job_tape_media
Column Name
Data Type
Description
client_id
NUMBER
Foreign key to apt_v_server for the client for which this job/media record is associated.
controlling_server_id
NUMBER
Foreign key to apt_v_server for the media server.
copy_index
NUMBER
If the backup was set to make multiple copies (inline tape copies), this column will indicate the copy index. For example, if there are 3 copies of a job, you will see copy index values of 1, 2, and 3.
drive_id
NUMBER
expiration_date
DATE
Date/time when this tape will expire
expired_copy
STRING
Y or N indicating whether the tape has expired
job_id
NUMBER
Foreign key to apt_v_nbu_job.
kilobytes
NUMBER
Number of kilobytes written to the associated tape media for the job, job_id
last_updated
DATE
Date and time last updated
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
tape_media_id
NUMBER
Foreign key to apt_v_nbu_tape_media.
tape_media_index
RAW
Index from zero that indicates the order of tapes that were used for the backup job
vault_sent_date
DATE
Date the tape was sent to the vault.
volume_group_id
NUMBER
Foreign key to the volume group that was used for this backup.
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.