Storage Viewer for Backup Database Views > apt_v_job_tape_media
  
Version 10.0.01
apt_v_job_tape_media
The apt_v_job_tape_media view contains a single row for each tape media job.
Note: Backup Exec data collection does not populate this table, so keep this in mind when you use this view in a query.
Example Query
To include this view in a query so that it will work with Backup Exec data, you’ll need to use an “outer join” (as denoted with (+) in the following query).
select apt_v_job.server_name, apt_v_job.job_type, apt_v_job_tape_media.media_name, apt_v_job.client_name, to_char(apt_v_job.start_date, 'YYYY-MM-DD hh:mm:ss AM') start_date, to_char(apt_v_job.finish_date, 'YYYY-MM-DD hh:mm:ss AM') finish_date, apt_v_job.summary_status, apt_v_job_message_log.message, apt_v_job_tape_media.tape_media_id, apt_v_job.kilobytes
from apt_v_job, apt_v_job_tape_media, apt_v_job_message_log
where apt_v_job.job_id = apt_v_job_tape_media.job_id (+)
and apt_v_job.job_id = apt_v_job_message_log.job_id
and apt_v_job.server_id in (${rp.hosts})
and apt_v_job.start_date BETWEEN ${rp.startDate} AND ${rp.endDate}
ORDER BY apt_v_job.server_name, apt_v_job.start_date
 
Table 3.14 apt_v_job_tape_media
Column Name
Data Type
Description
client_id
NUMBER
Foreign key to apt_v_server for the client being backed up.
clone_id
NUMBER
Foreign key to apt_v_server_instance.
Applicable for NetWorker only.
display_name
STRING
The name that is displayed on the Hitachi Storage Viewer Web Interface for this client/server
drive_id
NUMBER
Foreign key to apt_v_tape_drive.
For NetBackup, the foreign key to apt_v_nbu_su_group_member.
This is the tape drive on which the job/tape media was mounted and written.
drive_name
STRING
Name of the tape drive
host_name
STRING
Host name associate with the client ID
job_id
NUMBER
Foreign key to apt_v_gen_job.
For NetBackup, the foreign key to apt_v_nbu_job.
For TSM, the foreign key to apt_v_tsm_job.
kilobytes
NUMBER
For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored
media_name
STRING
Native media name
tape_media_id
NUMBER
Foreign key to apt_v_tape_media.For NetBackup, foreign key to apt_v_nbu_job_state.
This is an internal ID and not the same as the tape media name/code or barcode in backup product
vendor_status
CHAR
Applicable for NetWorker only:
C = Complete
H = Head
M = Middle
T = Tail