Backup Manager Database Views > Detailed View Descriptions (NetBackup)
  
Version 9.2.00
Detailed View Descriptions (NetBackup)
apt_v_last_nbu_backup
The apt_v_last_nbu_backup view contains a single row for the last NetBackup backup.
Table 3.94 apt_v_last_nbu_backup
Column Name
Data Type
Description
client_id
NUMBER
Foreign key to apt_v_server for the client that was backed up.
finish_date
DATE
Date/time the backup job finished
job_id
NUMBER
Foreign key to apt_v_nbu_job.
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
schedule_id
NUMBER
Foreign key to apt_v_nbu_schedule.
server_id
NUMBER
Foreign key to apt_v_server.
apt_v_nbu_client_detail
The apt_v_nbu_client_detail view provides details about the NetBackup client.
Table 3.95 apt_v_nbu_client_detail
Column Name
Data Type
Description
client_id
NUMBER
NetBackup client ID
installation_path
STRING
Installation path
last_updated
DATE
Date and time the client details were last updated in the database
patch_level
STRING
Patch level of the NetBackup client software
platform
STRING
Platform of the client
version
STRING
NetBackup version on the client
apt_v_nbu_device_media_server
The apt_v_nbu_device_media_server view provides details about the NetBackup media server.
Table 3.96 apt_v_nbu_device_media_server
Column Name
Data Type
Description
device_name
STRING
Full pathname to the device
drive_id
NUMBER
drive_in_use
STRING
Flag that indicates if the tape drive is in use
drive_index
NUMBER
Tape drive index
drive_name
STRING
Name of the tape drive, associated with the drive ID
drive_status_name
STRING
Overall drive status
drive_type_name
STRING
Type of tape drive
inquiry_string
STRING
SCSI inquiry string performed
library_id
NUMBER
Foreign key to apt_v_nbu_tape_library.
library_name
STRING
Name of the library that controls the tape drive
master_server
STRING
Master server for this tape drive
media_server
STRING
Media server that is the primary
media_sever_id
NUMBER
Foreign key of the media server ID for the Symantec NetBackup media server (see apt_v_server)
robot_drive_index
NUMBER
Index of this tape library
serial_number
STRING
Serial number as obtained from NetBackup
server_id
NUMBER
Foreign key to the apt_v_server.
vendor_drive_status
STRING
Flag indicating overall drive status
vendor_drive_type
NUMBER
Numeric code for the drive type
apt_v_nbu_dedup_job
The apt_v_nbu_dedup_job view contains a single row for each NetBackup deduplication job.
Table 3.97 apt_v_nbu_dedup_job
Column Name
Data Type
Description
client_cache_hits
NUMBER
Client Cache Hits
client_cache_hits_pct
NUMBER
Client Cache Hits Percent
client_cr_sent
NUMBER
Contents Router Sent for Client
client_dedup_ratio
NUMBER
Client Dedup Ratio
client_scanned_kb
NUMBER
Client Scanned KiB
client_stream_rate_mb_sec
NUMBER
Client Streams Rate MB/Sec
job_id
NUMBER
Job ID
server_cache_hits
NUMBER
Server Cache Hits
server_cache_hits_pct
NUMBER
Server Cache Hits Percent
server_cr_sent_kb
NUMBER
Contents Router Sent for Server
server_dedup_ratio
NUMBER
Server Dedup Ratio
server_scanned_kb
NUMBER
Server Scanned KiB
server_stream_rate_mb_sec
NUMBER
Server Streams Rate MB/Sec
apt_v_nbu_disk_pool
The apt_v_nbu_disk_pool view contains a single row for each NetBackup Disk Pool, identified by the combination of ptl_nbu_storage_unit, apt_nbu_disk_pool, and apt_nbu_disk_volume.
Table 3.98 apt_v_nbu_disk_pool
Column Name
Data Type
Description
disk_pool_id
NUMBER
Disk pool ID
disk_pool_name
STRING
Disk pool name
disk_type
STRING
Disk type
disk_volume_name
STRING
Disk volume name
external_link_id
NUMBER
External link ID
free_space_kb
NUMBER
Free space in KiB
last_updated
DATE
Date last updated
management_server_id
NUMBER
Management server ID
storage_unit_id
NUMBER
Storage Unit ID
storage_unit_label
STRING
Storage Unit label
total_capacity_kb
NUMBER
Total capacity in KiB
apt_v_nbu_disk_pool_strg_serve
The apt_v_nbu_disk_pool_strg_serve view provides details about the NetBackup disk pool storage servers.
Table 3.99 apt_v_nbu_disk_pool_strg_serve
Column Name
Data Type
Description
disk_pool_id
NUMBER
Disk pool ID
last_updated
DATE
Date last updated
storage_server_id
NUMBER
Storage Server ID
apt_v_nbu_disk_volume
The apt_v_nbu_disk_volume view provides details about the NetBackup disk volumes.
Table 3.100 apt_v_nbu_disk_volume
Column Name
Data Type
Description
cur_read_streams
NUMBER
Current Read Streams
cur_write_streams
NUMBER
Current Write Streams
disk_media_id
STRING
Disk Media ID
disk_pool_id
NUMBER
Disk Pool ID
disk_type
STRING
Disk Type
disk_volume_id
NUMBER
Disk volume ID
disk_volume_name
STRING
Disk Volume Name
external_link_id
NUMBER
External Link ID
flags
STRING
Flag List
free_space_kb
NUMBER
Free Space in KiB
last_updated
DATE
Date last updated
num_read_mounts
NUMBER
Number of Read Mounts
num_repl_sources
NUMBER
Number of Replication Sources
num_repl_targets
NUMBER
Number of Replication Targets
num_write_mounts
NUMBER
Number of Write Mounts
status
STRING
Status
storage_unit_id
NUMBER
Storage Unit ID
total_capacity_kb
NUMBER
Total Capacity in KiB
used_pct
NUMBER
Used Percent
apt_v_nbu_duplication_job
The apt_v_nbu_duplication_job view contains a single row for each NetBackup duplication job. This view is specific for Symantec NetBackup environments.
Table 3.101 apt_v_nbu_duplication_job
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 identified that has the format <client_name>_<timestamp>
client_host_name
STRING
Host name associated with the client ID
client_id
NUMBER
Foreign key to the apt_v_server for the NetBackup client.
copy_index
NUMBER
If the backup was set to make multiple copies (inline tape copies), this column will indicate the copy index
drive_id
NUMBER
duration
STRING
Duration in Hour, Minute, Second
duration_secs
NUMBER
Duration in seconds
expiration_date
DATE
For backup jobs, this is the date/time when the underlying Symantec NetBackup image will expire
finish_date
DATE
Date/time that the job completed
finished_readwrite
DATE
Date/time that the job try finished read/write.
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:
Bit 0 = Manually started job
Bit 1 = Compressed backup job
Bit 2 = DB compressed backup job
Bit 3 = Encrypted backup job
job_id
NUMBER
Foreign key to apt_v_nbu_job.
This is the StorageConsole internal job ID and NOT the same as the NetBackup Job ID.
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
kilobytes
NUMBER
For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored
master_host_name
STRING
Name of the master server
media_host_name
STRING
Media host name
media_server_id
NUMBER
Foreign key to apt_v_server for the media server.
media_type
CHAR
D=Disk based backup, T=Tape based backup
mybtes_sec
NUMBER
Megabytes per second
nbr_of_copies
NUMBER
For 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 NetBackup job
nbu_job_id
NUMBER
Symantec NetBackup Job ID
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 for the NetBackup policy.
policy_name
STRING
Descriptive name associated with the ID
policy_type_name
STRING
Native NetBackup policy type.
product_type_name
STRING
Text description of the backup product type, such as NetBackup, IBM Tivoli Storage Manager, etc.
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.
schedule_name
STRING
The name of the schedule.
schedule_type_name
STRING
The name of the schedule type
server_id
NUMBER
Foreign key to apt_v_server for the NetBackup master server.
start_date
DATE
Date/time that the job started
started_readwrite
DATE
Date/time that the job try started read/write.
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
storage_unit_label
STRING
Label for the storage unit
stream_index
NUMBER
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 NetBackup skipping some of the files in a backup
tape_kilobytes
NUMBER
Kilobytes written to the tape
tape_media_id
NUMBER
Foreign key to apt_v_nbu_tape_media.
target_client_id
NUMBER
Foreign key to apt_v_server for the target 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.
try_count
NUMBER
For backup jobs, this field contains the number of “tries” or “attempts” of the backup job
try_finish_date
DATE
Date/time that the job try completed
try_start_date
DATE
Date/time that the job try started
try_status
NUMBER
The status of the attempt
vendor_state
NUMBER
Native 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
Descriptive name of the job state
vendor_status
NUMBER
Native NetBackup status code
vendor_status_name
STRING
Descriptive name associated with the status
apt_v_nbu_image_log
The apt_v_nbu_image_log view contains a single row for each Symantec NetBackup image log.
Table 3.102 apt_v_nbu_image_log
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_id
NUMBER
Foreign key of the client ID for the NetBackup client
job_id
NUMBER
Foreign key to the unique ID for the Job to which this row is related
msg_log
STRING
Message log
server_id
NUMBER
Foreign key to the master server for which this log is associated (See apt_v_server)
trans_date
DATE
Transaction date
trans_type
STRING
Transaction type
was_successful
STRING
Y=Yes, N=No
apt_v_nbu_job
The apt_v_nbu_job view contains a single row for each Symantec NetBackup job. This view is specific for Symantec NetBackup environments. A row is inserted into this view when a job is first created (or soon thereafter) and updated as the status of the job changes over time.
Table 3.103 apt_v_nbu_job
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.
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).
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 StorageConsole internal job ID and NOT the same as the Symantec NetBackup job ID.
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
lifecycle_policy_state
NUMBER
Lifecycle policy state
master_host_name
STRING
Master host name
mbytes_sec
NUMBER
Megabytes per second
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.
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 = Symantec NetBackup
2 = Symantec Backup Exec
3 = EMC NetWorker
4 = IBM Tivoli Storage Manager
5 = CommVault Galaxy
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
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
apt_v_nbu_job_detail
The apt_v_nbu_job_detail view contains a one row for each NetBackup job try. This view is specific for Symantec NetBackup environments. A row is inserted into this view when a job is first created (or soon thereafter) and updated as the status of the job changes over time.
Table 3.104 apt_v_nbu_job_detail
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 identified that has the format <client_name>_<timestamp>
client_host_name
STRING
Name of the client.
client_id
NUMBER
Foreign key to apt_v_server for the NetBackup client.
duration
STRING
Duration in Hour, Minute, Second format
duration_secs
NUMBER
Duration in seconds
expiration_date
DATE
For backup jobs, this is the date/time when the underlying Symantec NetBackup image will expire
finish_date
DATE
Date/time that the job completed
finished_readwrite
DATE
Date/time that the job try finished read/write.
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
Foreign key to apt_v_nbu_job.
This is the StorageConsole internal job ID and NOT the same as the NetBackup Job ID.
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 as above
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
lifecycle_policy_name
STRING
Storage lifecycle policy name
lifecycle_policy_version
NUMBER
Storage lifecycle policy name
master_host_name
STRING
Name of the master server
mbytes_sec
NUMBER
Megabytes per second
media_host_name
STRING
Name of the media server
media_server_id
NUMBER
Foreign key to apt_v_server for the media server.
media_type
CHAR
D=Disk based backup, T=Tape based backup
nbr_of_copies
NUMBER
For 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 NetBackup job
nbu_job_id
NUMBER
Symantec NetBackup Job ID
parent_job_id
NUMBER
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
parent_schedule_name
STRING
Parent schedule name
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
policy_name
STRING
Name of the policy.
policy_type_name
STRING
Name of the policy type
product_type_name
STRING
Product type name
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.
schedule_name
STRING
Name of the schedule
schedule_type_name
STRING
Name of the schedule type
server_id
NUMBER
Foreign key to apt_v_server for the NetBackup master server.
start_date
DATE
Date/time that the job started
started_readwrite
DATE
Date/time that the job try started read/write.
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
storage_unit_label
STRING
Label for the 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 NetBackup skipping some of the files in a backup
target_client_id
NUMBER
Foreign key to apt_v_server for the target 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
try_count
NUMBER
For backup jobs, this field contains the number of tries or attempts of the backup job
try_finish_date
DATE
Date/time that the job try completed
try_start_date
DATE
Date/time that the job try started
try_status
NUMBER
Native NetBackup status code for each try
vendor_state
NUMBER
Native 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
Name associated with the above state
vendor_status
NUMBER
Native NetBackup status code
vendor_status_name
STRING
Name associated with the status code
apt_v_nbu_job_disk_media
The apt_v_nbu_job_disk_media view contains a row for an instance of disk media that was used within a backup job.
Table 3.105 apt_v_nbu_job_disk_media
Column Name
Data Type
Description
client_id
NUMBER
Foreign key to apt_v_server for the NetBackup client.
controlling_server_id
NUMBER
Foreign key to the media server that was used for this backup
copy_index
NUMBER
If the backup was set to make multiple copies (inline tape copies), this column will indicate the copy index
date_written
DATE
Date/Time the record was written
expiration_date
DATE
Date/time when this disk will expire
expired_copy
STRING
Y or N indicating if the disk has expired
finish_date
DATE
Date/Time the job finished
fragment_index
RAW
Fragment index
job_id
NUMBER
Foreign key to apt_v_nbu_job.
This is the StorageConsole internal job ID and NOT the same as the NetBackup Job ID.
last_updated
DATE
Date and time last updated
pathname
STRING
Path name
storage_unit_id
NUMBER
Foreign key to the NetBackup storage unit details (See apt_v_nbu_storage_unit)
written_kilobytes
NUMBER
Number of kilobytes written to this disk
apt_v_nbu_job_file
The apt_v_nbu_job_file view contains a row for each of the job and directory/filename being backed up.
Table 3.106 apt_v_nbu_job_file
Column Name
Data Type
Description
job_id
NUMBER
Foreign key to apt_v_nbu_job.
pathname
STRING
Name of the directory/file that was backed up by the job.
apt_v_nbu_job_tape_media
The apt_v_nbu_job_tape_media view contains a single row for instance that a piece of tape media was used within a backup job, for example, if there were 10 backup jobs in the system and each job used a total of 3 tapes, then there would be 30 rows in this view.
Table 3.107 apt_v_nbu_job_tape_media
Column Name
Data Type
Description
client_id
NUMBER
Foreign key to apt_v_server for the client for which this job/media record is associated.
controlling_server_id
NUMBER
Foreign key to apt_v_server for the media server.
copy_index
NUMBER
If the backup was set to make multiple copies (inline tape copies), this column will indicate the copy index. For example, if there are 3 copies of a job, you will see copy index values of 1, 2, and 3.
drive_id
NUMBER
expiration_date
DATE
Date/time when this tape will expire
expired_copy
STRING
Y or N indicating whether the tape has expired
job_id
NUMBER
Foreign key to apt_v_nbu_job.
kilobytes
NUMBER
Number of kilobytes written to the associated tape media for the job, job_id
last_updated
DATE
Date and time last updated
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
tape_media_id
NUMBER
Foreign key to apt_v_nbu_tape_media.
tape_media_index
RAW
Index from zero that indicates the order of tapes that were used for the backup job
vault_sent_date
DATE
Date the tape was sent to the vault.
volume_group_id
NUMBER
Foreign key to the volume group that was used for this backup.
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
apt_v_nbu_job_try
The apt_v_nbu_job_try view contains a single row for each NetBackup job try. This view is specific for Symantec NetBackup environments.
Table 3.108 apt_v_nbu_job_try
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 identified that has the format <client_name>_<timestamp>
client_host_name
STRING
The host name associated with the ID
client_id
NUMBER
Foreign key to apt_v_server for the backup client.
expiration_date
DATE
For backup jobs, this is the date/time when the underlying Symantec NetBackup image will expire
finish_date
DATE
Date/time that the job completed
finished_readwrite
DATE
Date/time that the job try finished read/write.
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:
Bit 0 = Manually started job
Bit 1 = Compressed backup job
Bit 2 = DB compressed backup job
Bit 3 = Encrypted backup job
job_id
NUMBER
Foreign key to apt_v_nbu_job.
This is the StorageConsole internal job ID and NOT the same as the NetBackup Job ID.
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
kilobytes
NUMBER
For backup jobs, this is the number of kilobytes in the backup. For restore jobs, this is the number of kilobytes restored
last_activity_date
DATE
The last activity date of the job
master_host_name
STRING
Name of the master server
media_host_name
STRING
Name of the media server
media_server_id
NUMBER
Foreign key to apt_v_server for the media server.
media_type
CHAR
D=Disk based backup, T=Tape based backup
nbr_of_copies
NUMBER
For 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 backup job
nbu_job_id
NUMBER
Symantec NetBackup Job ID
parent_nbu_job_id
NUMBER
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
policy_name
STRING
Name associated with the NetBackup policy ID
policy_type_name
STRING
Native NetBackup policy type.
product_type_name
STRING
Name of the backup product type
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.
schedule_name
STRING
Name of the schedule
schedule_type_name
STRING
Name of the schedule type
server_id
NUMBER
Foreign key to apt_v_server.
start_date
DATE
Date/time that the job started
started_readwrite
DATE
Date/time that the job try started read/write.
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
storage_unit_label
STRING
Label for the storage unit
stream_index
NUMBER
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 the backup skipping some of the files in a backup
summary_try_status
NUMBER
Calculated value
target_client_id
NUMBER
Foreign key to apt_v_server for the target 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
try_count
NUMBER
For backup jobs, this field contains the number of “tries” or “attempts” of the backup job
try_finish_date
DATE
Date/time that the job try completed
try_index
NUMBER
Indicates which try—that is, first try, second try, etc.
try_kilobytes
NUMBER
Kilobytes backed up by the try
try_nbr_of_files
NUMBER
Try number of files
try_start_date
DATE
Date/time that the job try started
try_status
NUMBER
The status of the attempt
vendor_state
NUMBER
Vendor-specific job state code
vendor_state_name
STRING
Text description of the job state
vendor_status
NUMBER
Vendor-specific status code
vendor_status_name
STRING
Vendor-specific status name
apt_v_nbu_lifecycle_policy
The apt_v_nbu_lifecycle_policy view describes the Lifecycle policy of the backup media
Table 3.109 apt_v_nbu_lifecycle_policy
Column Name
Data Type
Description
data_classification
STRING
Data classification
duplication_job_priority
NUMBER
Job priority
exists_in_catalog
STRING
Whether it exists in the catalog
last_updated
DATE
Date and time last updated
lifecycle_policy_id
NUMBER
Primary key in this view
lifecycle_policy_name
STRING
Lifecycle policy name
lifecycle_policy_state
STRING
State of the lifecycle policy
management_server_id
NUMBER
Foreign key from apt_v_server view
apt_v_nbu_lifecycpolicy_dest
The apt_v_nbu_lifecycpolicy_dest describes the Lifecycle destinations of the backup media.
Table 3.110 apt_v_nbu_lifecycpolicy_dest
Column Name
Data Type
Description
alternate_read_server
STRING
Alternate read server
destination_index_nbr
NUMBER
Destination index number
destination_parent_nbr
NUMBER
Destination Parent Number
destination_server_group
STRING
Destination server groups
destination_state
STRING
Destination state
last_updated
DATE
Date and time last updated
lifecycle_policy_id
NUMBER
Foreign key from apt_v_nbu_lifecycle_policy view
preserve_multilpexing
STRING
Preserve multiplexing
retention_days
NUMBER
The number of days to keep the data for backups performed
retention_level
NUMBER
Retention level
retention_type
STRING
Retention type
For NetBackup 7.1 and later:
0 = fixed
1 = capacity managed
2 = Expire after copy
3 = remote (imported) expiration date
4 = maximum snapshot rotation
5 = mirror copy
For NetBackup 6.5 and earlier:
F = fixed
S = staged capacity managed
E = expire after duplication
storage_unit_id
NUMBER
Foreign key from apt_v_nbu_storage_unit view
used_for
STRING
For NetBackup 7.1 and later:
What is it used for; possible values:
0 = backup
1 = duplication
2 = snapshot
3 = replication to remote master
4 = import
5 = backup from snapshot
6 = index from snapshot
7 = replication
For NetBackup 6.5 and earlier:
B = backup
D = duplication
volume_pool_id
NUMBER
Foreign key from apt_v_nbu_volume_pool view
apt_v_nbu_media_server
The apt_v_nbu_media_server view contains a row for each of the media server.
Table 3.111 apt_v_nbu_media_server
Column Name
Data Type
Description
media_server_id
NUMBER
Foreign key to apt_v_server for the media server.
media_server_name
STRING
Name of the media server
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
apt_v_nbu_policy
The apt_v_nbu_policy view contains a single row for each NetBackup policy. See apt_v_nbu_policy_client for details on the relationship between a NetBackup policy and its clients.
Table 3.112 apt_v_nbu_policy
Column Name
Data Type
Description
alternate_client_name
STRING
Alternate client name
backup_copy
NUMBER
Backup copy
backup_network_drives
STRING
Backup Network Drives Flag, Y = yes, N= no
bitflags
STRING
Bit flags
block_incremental
STRING
Y=Yes, N=No
checkpoint
STRING
Y=Yes, N=No
checkpoint_interval
NUMBER
Checkpoint interval
client_compress
STRING
Y=Yes, N=No
client_encrypt
STRING
Y=Yes, N=No
collect_bmr_info
STRING
Y=Yes, N=No
collect_tir_info
STRING
Collect TIR Information Flag, M = yes, with move detection, Y = yes, N = no
cross_mount_points
STRING
Y=Yes, N=No
data_classification
STRING
Data classification
data_mover_type
NUMBER
Data mover type
effective_date
DATE
Effective Date
enable_instant_recovery
STRING
Y=Yes, N=No
exists_in_catalog
STRING
Y = policy exists in NetBackup. N = policy was deleted from NetBackup.
file_restore_raw
STRING
Y=Yes, N=No
follow_nfs_mount_points
STRING
Y=Yes, N=No
generation
NUMBER
Generation
granular_restore_info
STRING
Y=Yes, N=No
is_active
CHAR
Y=Yes the policy is active in NetBackup or N=No, the policy is not active in NetBackup.
is_storage_life_policy
STRING
Y=Yes, N=No
job_priority
NUMBER
Priority given to jobs initiated from this policy
keyword
STRING
Keywords used for searching this policy
lifecycle_policy_id
NUMBER
Lifecycle policy ID
lifecycle_policy_name
STRING
Name of lifecycle policy
max_fragment_size
NUMBER
Maximum fragment size for backups executed using this policy. This value is in Mbytes
max_jobs_per_policy
NUMBER
Maximum number of jobs that can be running for this policy
multiple_streams
STRING
Y=Yes, N=No
nbu_server_group
STRING
NetBackup server group
perform_offhost_backup
STRING
Y=Yes, N=No
perform_snapshot_backup
STRING
Y=Yes, N=No
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
policy_name
STRING
Policy Name
policy_type
NUMBER
This is a bit field that can be ORed 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 jobs
policy_type_name
STRING
Name of the policy type
server_id
NUMBER
Foreign key to apt_v_server for the management server that owns this policy.
snapshot_method
STRING
Snapshot method
snapshot_method_argument
STRING
Snapshot method argument
storage_unit
STRING
Storage Label or Storage Unit Group Name
storage_unit_group_id
NUMBER
Foreign key to the storage unit group
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit
use_alternate_client
STRING
Y=Yes, N=No
use_data_mover
STRING
Y=Yes, N=No
use_virtual_machine
STRING
Y=Yes, N=No
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
apt_v_nbu_policy_client
The apt_v_nbu_policy_client view contains a single row for each NetBackup policy client.
The NetBackup policy (apt_v_nbu_policy) has a one-to-many relationship with the NetBackup policy clients (apt_v_nbu_policy_client). So, you could have one policy—for example, Weekly Full Backups—with 100 policy clients. In this example, you would have one row for the policy and 100 policy client rows.
Table 3.113 apt_v_nbu_policy_client
Column Name
Data Type
Description
client_id
NUMBER
Unique client ID
client_name
STRING
Client Name
description
STRING
This field can hold any customer-specific value for the policy-client relationship.
exists_in_catalog
CHAR
Y = policy exists in NetBackup. N = policy was deleted from NetBackup.
is_active
CHAR
Y=Yes the policy is active in NetBackup or N=No, the policy is not active in NetBackup.
job_priority
NUMBER
Priority given to jobs initiated from this policy
keyword
STRING
Keywords used for searching this policy
max_fragment_size
NUMBER
Maximum fragment size for backups executed using this policy. This value is in Mbytes.
max_jobs_per_policy
NUMBER
Maximum number of jobs that can be running for this policy
original_ip_address
STRING
The original IP address from NetBackup collection.
original_server_name
STRING
The original server name from NetBackup collection.
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
policy_name
STRING
Policy Name
policy_type
NUMBER
Possible values:
0 = Standard
1 = Proxy (for NetBackup internal use only)
2 = Non-Standard (for NetBackup internal use only)
3 = Apollo-wbak (no longer supported)
4 = Oracle
5 = Any policy type (for NetBackup internal use only)
6 = Informix-On-BAR
7 = Sybase
8 = MS-Sharepoint
9 = MS-Windows (not active)
10 = NetWare
11 = DataTools-SQL-BackTrack
12 = Auspex-FastBackup
13 = MS-Windows-NT
14 = OS/2
15 = MS-SQL-Server
16 = MS-Exchange-Server
17 = SAP
18 = DB2
19 = NDMP
20 = FlashBackup
21 = Split-Mirror
22 = AFS
23 = DFS (not an active policy type)
24 = DataStore
25 = Lotus-Notes
26 = NCR-Teradata (no longer supported)
27 = OpenVMS
28 = MPE/iX (no longer supported)
29 = FlashBackup-Windows
30 = Vault
31 = BE-MS-SQL-Server
32 = BE-MS-Exchange-Server
33 = Macintosh (not active)
34 = Disk Staging
35 = NBU-Catalog
36 = Generic (for NetBackup internal use only)
37 = CMS_DB
38 = PureDisk Export
39 = Enterprise Vault
40 = VMware (NetBackup 7.5 and later)
41 = Hyper-V (NetBackup 7.5 and later)
42 = NBU-Search (NetBackup 7.5 and later)
server_id
NUMBER
Foreign key to apt_v_server for the management server that owns this policy.
storage_unit_id
NUMBER
Foreign key to the NetBackup storage unit details apt_v_nbu_storage_unit)
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
apt_v_nbu_policy_client_aud
The apt_v_nbu_policy_client_aud view contains a single row for each NetBackup policy client audit.
Table 3.114 apt_v_nbu_policy_client_aud
Column Name
Data Type
Description
client_id
NUMBER
Foreign key to apt_v_server
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
log_date
DATE
Log date
apt_v_nbu_policy_file
The apt_v_nbu_policy_file view contains a single row for each NetBackup policy file.
Table 3.115 apt_v_nbu_policy_file
Column Name
Data Type
Description
include_exclude_flag
STRING
I or E: Include/exclude the pathname in the backup
pathname
STRING
Full directory file pathname
policy_id
NUMBER
Foreign key to apt_v_nbu_policy_file.
policy_name
STRING
Policy Name
apt_v_nbu_policy_file_log
The apt_v_nbu_policy_file_log view contains a single row for each NetBackup policy file log.
Table 3.116 apt_v_nbu_policy_file_log
Column Name
Data Type
Description
include_exclude_flag
STRING
I or E: Include/exclude the pathname in the backup
log_date
DATE
Log Date
log_operation
STRING
Log operation type
pathname
STRING
Full directory file pathname
policy_id
NUMBER
Foreign key to apt_v_nbu_policy_file.
apt_v_nbu_policy_log
The apt_v_nbu_policy_log view contains a single row for each NetBackup policy log.
Table 3.117 apt_v_nbu_policy_log
Column Name
Data Type
Description
bitflags
STRING
Bit flags
is_active
STRING
Indicates if the policy is active
job_priority
NUMBER
Priority given to initiated jobs
keyword
STRING
Key words for searching
log_date
DATE
Log date
log_operation
STRING
Log operation type
max_fragment_size
NUMBER
Maximum fragment size (in MBytes) for backups executed using this policy.
max_jobs_per_policy
NUMBER
Maximum number of jobs that can be running for this policy
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
policy_name
STRING
Policy name
policy_type
NUMBER
Policy type
server_id
NUMBER
Foreign key to apt_v_server
storage_unit_id
NUMBER
Foreign key to ptl_nbu_storage_unit
volume_pool_id
NUMBER
Foreign key to the default volume pool for this policy
apt_v_nbu_related_job
The apt_v_nbu_related_job view contains a single row for each NetBackup related job. This view is specific for Symantec NetBackup environments.
Table 3.118 apt_v_nbu_related_job
Column Name
Data Type
Description
child_job_id
NUMBER
The unique ID of a child job.
parent_job_id
NUMBER
Foreign key to apt_v_nbu_job.
summary_status
NUMBER
This is an enumeration field with the following values:
0 =successful
1 = partial / warning
2 = failed / error
apt_v_nbu_restore_backup_job
The apt_v_nbu_restore_backup_job view contains a single row for each NetBackup restore/backup job type. This view is specific for Symantec NetBackup environments.
Table 3.119 apt_v_nbu_restore_backup_job
Column Name
Data Type
Description
backup_job_id
NUMBER
The unique ID of a child job.
restore_job_id
NUMBER
Foreign key to apt_v_nbu_job.
apt_v_nbu_schedule
The apt_v_nbu_schedule view contains a single row for each NetBackup schedule. The schedules represented within this view can be frequency or calendar based schedules as represented by the selection_type field.
Table 3.120 apt_v_nbu_schedule
Column Name
Data Type
Description
day_of_month
RAW
This field contains a bit mask where each bit reflects what days of a month a calendar based schedule will execute. The following is a list of the bit patterns within this bit mask:
Bits 0-6 = Week 1, Sun-Sat
Bits 7-13 = Week 2, Sun-Sat
Bits 14-20 = Week 3, Sun-Sat
Bits 21-27 = Week 4, Sun-Sat
Bits 28-34 = Week 5, Sun-Sat
day_of_month_text
STRING
Text for days of a month a calendar based schedule will execute
day_of_week
RAW
This field contains a bit mask where each bit reflects what days of a week a calendar based schedule will execute. The following is a list of the bit patterns within this bit mask:
0 = Every Sunday
1 = Every Monday
2 = Every Tuesday
3 = Every Wednesday
4 = Every Thursday
5 = Every Friday
6 = Every Saturday
day_of_week_text
STRING
Text of days of a week a calendar based schedule will execute
end_of_month
CHAR
Y=Yes, N=No. This field will reflect the end of month flag that can be set for Calendar based schedules
exclude_dates
ARRAY
This field contains a list of DATE data types
exists_in_catalog
STRING
Y/N - Indicates if the schedule exists in the catalog
frequency
NUMBER
For frequency-based schedules, this is the interval (in seconds) between successive occurrences of the schedule
fri_end
STRING
Weekly schedule, Friday end time
fri_start
STRING
Weekly schedule, Friday start time
include_dates
ARRAY
This field contains a list of DATE data types
last_day_of_month
RAW
This field contains a bit mask where each bit reflects what last day of each month a calendar based schedule will execute. The following is a list of the bit patterns within this bit mask:
0 = Last Sunday of any month
1 = Last Monday of any month
2 = Last Tuesday of any month
3 = Last Wednesday of any month
4 = Last Thursday of any month
5 = Last Friday of any month
6 = Last Saturday of any month
last_day_of_month_text
STRING
Text for last day of each month a calendar-based schedule will execute
lifecycle_policy_id
NUMBER
Lifecycle policy ID
max_multiplex
NUMBER
NetBackup maximum multiplexing setting for this schedule
mon_end
STRING
Weekly schedule, Monday end time
mon_start
STRING
Weekly schedule, Monday start time
number_of_copies
NUMBER
Number of copies that will be made of any backup that uses this schedule.
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
retention_days
NUMBER
The number of days to keep the data for backups performed using this schedule. If the value is “9999”, this implies that the retention days is “infinite”
retry_after_runday
CHAR
Y=Yes, N=No. This field will reflect the retry after runday flag that can be set for Calendar based schedules
sat_end
STRING
Weekly schedule, Saturday end time
sat_start
STRING
Weekly schedule, Saturday start time
schedule_id
NUMBER
Foreign key to apt_v_nbu_schedule.
schedule_name
STRING
Name of the schedule
schedule_type
NUMBER
The enumeration type of the policy can be any of the following:
NetBackup 5.1
0=Full Backup
1=Cumulative Incremental Backup
2=Application Backup
3=Differential Incremental Backup
4=Archive
NetBackup 6.5
0=Full Backup
1=Differential Incremental Backup
2=Application Backup
3=Cumulative Incremental Backup
4=Archive
schedule_type_name
STRING
Schedule type name
selection_type
NUMBER
The enumeration type of the policy can be any of the following:
1=Frequency based schedule
2=Calendar based schedule
server_group_name
STRING
Server group name
start_window
ARRAY
This field contains an array/list of custom objects of type: weeklyScheduleType. The weeklyScheduleType type contains the following 14 attributes:
• sunWindowStart (number)
• sunWindowFinish (number)
• monWindowStart (number)
• monWindowFinish (number)
• tueWindowStart (number)
• tueWindowFinish (number)
• wedWindowStart (number)
• wedWindowFinish (number)
• thuWindowStart (number)
• thuWindowFinish (number)
• friWindowStart (number)
• friWindowFinish (number)
• satWindowStart (number)
• satWindowFinish (number)
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_schedule_log.
sun_end
STRING
Weekly schedule, Sunday end time
sun_start
STRING
Weekly schedule, Sunday start time
synthetic
STRING
Is Synthetic? = Y or N
thu_end
STRING
Weekly schedule, Thursday end time
thu_start
STRING
Weekly schedule, Thursday start time
tue_end
STRING
Weekly schedule, Tuesday end time
tue_start
STRING
Weekly schedule, Tuesday start time
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
volume_pool_name
STRING
Name of the volume pool
wed_end
STRING
Weekly schedule, Wednesday end time
wed_start
STRING
Weekly schedule, Wednesday start time
apt_v_nbu_schedule_copy
The apt_v_nbu_schedule_copy view contains a single row for each NetBackup schedule copy.
Table 3.121 apt_v_nbu_schedule_copy
Column Name
Data Type
Description
copy_index
NUMBER
A small number, from 0 indicating which copy of a schedule this is.
fail_on_error
STRING
A flag indicating if a backup should be considered a failure.
policy_id
NUMBER
Foreign key to the apt_v_nbu_policy view.
retention_days
NUMBER
The number of days to keep the data for backups performed using this schedule. If the value is 9999, this implies that the retention days is infinite.
retention_level
NUMBER
A number flag indicating the amount of time to retain backups created by jobs with this schedule.
schedule_id
NUMBER
Foreign key to the published view, apt_v_nbu_schedule.
schedule_name
STRING
Name of the schedule.
schedule_type
NUMBER
The enumeration type of the policy can be any of the following:
0=Full Backup
1=Cumulative Incremental Backup
2=Application Backup
4=Differential Incremental Backup
5=Archive
schedule_type_name
STRING
Schedule type name.
storage_unit_id
NUMBER
Foreign key to the published view, apt_v_nbu_storage_unit.
volume_pool_id
NUMBER
Foreign key to the published view apt_v_nbu_volume_pool.
volume_pool_name
STRING
Name of the volume pool.
apt_v_nbu_schedule_log
The apt_v_nbu_schedule_log view contains a single row for each NetBackup schedule log.
Table 3.122 apt_v_nbu_schedule_log
Column Name
Data Type
Description
exclude_dates
ARRAY
This field contains a list of DATE data types
frequency
NUMBER
For frequency-based schedules, this is the interval (in seconds) between successive occurrences of the schedule
include_dates
ARRAY
This field contains a list of DATE data types
max_multiplex
NUMBER
NetBackup maximum multiplexing setting for this schedule
number_of_copies
NUMBER
Number of copies that will be made of any backup that uses this schedule.
policy_id
NUMBER
Foreign key to apt_v_nbu_policy.
retention_days
NUMBER
The number of days to keep the data for backups performed using this schedule. If the value is “9999”, this implies that the retention days is “infinite”
schedule_id
NUMBER
Foreign key to apt_v_nbu_schedule.
schedule_name
STRING
Name of the schedule
schedule_type
NUMBER
The enumeration type of the policy can be any of the following:
NetBackup 5.1
0=Full Backup
1=Cumulative Incremental Backup
2=Application Backup
3=Differential Incremental Backup
4=Archive
NetBackup 6.5
0=Full Backup
1=Differential Incremental Backup
2=Application Backup
3=Cumulative Incremental Backup
4=Archive
selection_type
NUMBER
The enumeration type of the policy can be any of the following:
1=Frequency based schedule
2=Calendar based schedule
start_window
ARRAY
This field contains an array/list of custom objects of type: weeklyScheduleType. The weeklyScheduleType type contains the following 14 attributes:
• sunWindowStart (number)
• sunWindowFinish (number)
• monWindowStart (number)
• monWindowFinish (number)
• tueWindowStart (number)
• tueWindowFinish (number)
• wedWindowStart (number)
• wedWindowFinish (number)
• thuWindowStart (number)
• thuWindowFinish (number)
• friWindowStart (number)
• friWindowFinish (number)
• satWindowStart (number)
• satWindowFinish (number)
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
apt_v_nbu_slp_job
The apt_v_nbu_slp_job view contains a single row for each NetBackup SLP job.
Table 3.123 apt_v_nbu_slp_job
Column Name
Data Type
Description
copy_job_id
NUMBER
Copy job ID
copy_number
NUMBER
Copy number
copy_state
NUMBER
Copy state
copy_type
NUMBER
Copy type
data_format
STRING
Data format
destination_index_number
NUMBER
Destination Index Number
expiry_date
DATE
Expiration date
job_id
NUMBER
Foreign Key from apt_v_job
last_retry_date
DATE
Last retry date
last_updated
DATE
Date and time last updated in the database
mpx_state
STRING
MPX state
retry_count
NUMBER
Retry count
apt_v_nbu_storage_server
The apt_v_nbu_storage_server view contains a single row for each NetBackup storage server.
Table 3.124 apt_v_nbu_storage_server
Column Name
Data Type
Description
flags
STRING
Flag list
last_updated
DATE
Last update date
state
STRING
State
storage_server_id
NUMBER
Storage server ID
storage_server_name
STRING
Storage server name
storage_server_type
STRING
Storage server type
storage_type
STRING
Storage type
apt_v_nbu_storage_unit
The apt_v_nbu_storage_unit view contains a single row for each NetBackup Storage Unit. This view does not contain storage unit group information.
Table 3.125 apt_v_nbu_storage_unit
Column Name
Data Type
Description
concurrent_jobs
NUMBER
Number of concurrent NetBackup jobs that can be running at any one time using this storage unit
exists_in_catalog
STRING
Y=Yes, N=No
host_server_id
NUMBER
Foreign key to apt_v_server for the controlling server for this storage unit
library_number
NUMBER
Unique NetBackup library number for a given master server
library_type
NUMBER
Enumeration field type with the following possible values:
1=Auto Cart System
2=Management Facility
3=Optical Library
4=Removable Storage Manager
5=4MM
6=8MM
7=DLT
8=Half-Inch
9=Multimedia
10=Half Inch Tape Stacker
11=DLT Tape Stacker
12=8MM Tape Stacker
master_external
STRING
External or display name of the Master server
master_internal
STRING
Internal or hostname of the Master server
max_fragment_size
NUMBER
Maximum size of each fragment of data written to this storage unit. This value is in Mbytes
max_multiplex
NUMBER
NetBackup Maximum Multiplexing setting for this storage unit
media_external
STRING
External or display name of the Media or controlling server
media_internal
STRING
Internal or hostname of the Media or controlling server
media_type
NUMBER
The enumeration media type for this storage unit, with the following possible values:
0 = Default
1 = Qtr Inch Cart (QCART)
2 = Half Inch Cart (HCART)
3 = Half Inch Cart Type 2 (HCART2)
4 = Half Inch Cart Type 3 (HCART3)
5 = 4MM
6 = 8MM
7 = 8MM2
8 = 8MM3
9 = DLT
10 = DLT2
11 = DLT3
12 = DTF
13 = Optical Disk
14 = Worm Disk
15 = AIT3
number_of_drives
NUMBER
Number of drives in this storage unit
on_demand
CHAR
Flag to indicate if this storage unit is “on demand only.” Y=Yes, N=No
pathname
STRING
Absolute pathname for disk or disk-staging storage units
server_id
NUMBER
Foreign key to apt_v_server for the management server to which this storage unit belongs.
storage_unit_id
NUMBER
Foreign key to apt_v_nbu_storage_unit.
storage_unit_label
STRING
Label for the storage unit
storage_unit_type
NUMBER
The enumeration type of a storage unit can be any of the following:
1=Disk
2=Media Manager
3=NDMP
4=Fastrax
5=Disk Staging
apt_v_nbu_storage_unit_group
The apt_v_nbu_storage_unit_group view contains a single row for each NetBackup Storage Unit group.
Table 3.126 apt_v_nbu_storage_unit_group
Column Name
Data Type
Description
storage_unit_group_id
NUMBER
Storage Unit Group ID
storage_unit_group_name
STRING
Storage Unit Group Name
management_server_id
NUMBER
Management Server ID - Foreign key to apt_v_server
apt_v_nbu_strgunit_mediasrvr
The apt_v_nbu_strgunit_mediasrvr view associates the storage unit with the media server.
Table 3.127 apt_v_nbu_strgunit_mediasrvr
Column Name
Data Type
Description
media_server_id
STRING
Foreign key of the media server ID for the Symantec NetBackup media server (see apt_v_server)
storage_unit_id
STRING
Foreign key to the NetBackup storage unit details (See apt_v_nbu_storage_unit)
apt_v_nbu_su_group_member
The apt_v_nbu_su_group_member view contains a single row for each NetBackup Storage Unit group member.
Table 3.128 apt_v_nbu_su_group_member
Column Name
Data Type
Description
storage_unit_group_id
NUMBER
Storage Unit Group ID - Foreign key to apt_v_nbu_storage_unit_group
storage_unit_id
NUMBER
Storage Unit ID - Foreign key to apt_v_nbu_storage_unit
apt_v_nbu_tape_drive
The apt_v_nbu_tape_drive view contains a single row for physical tape drive. If a single tape drive is shared across multiple media servers using Symantec NetBackup Shared Storage Option (SSO), this view will contain a single row for each unique instance of the tape drive and does not replicate the tape drive information.
Table 3.129 apt_v_nbu_tape_drive
Column Name
Data Type
Description
controlling_server_id
NUMBER
Foreign key to apt_v_server for the media server that is the primary controller for this tape drive.
Note: This field is not relevant for SSO environments
device_name
STRING
Full pathname to the device that is controlling this tape drive
drive_id
NUMBER
Foreign key to the Tape drive on which this job/tape media was mounted and written (See apt_v_nbu_su_group_member)
drive_in_use
STRING
Y=Yes, N=No.
drive_name
STRING
Name of the tape drive as reported by NetBackup
drive_status_name
STRING
The overall status of the tape drive
drive_type_name
STRING
The type of tape drive
inquiry_string
STRING
SCSI inquiry string performed by NetBackup for this tape drive.
library_id
NUMBER
Foreign key to apt_v_nbu_tape_library. This is the library that contains the tape drive.
robot_drive_index
NUMBER
Index of this tape library within the library reference by the library_id field.
serial_number
STRING
Serial number as obtained from the SCSI inquiry against the tape drive
server_id
NUMBER
Foreign key to apt_v_server for the management server for this tape drive
vendor_drive_status
STRING
This field contains the overall status of the tape drive. The following is an enumeration list of the possible values:
P=Up and Online
D=Down or Offline
O=Up and online but in Operational Mode
vendor_drive_type
NUMBER
This field contains the type of the tape drive. The following is a list of the possible enumeration values:
1=Qtr Inch
2=Half Inch
3=Half Inch-type 2
4=Half Inch-type 3
5=4MM
6=8MM
7=8MM type 2
8=8MM type 3
9=DLT
10=DLT type 2
11=DLT type 3
12=DTF
13=Optical Library
99=Other
apt_v_nbu_tape_library
The apt_v_nbu_tape_library view contains a single row for physical tape library.
Table 3.130 apt_v_nbu_tape_library
Column Name
Data Type
Description
controlling_server_id
NUMBER
Foreign key to apt_v_server for the media server that is controlling this library.
description
STRING
Free-form text field
device_name
STRING
Device name that controls the tape library
inquiry_string
STRING
Inquiry string returned from a SCSI inquiry
is_online
STRING
Y=Yes, N=No.
library_id
NUMBER
Foreign key to apt_v_nbu_tape_library.
library_name
STRING
Custom name that can be assigned to the library
library_type
STRING
The type of the library as reported by NetBackup, such as Optical Library or DLT Tape Library
master_host_name
STRING
Name of the master host server
media_capacity
NUMBER
Total number of tapes that could be loaded within this tape library
media_host_name
STRING
Name of the media server
nbr_of_drives
NUMBER
Number of tape drives within the tape library
serial_number
STRING
Serial number of the tape library as returned from a SCSI inquiry
server_id
NUMBER
Foreign key to apt_v_server for the master server for which this library is associated.
vendor_library_nbr
NUMBER
Unique number assigned by NetBackup to each library associated with a master server
apt_v_nbu_tape_media
The apt_v_nbu_tape_media view contains a single row for separate piece of tape media independent of the location of the media (for example, onsite or offsite).
Table 3.131 apt_v_nbu_tape_media
Column Name
Data Type
Description
bar_code
STRING
Bar code number
date_assigned
DATE
NetBackup tape assignment date
date_created
DATE
NetBackup creation date
estimated_mbyte_capacity
NUMBER
Estimated tape capacity in MBytes
expiration_date
DATE
Date/time when this tape will expire
first_mounted
DATE
Date and time the tape was first mounted
last_header_offset
NUMBER
Last header offset
last_mounted
DATE
Date/time the tape was last mounted
last_mounted_drive_id
NUMBER
Foreign key to the tape drive ID that last mounted this piece of tape media
last_read
DATE
Date/time the last read operation was performed on this tape
last_written
DATE
Date/time the tape was last written to
library_id
NUMBER
Foreign key to the Tape Library that contains this piece of tape media (See apt_v_nbu_tape_library)
library_slot_nbr
NUMBER
Slot number within the tape library. This will be NULL for off-site tapes or tapes that are not within a library
max_mounts_allowed
NUMBER
Maximum mounts allowed
media_description
STRING
Media description
media_name
STRING
NetBackup Tape Media ID
media_role
STRING
Media role
media_status
STRING
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
nbr_of_images
NUMBER
Number of images
nbr_of_mounts
NUMBER
Number of discrete mount operations on this tape media since the tape was first assigned to NetBackup
nbr_of_restores
NUMBER
Number of restores performed on this piece of tape media
nbr_of_valid_images
NUMBER
Number of valid images
optical_header_size
NUMBER
Optical header size in bytes
optical_partition_size
NUMBER
Optical partition size in bytes
optical_sector_size
NUMBER
Optical sector size in bytes
product_type
NUMBER
Enumeration field with the following possible values:
1 – Symantec NetBackup
2 – Symantec Backup Exec
3 – EMC NetWorker
4 – IBM Tivoli Storage Manager
5 – CommVault Galaxy
6 – HP Data Protector
retention_level
NUMBER
Retention level
server_id
NUMBER
Foreign key to the master server that is managing this tape media (See apt_v_server)
tape_media_id
NUMBER
Foreign key to apt_v_nbu_tape_media.
vault_container_id
STRING
Vault container ID
vault_name
STRING
Name of the tape vault
vault_return_date
DATE
Vault return date
vault_sent_date
DATE
Vault sent date
vault_session_id
STRING
Vault session ID
vault_slot
STRING
Vault slot
vendor_media_status
NUMBER
This field contains the media status. The following is a list of the enumeration values:
0 = Unknown
1 = Free / Scratch
2 = Assigned
3 = Frozen
4 = Suspended
5 = Imported
6 = Full
7 = Expired
8 = Catalog Backup Tape
9 = Cleaning Tape
vendor_media_type
NUMBER
This field contains one of the following enumeration values:
0 = Default
1 = Qtr Inch Cart (QCART)
2 = Half Inch Cart (HCART)
3 = Half Inch Cart Type 2 (HCART2)
4 = Half Inch Cart Type 3 (HCART3)
5 = 4MM
6 = 8MM
7 = 8MM2
8 = 8MM3
9 = DLT
10 = DLT2
11 = DLT3
12 = DTF
13 = Optical Disk
14 = Worm Disk
15 = AIT3
100 = Other / Unknown
101 = DLT Cleaning Tape
102 = 8MM Cleaning Tape
103 = 4MM Cleaning Tape
104 = Half-Inch Cleaning Tape
105 = DTF Cleaning Tape
volume_group_id
 
Foreign key to apt_v_nbu_volume_group for which this tape media is a member
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool for which this tape media is a member
written_kilobytes
NUMBER
Number of kilobytes written to this tape
apt_v_nbu_tape_media_detail
The apt_v_nbu_tape_media_detail view contains a single row for each NetBackup tape media detail data set.
Table 3.132 apt_v_nbu_tape_media_detail
Column Name
Data Type
Description
date_assigned
DATE
Date assigned
date_created
DATE
Date created
expiration_date
DATE
Expiration date
last_mounted
DATE
Last mounted date
last_mounted_drive_id
NUMBER
last_read
DATE
Last read date
last_written
DATE
Last written date
library_id
NUMBER
Foreign key to apt_v_nbu_tape_library.
library_slot_nbr
NUMBER
Library slot number
max_mounts_allowed
NUMBER
Maximum no. of mounts allowed
media_name
STRING
Media name
media_status
STRING
Media status
nbr_of_mounts
NUMBER
Number of mounts
nbr_of_restores
NUMBER
Number of restores
product_type
NUMBER
Product Type
server_id
NUMBER
Foreign key to apt_v_server for the server managing the tape media.
tape_media_id
NUMBER
Foreign key to apt_v_nbu_tape_media.
vendor_media_status
NUMBER
Vendor media status
vendor_media_type
STRING
Vendor media type
vendor_media_type_name
STRING
Vendor Media type with the following possible values: HCART, HCART2, HCART3, DLT, SDLT, Cleaning, UNKNOWN
volume_group_id
NUMBER
Foreign key to apt_v_nbu_volume_group.
volume_group_name
STRING
Volume group name
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
volume_pool_name
STRING
Volume pool name
written_kilobytes
NUMBER
Written in Kilobytes
apt_v_nbu_volume_group
The apt_v_nbu_volume_group view contains a single row for each NetBackup Volume Group.
Table 3.133 apt_v_nbu_volume_group
Column Name
Data Type
Description
server_id
NUMBER
Foreign key to apt_v_server for the management server to which this volume group belongs.
volume_group_id
NUMBER
Foreign key to apt_v_nbu_volume_group.
volume_group_name
STRING
Name of the volume group
apt_v_nbu_volume_pool
The apt_v_nbu_volume_pool view contains a single row for each NetBackup Volume Pool. The volume pools will be a normal NetBackup volume pool or a Scratch pool (as indicated by the is_scratch flag).
Table 3.134 apt_v_nbu_volume_pool
Column Name
Data Type
Description
is_active
CHAR
Indicates if the volume pool is active or not. Y=Yes, N=No.
is_scratch_pool
CHAR
Indicates if the volume pool is a scratch pool or not. Y=Yes, N=No.
server_id
NUMBER
Foreign key to apt_v_server for the management server to which this volume pool belongs.
volume_pool_id
NUMBER
Foreign key to apt_v_nbu_volume_pool.
volume_pool_name
STRING
Name of the volume pool