Column Name | Data Type | Description |
browse_date | DATE | Browse date for the NetWorker job. |
client_id | NUMBER | Foreign key of the client ID for the NetWorker client (See apt_v_server) |
client_name | STRING | Host name of the NetWorker client being backed up. |
client_resource_id | NUMBER | Foreign key to the NetWorker client resource details |
client_resource_name | STRING | Name of the NetWorker client Resource. |
finish_date | DATE | Date/time that the job completed |
insertion_date | DATE | Insertion date of the NetWorker job. |
is_active | CHAR | Y=Yes, N=No |
is_save_group_active | CHAR | Y-Yes N-No |
job_id | NUMBER | Unique job ID. Primary key in this view. This is the Hitachi Storage Viewer internal job ID and NOT the same as the NetWorker Job ID. |
job_type | NUMBER | Enumeration field with the following possible values: 301 = Full Backup 302 = Incremental Backup 303 = Migration 304 = Manual Backup 305 = Consolidate 306 = Copy 307 = Diff 308 = 1 309 = 2 310 = 3 311 = 4 312 = 5 313 = 6 314 = 7 315 = 8 316 = 9 317 = Restore 399 = Other |
job_type_name | STRING | Enumeration field with the following possible values: Full Backup Incr Backup Migration Manual Backup Consolidate Copy Diff One Two Three Four Five Six Seven Eight Nine |
kilobytes | NUMBER | For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored |
long_saveset_id | STRING | NetWorker specific long saveset ID. Uniquely identifies the NetWorker job. |
media_type | CHAR | This is an enumeration field with the following values: D = Disk-based backup T = Tape-based backup L = Logical backup |
nbr_of_attempts | NUMBER | Numbers of attempts for the NetWorker save set. |
nbr_of_copies | NUMBER | Number of copies (instances or clones) of the NetWorker save set, all with the same save time and save set id |
nbr_of_files | NUMBER | Number of files affected by the NetWorker job |
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 |
retention_date | DATE | Retention date (expiration time) for the NetWorker job. |
save_date | DATE | NetWorker client job start time |
saveset_group_id | NUMBER | Foreign key to the NetWorker save set group details |
saveset_group_instance_id | NUMBER | Foreign key to the NetWorker save set group instance details. This would provide the historical group start time, finish time, and status. |
saveset_group_name | STRING | Name of the NetWorker save set group that the save set belongs to. |
saveset_id | NUMBER | NetWorker specific saveset ID. Uniquely identifies the NetWorker job. |
saveset_name | STRING | Name of the NetWorker saveset |
saveset_status | STRING | Native NetWorker status for the save set. |
server_id | NUMBER | Foreign key of the server ID for the NetWorker Master server (See apt_v_server) |
server_name | STRING | Name of the NetWorker master server |
start_date | DATE | Date/time that the job started |
summary_status | NUMBER | This is an enumeration field with the following values: 0 =successful 1 = partial / warning 2 = failed / error |
vendor_state | NUMBER | NetWorker job state codes. This is an enumeration field with the following values: 0 = Job is completed 1 = Job is running / in-process |
vendor_state_name | STRING | NetWorker job state names. This is an enumeration field with the following values Completed Running |
vendor_status | NUMBER | This is an enumeration field with the following values: 0 =successful 1 = partial / warning 2 = failed / error 3 = in progress |
vendor_status_name | STRING | This is an enumeration field with the following values: Successful Partial / Warning Failed In Progress |
vendor_summary_status | CHAR | This is an enumeration field with the following values: B = Browsable R = Recoverable E = Expired A = Aborted I = In Progress |
vendor_summary_status_name | STRING | This is an enumeration field with the following values: Browsable Recoverable Expired Aborted In Progress |