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 |
is_tape_on_hold | STRING | Indicates an override of existing retention levels |
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 – Veritas NetBackup 2 – Veritas Backup Exec 3 – EMC NetWorker 4 – IBM Tivoli Storage Manager 5 – Commvault Simpana 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 |