Storage Viewer for Backup Database Views > apt_v_leg_job_tape_media
  
Version 10.0.01
apt_v_leg_job_tape_media
The apt_v_leg_job_tape_media view contains a single row for each NetWorker tape media. This view is specific for NetWorker environments.
Table 3.93 apt_v_leg_job_tape_media
Column Name
Data Type
Description
client_id
NUMBER
Foreign key of the client ID for the NetWorker client (See apt_v_server)
client_name
STRING
Name of the NetWorker client being backed up.
clone_date
DATE
Date/Time when the clone was taken
clone_id
NUMBER
NetWorker-specific clone ID.
clone_retention_date
DATE
Retention date/time of the clone
current_kilobytes
NUMBER
Kilobytes backed up by this drive
drive_id
NUMBER
Unique drive ID. This is the Hitachi Storage Viewer internal drive ID and NOT the same as the NetWorker drive ID
drive_name
STRING
Name of the tape drive
finish_readwrite
DATE
Date/time the drive finished to read/write
is_original
CHAR
Y=Yes, N=No
Yes means that this is the original backup.
job_id
NUMBER
Primary key in this view. This is the internal job ID, NOT the same as the NetWorker Job ID.
kilobytes
NUMBER
Kilobytes backed up for this job
start_readwrite
DATE
Date/time the drive started to read/write
status_name
STRING
The following is a list of the enumeration values:
Abort
Incomplete
Suspect (Read Error)
tape_media_id
NUMBER
Foreign key to the Tape Media (See apt_v_leg_tape_media)
transfer_rate
NUMBER
Transfer rate of this read/write.
vendor_status
STRING
The following is a list of the enumeration values:
Complete
Head
Middle
Tail
volume_pool_id
NUMBER
Unique volume pool ID. This is the Hitachi Storage Viewer internal volume pool ID and NOT the same as the NetWorker volume pool ID
volume_pool_name
STRING
Name of the volume pool that the tape media belongs to.