Column Name | Data Type | Description |
backup_id | STRING | Symantec NetBackup backup ID. This is sometimes referred to as the image ID. This is the unique backup identifier that has the format <client_name>_<timestamp> |
client_host_name | STRING | Client host name |
client_id | NUMBER | Foreign key to apt_v_server for the NetBackup client. Contains the target_client_id. |
controlling_host_id | NUMBER | The host running the active process for this job. |
duration | STRING | Duration of the job |
duration_secs | NUMBER | Duration in seconds |
expiration_date | DATE | For backup jobs, this is the date and time when the underlying Symantec NetBackup image will expire. This expiration date is for successful backup jobs only, where the job_type = 101 (full backup) or 102 (incremental backup). |
fiber_transport_usage | STRING | Fiber Transport Usage 0 = LAN (Local Area Network) and 1 = FT (Fiber Transport). |
finish_date | DATE | Date/time that the job completed. |
is_active | CHAR | Y=Yes, No=No |
job_bitflags | RAW | This is a bit field that can be OR’ed to represent the following bitwise variables: Bit 0 = Manually started job Bit 1 = Compressed backup job Bit 2 = DB compressed backup job Bit 3 = Encrypted backup job |
job_id | NUMBER | Primary key for this view. This is the Hitachi Storage Viewer internal job ID and NOT the same as the Symantec NetBackup job ID. |
job_queued_reason | NUMBER | The action for which the job is waiting, or the reason that it has not yet completed. |
job_type | NUMBER | Enumeration field with the following possible values: 101 = Full backup 102 = Incremental backup 103 = Catalog backup 104 = Archive 105 = Restore 106 = Verification 107 = Duplicate 108 = Import 109 = Migration 110 = Label 111 = Media Erase 112 = Application backup 199 = Other |
job_type_name | STRING | Job type name |
keyword | STRING | Keyword used for backup 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. |
lifecycle_policy_id | NUMBER | Foreign key to apt_v_nbu_lifecycle_policy |
lifecycle_policy_state | NUMBER | Lifecycle policy state |
master_host_name | STRING | Master host name |
mbytes_sec | NUMBER | Megabytes per second |
media_server_id | NUMBER | This ID identifies the media server that is associated with the NetBackup job. |
media_type | CHAR | D=Disk based backup, T=Tape based backup. |
nbr_of_copies | NUMBER | For Symantec NetBackup backup jobs, this field contains the number of copies that were made of the backup |
nbr_of_files | NUMBER | Number of files affected by the Symantec NetBackup job. |
nbu_job_id | NUMBER | Symantec NetBackup job ID. |
off_host_type | STRING | Off Host Type. |
optimization_percentage | NUMBER | Percentage of optimization achieved by the NetBackup Job Accelerator. |
origin_master_server_id | NUMBER | Foreign key from apt_v_server |
origin_master_server_name | STRING | Name of the originating master server for SLP |
parent_nbu_job_id | NUMBER | Symantec NetBackup parent job ID. This is normally NULL but may exist for certain parent/child jobs such as multi-streaming jobs or database backup jobs |
policy_id | NUMBER | Foreign key to apt_v_nbu_policy. |
primary_copy_number | NUMBER | Specifies which copy is primary copy |
product_type | NUMBER | Code indicating the product type. 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 |
product_type_name | STRING | Product type name |
restore_media_server_id | NUMBER | Media server ID for restore jobs |
sched_start_date | DATE | For a backup job, this is the date/time that the job was scheduled to start |
schedule_id | NUMBER | Foreign key to apt_v_nbu_schedule. |
server_id | NUMBER | Foreign key to apt_v_server for the NetBackup master server. |
start_date | DATE | Date/time that the job started. |
storage_unit_id | NUMBER | Foreign key to apt_v_nbu_storage_unit. |
stream_index | NUMBER | Symantec NetBackup stream index for multi-streaming jobs. This column is normally 0 for non-multi-streaming jobs |
summary_status | NUMBER | This is an enumeration field with the following values: 0 =successful 1 = partial / warning 2 = failed / error This field can be inspected to determine the overall summary status of a job. If the job was a backup and the summary status was 1 (partial), this is a result of Symantec NetBackup skipping some of the files in a backup. |
target_client_id | NUMBER | Foreign key to apt_v_server for the NetBackup client. This field should only be used for restore jobs and contains the target client for a restore (i.e., Destination client). The client_id column above is the source and the server_id is the media server that performed the restore |
total_sent_kilobytes | NUMBER | Number of bytes NetBackup (bpdbjobs) reports as being sent by Job Accelerator after being converted to kilobytes. |
try_count | NUMBER | For backup jobs, this field contains the number of “tries” or “attempts” of the backup job |
vendor_job_type | NUMBER | Enumeration field representing the following values: 0 = Backup 1 = Archive 2 = Restore 3 = Verify 4 = Duplication 5 = Import 6 = Catalog Backup 7 = Vault 8 = Label 9 = Media Erase |
vendor_state | NUMBER | Native Symantec NetBackup job state codes. This is an enumeration field with the following values: 0 = Job is queued 1 = Job is running / in-process 2 = Job has been re-queued 3 = Job has been closed / completed 4 = Job has been closed / deleted 5 = No client software installed 6 = Job is pending |
vendor_state_name | STRING | State name associated with the above values |
vendor_status | NUMBER | Native NetBackup status code. |
vendor_status_name | STRING | Name associated with the status code |