Column Name | Data Type | Description |
access_type | CHAR | This is an enumeration field with the following values: O = Unknown V = Private P = Public |
access_type_name | STRING | Access type name |
backup_id | STRING | HP Data Protector backup ID |
backup_specification_id | NUMBER | Internal Id for the backup specification (see apt_v_hpd_backup_schedule) |
backup_specification_name | STRING | Backup specification name (see apt_v_hpd_backup_schedule) |
catalog_retention | STRING | Catalog retention |
client_id | NUMBER | Foreign key of the client ID for the HPDP client (see apt_v_server) |
client_name | STRING | Client host name |
copy_id | STRING | Copy ID |
data_protection | STRING | Data protection |
description | STRING | Description |
DISKAGENT_ID | NUMBER | The Diskagent_ID is used to uniquely identify the backup object-session combination. |
drive_id | NUMBER | Internal ID for the drive that was used to backup the job (see apt_v_tape_drive) |
duration | NUMBER | Duration in Hour, Minute, Second |
ENCRYPTED | STRING | The encryption status of the backed up object. |
finish_date | DATE | Date/time that the job completed |
is_active | CHAR | Y=Yes, N=No |
job_bitflags | RAW | This is a bit field that can be “OR’ed” to represent the following bitwise variables |
job_id | NUMBER | Unique job ID. Primary key in this view. This is internal job ID and NOT the same as the HPDP Job ID. |
job_type | NUMBER | Enumeration field with the following possible values: 601 = Full backup 602 = Incremental backup 603 = Incremental One backup 604 = Incremental Two backup 605 = Incremental Three backup 606 = Incremental Four backup 607 = Incremental Five backup 608 = Incremental Six backup 609 = Incremental Seven backup 610 = Incremental Eight backup 611 = Incremental Nine backup 612 = Diff 698 = Restore 699 = Other |
job_type_name | STRING | Job type name |
kilobytes | NUMBER | For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored |
mb_per_min | NUMBER | Mega bytes per minute |
media_type | CHAR | D=Disk based backup, T=Tape based backup |
mountpoint | STRING | mount point |
nbr_of_errors | NUMBER | Number of errors |
nbr_of_files | NUMBER | Number of files affected by the HPDP job |
nbr_of_warnings | NUMBER | Number of warnings |
OBJECT_BACKUP_TYPE | STRING | The type of Backup Object, What sort of object is being backed up. The currently available object backup types are: filesystem - File System winfs - Windows File System rawdisk - Disk Image sap - SAP R/3 oracle8 - Oracle informix - Informix Server msese - Microsoft Exchange Server 2007 e2010 - Microsoft Exchange Server 2010/1013 mssql - Microsoft SQL Server lotus - Lotus Notes/Domino Server mbx - Microsoft Exchange Server single mailbox sapdb - SAO Max DB msvssw - Microsoft Shadow Copy Service db2 - DB2 sybase - Sybase mssharepoint - Microsoft SharePoint 2007/2010 Server veagent - Virtual Environment idb - Internal Database |
object_type | NUMBER | This is an enumeration field with the following values: 0 = Unknown 1 = filesystem 2 = winfs 3 = omnidb 4 = rawdisk 5 = sap 6 = sapdb 7 = stream 8 = oracle8 9 = mssql 10 = msexchange 11 = mbx 12 = informix 13 = sybase 14 = lotus 15 = vss 16 = db2 17 = IDB |
object_type_name | STRING | Object Type Name |
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 |
product_type_name | STRING | Product type name |
server_id | NUMBER | Foreign key of the server ID for the HPDP Cell Manager server (see apt_v_server) |
server_name | STRING | Server host name |
session_id | NUMBER | Internal ID for HPDP session |
session_name | STRING | HPDP Session Name |
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 This field can be inspected to determine the overall summary status of a job. |
vendor_job_id | STRING | HPDP job ID |
vendor_state | NUMBER | Native HPDP job state codes. This is an enumeration field with the following values: 0 = Job has been closed / completed 1 = Job is running / in-process 2 = Job has Failed 3 = Other |
vendor_state_name | STRING | Vendor state name |
vendor_status | NUMBER | Native HPDP status code |
vendor_status_name | STRING | Vendor status name |
VM_NAME | STRING | The name of the Virtual Machine. |
VM_PATH | STRING | VM Path is the complete virtual machine path. |
VM_UUID | STRING | The instance UUID of the virtual machine. |