Storage Viewer for Backup Database Views > apt_v_hpd_tape_media
  
Version 10.0.01
apt_v_hpd_tape_media
The apt_v_hpd_tape_media view contains a single row for each HP Data Protector tape media.
Table 3.87 apt_v_hpd_tape_media
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