Column Name | Data Type | Description |
barcode | STRING | Barcode of the tape media |
expiration_date | DATE | Date/time this tape media is set to expire. |
expiration_status | CHAR | This field contains the expiration status. The following is a list of the enumeration values: E = Expired M = Manual U = Undefined |
expiration_status_name | STRING | Expiration status name as above |
first_label_date | DATE | Date/time this tape media was first labeled. |
last_access_date | DATE | Last date/time this tape was accessed |
last_relabel_date | DATE | Date/time this tape media was relabeled. |
library_id | NUMBER | Foreign key to the Tape Library that contains this piece of tape media (See apt_v_tape_library) |
library_name | STRING | Name of the 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 |
media_availability | CHAR | This field contains the media availability codes. The following is a list of the enumeration values: N = Nearline (in a Jukebox) O = OV |
media_availability_name | STRING | Media availability names as above |
media_capacity_mbytes | NUMBER | Capacity of the tape media in Mbytes |
media_name | STRING | NetWorker media name |
media_state | CHAR | This field contains the media state. The following is a list of the enumeration values: E = Eligible For Recycling M = Manually-Recyclable A = Archive Or Migration Volumes X = Both |
media_state_name | STRING | Media state name as above |
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 names as above. |
nbr_of_mounts | NUMBER | Number of mounts |
nbr_of_recycle | NUMBER | Number of recycle |
nbr_of_savesets | NUMBER | Number of savesets on this tape media |
percent_used | NUMBER | Percent of the tape media already used. |
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 | Names as above |
read_kilobytes | NUMBER | KiB of data read from this tape. |
server_id | NUMBER | Foreign key to the master server that is managing this piece of tape media (See apt_v_server) |
server_name | STRING | Name of the master server that is managing this piece of tape media (See apt_v_server) |
tape_media_id | NUMBER | Unique ID of the tape media. This is an internal ID and not the same as the tape media name/code or barcode in backup product |
vendor_media_status | NUMBER | Vendor media status is stored in the RAW format with the bits as below: 1 = Dirty 2 = Read Only 3 = Appendable 4 = Eligible for Recycling 5 = Manually Recyclable 6 = Archive 7 = Empty 8 = Full |
vendor_media_status_name | STRING | Media status name as above |
vendor_media_type | NUMBER | This field contains the media status. The following is a list of the enumeration values: 1 = File 2 = 3590 3 = 3592 4 = 4MM 5 = 8MM 6 = DLT 7 = LTO 8 = 3480 9 = 3570 10 = 4890 11 = 4MM 12GB 12 = 4MM 20GB 13 = 4MM 4GB 14 = 4MM 8GB 15 = 4MM DAT72 16 = 8MM 20GB 17 = 8MM 5GB 18 = 8MM AIT 19 = 8MM AIT-2 20 = 8MM AIT-3 21 = 8MM AIT-4 22 = 8MM MAMMOTH-2 23 = 9490 24 = 9840 25 = 9840B 26 = 9840C 27 = 9940 28 = 9940B 29 = ADV_FILE 30 = DLT1 32 = DLT7000 33 = DLT8000 34 = HIMT 35 = LOGICAL 36 = LTO ULTRIUM 37 = LTO ULTRIUM-2 38 = LTO ULTRIUM-3 39 = Optical 40 = QIC |
vendor_media_type (continued) | 41 = SAIT-1 42 = SD3 SDLT 43 = SDLT320 44 = SKLT600 45 = SLR 46 = TKZ90 47 = TRAVAN10 48 = TZ85 49 = TZ86 50 = TZ87 51 = TZ88 52 = TZ89 53 = TZ90 54 = TZS20 55 = VXA | |
vendor_media_type_name | STRING | Media type name as above |
vendor_tape_media_id | NUMBER | NetWorker tape media id |
volume_pool_id | NUMBER | Foreign key to the volume pool that this piece of tape media belongs to |
volume_pool_name | STRING | Name of the volume pool |
written_kilobytes | NUMBER | Amount of data already written to this tape media in KiB |