Column Name | Data Type | Description |
backup_specifiation_name | STRING | Backup specification name |
backup_specification_id | NUMBER | Backup specification ID |
backup_type | NUMBER | Enumeration field with the following possible values: 1 = Full backup 2 = Incremental backup 3 = Incremental One backup 4 = Incremental Two backup 5 = Incremental Three backup 6 = Incremental Four backup 7 = Incremental Five backup 8 = Incremental Six backup 9 = Incremental Seven backup 10 = Incremental Eight backup 11 = Incremental Nine backup 12 = Diff 98 = Restore |
backup_type_name | STRING | Backup type name |
client_id | NUMBER | Foreign key of the client ID for the client scheduled to be backed up (see apt_v_server) |
client_name | STRING | Client name |
description | STRING | Description |
drive_id | NUMBER | Internal ID for tape drive (see apt_v_tape_drive) |
is_active | STRING | Y=Yes, N=No |
last_full_backup_date | DATE | Last full backup date |
last_full_backup_kb | NUMBER | Last full backup KiB |
last_incr_backup_date | DATE | Last incremental backup date |
last_incr_backup_kb | NUMBER | Last incremental backup KiB |
mount_point | STRING | Mount point |
next_backup_date | DATE | Next backup date |
next_backup_type | NUMBER | Enumeration field with the following possible values: 1 = Full backup 2 = Incremental backup 3 = Incremental One backup 4 = Incremental Two backup 5 = Incremental Three backup 6 = Incremental Four backup 7 = Incremental Five backup 8 = Incremental Six backup 9 = Incremental Seven backup 10 = Incremental Eight backup 11 = Incremental Nine backup 12 = Diff 98 = Restore |
next_backup_type_name | STRING | Next backup type name |
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 |
owner_group | STRING | Owner group |
post_exec_script_name | STRING | Post execution script name |
pre_exec_script_name | STRING | Pre execution script name |
schedule_date | DATE | Schedule date |
server_id | NUMBER | Foreign key of the server ID for the HPDP Cell Manager server (see apt_v_server) |
server_instance_id | NUMBER | Server the schedule is associated with Foreign key to apt_v_server_instance |
server_name | STRING | HPDP cell manager server name |
volume_pool_id | NUMBER | Volume pool ID |
Column Name | Data Type | Description |
description | STRING | Description of the drive |
device_name | STRING | Device Name |
disk_drive_id | NUMBER | Sequence generated Primary key |
disk_drive_name | STRING | Disk Drive Name |
drive_in_use | STRING | Y or N indicating if the drive is in use |
drive_index | NUMBER | Drive index |
drive_status | STRING | Status of the disk drive |
management_server_id | NUMBER | ID of the management server |
serial_nbr | STRING | Serial number |
vendor_drive_status | STRING | Vendor drive status |
vendor_drive_type | NUMBER | Vendor drive type |
volume_pool_id | NUMBER | Foreign key from ptl_volume_pool |
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. |
Column Name | Data Type | Description |
backup_specification_id | NUMBER | Backup specification ID |
client_id | NUMBER | Foreign key of the client ID for the client being backed up (see apt_v_server) |
end_time | DATE | Date/time that the job finished |
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 - Comm Vault Simpana 6 - HP Data Protector |
server_id | NUMBER | Foreign key of the server ID for the HPDP Cell Manager server (see apt_v_server) |
session_id | NUMBER | Internal ID for HPDP session |
start_time | 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. |
Column Name | Data Type | Description |
available_kb | NUMBER | Available KiB |
description | STRING | Description |
initialized_date | DATE | Date/Time the tape media was initialized |
last_access_date | DATE | Last access date |
last_overwrite_date | DATE | Last overwrite date |
last_write_date | DATE | Last write date |
library_id | NUMBER | Foreign key to the Tape Library that contains this tape media (See apt_v_tape_library) |
library_name | STRING | Library name |
library_slot_nbr | STRING | Library slot number |
location | STRING | Location |
media_name | STRING | Media Name |
nbr_of_errors | NUMBER | Number of errors |
nbr_of_overwrites | NUMBER | Number of overwrites |
nbr_of_writes | NUMBER | Number of writes |
protection | STRING | Protection |
session_id | NUMBER | Internal ID for HPDP session |
session_name | STRING | HPDP session name |
tape_media_id | NUMBER | Internal ID for tape media (see apt_v_tape_media) |
total_kb | NUMBER | Total KiB |
used_kb | NUMBER | Used KiB |
vendor_media_status | NUMBER | Enumeration field with the following possible values: 0 - Unknown 1 - Good 2 - Poor 3 - Fair |
vendor_media_status_name | STRING | HPDP specific media status name |
vendor_media_type | NUMBER | Enumeration field with the following possible values: 0 - Unknown 1 - File 2 - AIT 3 - DDS 4 - DLT 5 - DTF 6 - ExaByte 7 - LTO-Ultrium 8 - Optical 9 - QIC 10 - SAIT 11 - SD-3 12 - SuperDLT 13 - T3480/T4890/T9490 14 - T3480 15 - T4890 16 - T9490 17 - T3590 18 - T3592 19 - T9840 20 - T9940 21 - Tape |
vendor_media_type_name | STRING | HP Data Protector-specific Media Type Name |
volume_pool_id | NUMBER | Foreign key to the volume pool to which this tape media belongs |
volume_pool_name | STRING | Volume pool name |
Column Name | Data Type | Description |
barcode_as_label | STRING | Barcode as label |
barcode_reader | STRING | Barcode reader |
busy_drive_to_slot | STRING | Busy drive to slot |
controlling_server_id | NUMBER | Key to the media server that is controlling the library (see apt_v_server) |
controlling_server_name | STRING | Media server name |
description | STRING | Description |
device_name | STRING | Device name |
is_online | CHAR | Y=Yes, N=No |
lib_virtual | STRING | Library virtual |
library_id | NUMBER | Foreign key to the Tape Library that contains this tape media (See apt_v_tape_library) |
library_name | STRING | Library name |
media_capacity | NUMBER | Media capacity |
media_type | NUMBER | Media type |
mgmt_console_url | STRING | URL for management console |
nbr_of_drives | NUMBER | Number of drives |
nbr_of_slots | NUMBER | Number of slots in library |
san_statble_address | STRING | SAN address |
serial_number | STRING | Library serial number |
server_id | NUMBER | Foreign key of the server ID for the HP Data Protector Cell Manager server (see apt_v_server) |
server_instance_id | NUMBER | Server the directive is associated with Foreign key to apt_v_server_instance |
server_name | STRING | HP Data Protector cell manager server name |
vendor_library_nbr | NUMBER | HP Data Protector library number |
vendor_library_type | NUMBER | Enumeration field with the following possible values: 0 - Unknown 1 - Standalone 2 - Stacker 3 - SCSI-II 4 - Jukebox 5 - Filelibrary 6 - External control 7 - GRAU DAS Library 8 - storageTek ACS Library |
vendor_library_type_name | STRING | HP Data Protector specific Library Type Name |
Column Name | Data Type | Description |
available_kb | NUMBER | Available KiB |
description | STRING | Description |
initialized_date | DATE | Date/Time the tape media was initialized |
last_access_date | DATE | Last access date |
last_write_date | DATE | Last write date |
laste_overwrite_date | DATE | Last overwrite date |
library_id | NUMBER | Foreign key to the tape library that contains this piece of tape media (See apt_v_tape_library) |
library_name | STRING | Library name |
library_slot_nbr | NUMBER | Library slot number |
location | STRING | Location |
media_name | STRING | HP Data Protector media name |
media_status | CHAR | This field contains the media status. The following is a list of the enumeration values: Y = Deleted E = Empty D = Filling F = Full P = Error X = Unavailable C = Cleaning V = Status in vendor media status column |
media_status_name | STRING | Media status name |
nbr_of_errors | NUMBER | Number of errors |
nbr_of_overwrites | NUMBER | Number of overwrites |
nbr_of_writes | NUMBER | Number of writes |
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 - Comm Vault Simpana 6 - HP Data Protector |
product_type_name | STRING | Product type name |
protection | STRING | Protection |
server_id | NUMBER | Foreign key of the server ID for the HP Data Protector Cell Manager server (see apt_v_server) |
server_name | STRING | HPDP cell manager server name |
tape_media_id | NUMBER | Internal ID for HP Data Protector tape media (see apt_v_tape_media) |
total_kb | NUMBER | Total KiB |
used_kb | NUMBER | Used KiB |
vendor_media_status | NUMBER | Enumeration field with the following possible values: 0 - Unknown 1 - Good 2 - Poor 3 - Fair |
vendor_media_status_name | STRING | HP Data Protector specific media status name |
vendor_media_type | NUMBER | Enumeration field with the following possible values: 0 - Unknown 1 - File 2 - AIT 3 - DDS 4 - DLT 5 - DTF 6 - ExaByte 7 - LTO-Ultrium 8 - Optical 9 - QIC 10 - SAIT 11 - SD-3 12 - SuperDLT 13 - T3480/T4890/T9490 14 - T3480 15 - T4890 16 - T9490 17 - T3590 18 - T3592 19 - T9840 20 - T9940 21 - Tape |
vendor_media_type_name | STRING | HP Data Protector specific media type name |
volume_pool_id | NUMBER | Foreign key to the volume pool that this piece of tape to which media belongs |
volume_pool_name | STRING | Volume pool name |