Storage Viewer for Backup Database Views > apt_v_job_file
  
Version 10.0.01
apt_v_job_file
The apt_v_job_file view contains a row for each backup job.
Table 3.6 apt_v_job_file
Column Name
Data Type
Description
client_file_id
NUMBER
Foreign key to apt_v_client_file
client_id
NUMBER
Foreign key to apt_v_server for the client being backed up.
display_name
STRING
The name that is displayed on the Hitachi Storage Viewer Web Interface for this client/server
file_byte_size
NUMBER
Size of the job file
file_type
RAW
1 = file
2 = directory
4 = link
filename
STRING
Pathname and filename
host_name
STRING
Host name associated 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.
last_modified
DATE
The date of the last job file update.
owner
STRING
Owner of the file in the file system
parent_id
NUMBER
Storage Viewer internal ID for the parent of this file
tape_media_index
RAW
an index, starting from 1, indicating on which tape the file resides