Backup Manager Database Views > Detailed View Descriptions (Commvault Simpana)
  
Version 10.0.01
Detailed View Descriptions (Commvault Simpana)
apt_v_cmv_backup_copy
The apt_v_cmv_backup_copy view contains backup copy information.
Table 3.37 apt_v_cmv_backup_copy
Column Name
Data Type
Description
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
cmv_backup_copy_id_ext
NUMBER
Commvault generated backup copy identifier
cmv_backup_policy_id
NUMBER
Backup policy identifier
cmv_dedup_backup_policy_id
NUMBER
Deduplication backup policy Identifier (StorageConsole generated)
copy_name
STRING
Backup copy name
dedup_recovery_method
NUMBER
Deduplication recovery method
is_aging_enabled
STRING
Aging enabled flag
is_dedup_active
STRING
Deduplication active flag
is_dedup_client_side_enabled
STRING
Deduplication client side enabled flag
is_dedup_enabled
STRING
Deduplication enabled flag
is_dedup_software_com_enabled
STRING
Deduplication software component enabled
is_dedup_using_global_policy
STRING
Deduplication using global policy enabled
is_managed_disk_space_enabled
STRING
Managed disk space enabled flag
is_primary
STRING
Is primary flag
last_updated
DATE
Date and time of the last update
retention_cycles
NUMBER
Retention cycles
retention_days
NUMBER
Retention days
server_instance_id
NUMBER
Server instance identifier
apt_v_cmv_backup_policy
The apt_v_cmv_backup_policy view contains a single row for each backup policy.
Table 3.38 apt_v_cmv_backup_policy
Column Name
Data Type
Description
backup_policy_name
STRING
Backup policy name
cmv_backup_policy_id
NUMBER
Backup policy identifier (StorageConsole generated)
cmv_backup_policy_id_ext
NUMBER
Backup policy identifier (Commvault generated)
dedup_block_size_kb
NUMBER
Deduplication block size in KiB
exists_in_catalog
STRING
Exists in catalog flag
is_enabled_for_legal_holds
STRING
Enabled for legal holds flag
last_updated
DATE
Date and time of the last update
max_streams
NUMBER
Maximum number of streams
server_instance_id
NUMBER
Server instance identifier
apt_v_cmv_backupset
The apt_v_cmv_backupset view contains backup set information.
Table 3.39 apt_v_cmv_backupset
Column Name
Data Type
Description
backupset_name
STRING
Backup set name
cmv_backupset_id
NUMBER
Backup set identifier (StorageConsole generated)
cmv_backupset_id_ext
NUMBER
Commvault unique backup set identifier
last_updated
DATE
Last updated date
server_instance_id
NUMBER
Server instance identifier
apt_v_cmv_client
The apt_v_cmv_client view contains a single row for client information.
Table 3.40 apt_v_cmv_client
Column Name
Data Type
Description
client_group_name
STRING
Comma-separated list of client group names
client_id
NUMBER
Client identifier (StorageConsole Generated)
client_status
NUMBER
Client status
cmv_client_id_ext
NUMBER
Client identifier (Commvault generated)
cmv_release
STRING
Release description
is_dedup_enabled
STRING
Deduplication enabled flag
server_instance_id
NUMBER
Server instance identifier
guid
STRING
Global unique ID
is_active
STRING
Active flag
is_commserver
STRING
Commserver flag
last_updated
DATE
Date and time of the last update
vm_name
STRING
The internal name of the virtual machine
vm_uuid
STRING
The instance UUID of the virtual machine
apt_v_cmv_dbinstance
The apt_v_cmv_dbinstance view contains DB Instance information.
Table 3.41 apt_v_cmv_dbinstance
Column Name
Data Type
Description
cmv_dbinstance_id
NUMBER
DB instance identifier (StorageConsole generated)
cmv_dbinstance_id_ext
NUMBER
DB instance identifier (Commvault generated)
instance_name
STRING
Instance name
last_updated
DATE
Date and time of the last update
server_instance_id
NUMBER
Server instance identifier
apt_v_cmv_dedup_store
The apt_v_cmv_dedup_store view contains deduplication store information.
Table 3.42 apt_v_cmv_dedup_store
Column Name
Data Type
Description
client_id
NUMBER
Client identifier (StorageConsole generated)
cmv_dedup_store_id
NUMBER
Deduplication store identifier (StorageConsole generated)
cmv_dedup_store_id_ext
NUMBER
Deduplication store identifier (Commvault generated)
is_enabled
STRING
Enabled flag
last_updated
DATE
Date and time of the last update
server_instance_id
NUMBER
Server instance identifier
store_path
STRING
Store path
apt_v_cmv_disk_drive
The apt_v_cmv_disk_drive view contains disk drive information.
Table 3.43 apt_v_cmv_disk_drive
Column Name
Data Type
Description
cmv_disk_drive_id
NUMBER
Disk drive identifier (StorageConsole generated)
cmv_disk_drive_id_ext
NUMBER
Disk drive identifier (Commvault generated)
cmv_disk_library_id
NUMBER
Disk library identifier (StorageConsole generated)
cmv_drive_status
STRING
Drive status
cmv_drivepool_id
NUMBER
Drive pool identifier (StorageConsole generated)
controlling_server_id
NUMBER
Controlling server identifier
device_name
STRING
Device name
drive_external_name
STRING
Drive external name
drive_in_use
STRING
Drive in use flag
drive_name
STRING
Driver name
drive_number
NUMBER
Drive number
drive_offline_reason
NUMBER
Drive offline reason
drive_status
STRING
Drive status
drive_vendor
STRING
Drive vendor
drive_vendor_model
STRING
Drive vendor model
firmware_revision
STRING
Firmware revision
is_broken
STRING
Broken flag
is_deleted
STRING
Deleted flag
is_enabled
STRING
Enabled flag
last_clean_time
DATE
Last clean time
last_updated
DATE
Date and time of the last update
management_server_id
NUMBER
Management server identifier
nbr_backups_life
NUMBER
Number of backups
nbr_hard_errors_life
NUMBER
Number of hard errors
nbr_hard_errors_since_clean
NUMBER
Number of hard errors since cleaned
nbr_minutes_used_life
NUMBER
Number of minutes used
nbr_minutes_used_since_clean
NUMBER
Number of minutes used since cleaned
nbr_mounts
NUMBER
Number of mounts
nbr_restores_life
NUMBER
Number of restores
nbr_soft_errors_life
NUMBER
Number of soft errors
nbr_soft_errors_since_clean
NUMBER
Number of soft errors since cleaned
product_type
NUMBER
Product type
serial_number
STRING
Serial number
server_instance_id
NUMBER
Server instance identifier
status_last_updated
DATE
Last updated status date
vendor_drive_status
STRING
Vendor drive status
vendor_drive_type
NUMBER
Vendor drive type
wwn_number
STRING
WWN number
apt_v_cmv_disk_library
The apt_v_cmv_disk_library view contains disk library information.
Table 3.44 apt_v_cmv_disk_library
Column Name
Data Type
Description
cmv_disk_library_id
NUMBER
Disk library identifier (StorageConsole generated)
cmv_disk_library_id_ext
NUMBER
Disk library identifier (Commvault generated)
controlling_server_id
NUMBER
Controlling server identifier
description
STRING
Description
device_name
STRING
Device name
firmware_revision
STRING
Firmware revision
has_bar_code_reader
STRING
Bar code reader flag
is_broken
STRING
Broken flag
is_deleted
STRING
Deleted flag
is_disk_library
STRING
Disk library flag
is_enabled
STRING
Enabled flag
is_online
STRING
Online flag
last_updated
DATE
Date and time of the last update
library_external_name
STRING
Library external name
library_name
STRING
Library name
library_vendor
STRING
Library vendor
library_vendor_model
STRING
Library vendor model
media capacity
NUMBER
Media capacity
nbr_hard_errors
NUMBER
Number of hard errors
nbr_mounts
NUMBER
Number of mounts
nbr_of_drives
NUMBER
Number of drives
nbr_soft_errors
NUMBER
Number of soft errors
serial_number
STRING
Serial number
server_id
NUMBER
Server identifier
server_instance_id
NUMBER
Server instance identifier
vendor_library_nbr
NUMBER
Vendor library number
vendor_library_type
NUMBER
Vendor library type
wwn_number
STRING
WWN number
apt_v_cmv_disk_media
The apt_v_cmv_disk_media view contains disk media information.
Table 3.45 apt_v_cmv_disk_media
Column Name
Data Type
Description
bar_code
STRING
Bar code
block_size_kb
NUMBER
Block size in KiB
cmv_current_drive_id
NUMBER
Current drive identifier
cmv_disk_library_id
NUMBER
Disk library identifier (StorageConsole generated)
cmv_disk_media_id
NUMBER
Disk media identifier (StorageConsole generated)
cmv_disk_media_id_ext
NUMBER
Disk media identifier (Commvault generated)
cmv_media_status
NUMBER
Media status
export_location
STRING
Export location
free_space_kb
NUMBER
Free space in KiB
last_backup_time
DATE
Last backup time
last_export_time
DATE
Last export time
last_restore_time
DATE
Last restore time
last_updated
DATE
Date and time of the last update
library_slot_nbr
NUMBER
Library slot number
media_creation_time
DATE
Media creation time
media_location
NUMBER
Media location
media_name
STRING
Media name
media_status
STRING
Media status
media_type
NUMBER
Media type
media_vendor_type
STRING
Media vendor type
nbr_backups
NUMBER
Number of backups
nbr_hard_errors
NUMBER
Number of hard errors
nbr_restores
NUMBER
Number of restores
nbr_reuse
NUMBER
Number of reuse
nbr_sides
NUMBER
Number of sides
nbr_soft_errors
NUMBER
Number of soft errors
product_type
NUMBER
Product type
server_instance_id
NUMBER
Server instance identifier
slot_name
STRING
Slot name
slot_type
NUMBER
Slot type
total_space_kb
NUMBER
Total space in KiB
used_space_kb
NUMBER
Used space in KiB
vendor_media_status
NUMBER
Vendor media status
vendor_media_type
NUMBER
Vendor media type
apt_v_cmv_drivepool
The apt_v_cmv_drivepool view contains drive pool information.
Table 3.46 apt_v_cmv_drivepool
Column Name
Data Type
Description
cmv_disk_library_id
NUMBER
Disk library identifier (StorageConsole generated)
cmv_drivepool_id
NUMBER
Drive pool identifier (StorageConsole generated)
cmv_drivepool_id_ext
NUMBER
Drive pool identifier (Commvault generated)
cmv_optical_library_id
NUMBER
Optical library identifier (StorageConsole generated)
drivepool_name
STRING
Drive pool name
is_deleted
STRING
Flag indicting if the drive pool is deleted
last_updated
DATE
Date and time of the last update
server_instance_id
NUMBER
Server instance identifier
tape_library_id
NUMBER
Tape library identifier (StorageConsole generated)
apt_v_cmv_idataagent
The apt_v_cmv_idataagent view contains IDataagent information.
Table 3.47 apt_v_cmv_idataagent
Column Name
Data Type
Description
cmv_idataagent_id
NUMBER
IDataAgent identifier (StorageConsole generated)
cmv_idataagent_id_ext
NUMBER
IDataAgent identifier (Commvault generated)
idataagent_name
STRING
IDataAgent name
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
last_updated
DATE
Date and time of the last update
apt_v_cmv_job
The apt_v_cmv_job view contains a single row for each Commvault job.
Table 3.48 apt_v_cmv_job
Column Name
Data Type
Description
client_id
NUMBER
Client identifier for the job
cmv_backup_policy_id
NUMBER
Backup policy identifier (StorageConsole generated)
cmv_backupset_id
NUMBER
Backup set ID
cmv_dbinstance_id
NUMBER
Database instance ID
cmv_idataagent_id
NUMBER
iDataAgent ID
cmv_job_id_ext
NUMBER
Job identifier (Commvault generated)
cmv_primary_backup_copy_id
NUMBER
Primary backup copy identifier (StorageConsole generated)
cmv_subclient_id
NUMBER
Subclient identifier (StorageConsole generated)
failed_filelist_remain_attmpt
NUMBER
Failed file list remaining attempts
is_active
STRING
Flag (Yes/No) to indicate whether a Job is active or not.
is_aged
STRING
Aged flag
job_failed_reason_id
NUMBER
Job failed reason identifier (StorageConsole generated)
job_id
NUMBER
Job identifier (StorageConsole generated)
job_init_from
NUMBER
Job initialized from identifier (StorageConsole generated)
job_status
NUMBER
Job status
1 - Success
2 - Failed
3 - Partial Success
4 - Killed
5 - Stopped
6 - Interrupted
7 - Unknown
8 - Failed to Start
9 - Abnormally Terminated Cleanup
10 - Completed
11 - Completed w/ one or more errors
12 - Failed
13 - Interrupt Pending
14 - Kill Pending
15 - Killed
16 - Pending
17 - Queued
18 - Running
19 - Running (Cannot be verified)
20 - Suspend Pending
21 - Suspended
22 - System Kill Pending
23 - Waiting
last_updated
DATE
Date and time last updated
nbr_of_bytes_comp
NUMBER
Number of bytes compressed
nbr_of_bytes_uncomp
NUMBER
Number of bytes uncompressed
nbr_of_corrupted_files
NUMBER
Number of corrupted files
nbr_of_directories
NUMBER
Number of directories
nbr_of_in_use_files
NUMBER
Number of in-use files
nbr_of_other_skipped_files
NUMBER
Number of other skipped files
nbr_of_streams
NUMBER
Number of streams
nbr_of_vms
NUMBER
Number of VMs used for the backup/restore job
scheduled_start_time
DATE
Scheduled start time
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
apt_v_cmv_job_vm
The apt_v_cmv_job_vm view contains a single row for Commvault Job and Virtual Machine.
Table 3.49 apt_v_cmv_job_vm
Column Name
Data Type
Description
client_id
NUMBER
Client (ESX Server) Identifier for job
is_active
STRING
Flag (Yes/No) to indicate whether a job is active or not
job_id
NUMBER
Job identifier (StorageConsole generated)
last_updated
DATE
Last updated date
vm_agent
STRING
The Commvault agent used to backup the virtual machine
vm_backup_type
NUMBER
Commvault Simpana internal backup type of the virtual machine backup
vm_cbt_status
STRING
Changed Block Tracking status of the virtual machine
vm_client_id
NUMBER
The client ID for the virtual machine
vm_cmv_client_id_ext
NUMBER
The internal Commvault Simpana client ID for the virtual machine
vm_esx_server_host_name
STRING
The hostname of the ESX server hosting the virtual machine
vm_failed_reason_id
NUMBER
The failed reason id for the backup/restore job
vm_finish_date
DATE
The time that the backup of the virtual machine finished
vm_guest_size_kb
NUMBER
Indicates whether the reported guest size of the virtual machine is valid.
vm_guest_size_valid
STRING
Indicates whether the reported guest size of the virtual machine is valid.
vm_guid
STRING
The instance GUID of the virtual machine
vm_hardware_version
STRING
The hardware version of the virtual machine
vm_name
STRING
The internal name of the virtual machine
vm_operating_system
STRING
The guest operating system of the virtual machine
vm_size_kb
NUMBER
The size of the virtual machine in KiB.
vm_start_date
DATE
The time that the backup of the virtual machine started
vm_status
NUMBER
Commvault Simpana internal status of the virtual machine backup
vm_tools
STRING
The VMware tools status of the virtual machine, such as Not Installed, Out of Date or Current
vm_transport_mode
STRING
The VMware transport mode used by the virtual machine
vm_used_space_kb
NUMBER
The used space of the virtual machine in KiB.
vm_uuid
STRING
The instance UUID of the virtual machine
apt_v_cmv_job_disk_media
The apt_v_cmv_job_disk_media view contains job and disk media history.
Table 3.50 apt_v_cmv_job_disk_media
Column Name
Data Type
Description
client_id
NUMBER
Client Identifier for Client to which Job is associated
clone_id
NUMBER
Clone ID
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
cmv_disk_drive_id
NUMBER
Disk drive identifier (StorageConsole generated)
cmv_disk_media_id
NUMBER
Disk media identifier (StorageConsole generated)
job_id
NUMBER
Job identifier (StorageConsole generated)
kilobytes
NUMBER
Kilobytes
last_updated
DATE
Date last updated
modified_time
DATE
Modified time
num_attempts
NUMBER
Number of attempts
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
total_comp_bytes
NUMBER
Total compressed bytes
total_uncomp_bytes
NUMBER
Total uncompressed bytes
vendor_status
STRING
Vendor status
apt_v_cmv_job_optical_media
The apt_v_cmv_job_optical_media view contains job and optical media history.
Table 3.51 apt_v_cmv_job_optical_media
Column Name
Data Type
Description
client_id
NUMBER
Client Identifier for Client to which Job is associated
clone_id
NUMBER
Clone ID
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
cmv_optical_drive_id
NUMBER
Optical drive identifier (StorageConsole generated)
cmv_optical_media_id
NUMBER
Optical medical identifier (StorageConsole generated)
job_id
NUMBER
Job identifier (StorageConsole generated)
kilobytes
NUMBER
Kilobytes
last_updated
DATE
Date last updated
modified_time
DATE
Modified time
num_attempts
NUMBER
Number of attempts
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
total_comp_bytes
NUMBER
Total compressed bytes
total_uncomp_bytes
NUMBER
Total uncompressed bytes
vendor_status
STRING
Vendor status
apt_v_cmv_job_tape_media
.The apt_v_cmv_job_tape_media view contains job and tape media history.
Table 3.52 apt_v_cmv_job_tape_media
Column Name
Data Type
Description
client_id
NUMBER
Client Identifier for Client to which Job is associated
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
drive_name
STRING
Tape drive name
job_id
NUMBER
Job identifier (StorageConsole generated)
last_modified_time
DATE
Last modified time
last_updated
DATE
Date and time last updated
media_name
STRING
Tape media name
num_attempts
NUMBER
Number of attempts
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
tape_drive_id
NUMBER
Tape drive identifier (StorageConsole generated)
tape_media_id
NUMBER
Tape media identifier (Commvault generated)
total_comp_bytes
NUMBER
Total compressed bytes
total_uncomp_bytes
NUMBER
Total uncompressed bytes
apt_v_cmv_optical_drive
The apt_v_cmv_optical_drive view contains optical drive information.
Table 3.53 apt_v_cmv_optical_drive
Column Name
Data Type
Description
cmv_drive_status
NUMBER
Drive status
cmv_drivepool_id
NUMBER
Drive pool identifier (StorageConsole generated)
cmv_optical_drive_id
NUMBER
Optical drive identifier (StorageConsole generated)
cmv_optical_drive_id_ex
NUMBER
Optical drive identifier (Commvault generated)
cmv_optical_library_id
NUMBER
Optical library identifier (StorageConsole generated)
controlling_server_id
NUMBER
Controlling server identifier
device_name
STRING
Device name
drive status
STRING
Drive status
drive_external_name
STRING
Drive external name
drive_in_use
STRING
Drive in use flag
drive_name
STRING
Drive name
drive_number
NUMBER
Drive number
drive_offline_reason
NUMBER
Drive offline reason
drive_vendor
STRING
Drive vendor
drive_vendor_model
STRING
Drive vendor model
firmware_revision
STRING
Firmware revision
is_broken
STRING
Broken flag
is_deleted
STRING
Deleted flag
is_enabled
STRING
Enabled flag
last_clean_time
DATE
Last clean time
management_server_id
NUMBER
Management server identifier (StorageConsole generated)
nbr_backups_life
NUMBER
Number of backups
nbr_hard_errors_life
NUMBER
Number of hard errors
nbr_hard_errors_since_clean
NUMBER
Number of hard errors since cleaned
nbr_minutes_used_life
NUMBER
Number of minutes used
nbr_minutes_used_since_clean
NUMBER
Number of minutes since clean
nbr_mounts
NUMBER
Number of mounts
nbr_restores_life
NUMBER
Number of restores
nbr_soft_errors_life
NUMBER
Number of soft errors
nbr_soft_errors_since_clean
NUMBER
Number of soft errors since clean
product_type
NUMBER
Product type
serial_number
STRING
Serial number
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
status_last_updated
DATE
Status last updated
vendor_drive_status
STRING
Vendor drive status
vendor_drive_type
NUMBER
Vendor drive type
wwn_number
STRING
WWN number
apt_v_cmv_optical_library
The apt_v_cmv_optical_library view contains optical library information.
Table 3.54 apt_v_cmv_optical_library
Column Name
Data Type
Description
cmv_optical_library_id
NUMBER
Optical library identifier (StorageConsole generated)
cmv_optical_library_id_ext
NUMBER
Optical library identifier (Commvault generated)
controlling_server_id
NUMBER
Controlling server identifier (StorageConsole generated)
description
STRING
Description
device_name
STRING
Device name
firmware_revision
STRING
Firmware revision
has_bar_code_reader
STRING
Bar code reader flag
is_broken
STRING
Broken flag
is_deleted
STRING
Deleted flag
is_disk_library
STRING
Disk library flag
is_enabled
STRING
Enabled flag
is_online
STRING
Online flag
last_updated
DATE
Date and time last updated
library_external_name
NUMBER
Library external name
library_name
NUMBER
Library name
library_vendor
STRING
Library vendor
library_vendor_model
STRING
Library vendor model
media_capacity
NUMBER
Media capacity
nbr_hard_errors
NUMBER
Number of hard errors
nbr_mounts
NUMBER
Number of mounts
nbr_of_drives
NUMBER
Number of drives
nbr_soft_errors
NUMBER
Number of soft errors
serial_number
STRING
Serial number
server_id
NUMBER
Server identifier (StorageConsole generated)
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
vendor_library_nbr
NUMBER
Vendor library number
vendor_library_type
NUMBER
Vendor library type
wwn_number
STRING
WWN number
apt_v_cmv_optical_media
The apt_v_cmv_optical_media view contains optical media information.
Table 3.55 apt_v_cmv_optical_media
Column Name
Data Type
Description
bar_code
STRING
Bar code
block_size_kb
NUMBER
Block size in KiB
cmv_current_drive_id
NUMBER
Current drive identifier (StorageConsole generated)
cmv_media_status
NUMBER
Media status
cmv_optical_library_id
NUMBER
Optical library identifier (StorageConsole generated)
cmv_optical_media_id
NUMBER
Optical medical identifier (StorageConsole generated)
cmv_optical_media_id_ext
NUMBER
Optical media identifier (Commvault generated)
export_location
STRING
Export location
free_space_kb
NUMBER
Free space in KiB
last_backup_time
DATE
Last backup time
last_export_time
DATE
Last export time
last_restore_time
DATE
Last restore time
last_updated
DATE
Date and time last updated
library_slot_nbr
NUMBER
Library slot number
media_creation_time
DATE
Media creation time
media_location
NUMBER
Media location
media_name
STRING
Media name
media_status
STRING
Tape media status
media_type
NUMBER
Media type
media_vendor_type
STRING
Media vendor type
nbr_backups
NUMBER
Number of backups
nbr_hard_errors
NUMBER
Number of hard errors
nbr_restores
NUMBER
Number of restores
nbr_reuse
NUMBER
Number of reuse
nbr_sides
NUMBER
Number of sides
nbr_soft_errors
NUMBER
Number of soft errors
product_type
NUMBER
Product type
server_id
NUMBER
Server ID
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
slot_name
STRING
Slot name
slot_type
NUMBER
Slot type
total_space_kb
NUMBER
Total space in KiB
used_space_kb
NUMBER
Used space in KiB
vendor_media_status
NUMBER
Vendor media status
vendor_media_type
NUMBER
Vendor media type
apt_v_cmv_reason
The apt_v_cmv_reason view contains Commvault reason codes and descriptions.
Table 3.56 apt_v_cmv_reason
Column Name
Data Type
Description
cmv_reason_code
NUMBER
Reason code
cmv_reason_id
NUMBER
Reason identifier (StorageConsole generated)
description
STRING
Description of reason
last_updated
DATE
Date and time last updated
apt_v_cmv_retention_period
The apt_v_cmv_retention_period view contains
Table 3.57 apt_v_cmv_retention_period
Column Name
Data Type
Description
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
cmv_subclient_id
NUMBER
Subclient identifier (StorageConsole generated)
last_updated
DATE
Date and time last updated
retention_days
NUMBER
Retention days
server_instance_id
NUMBER
Server Instance Identifier (StorageConsole Generated)
apt_v_cmv_skipped_files
The apt_v_cmv_skipped_files view contains skipped files information.
Table 3.58 apt_v_cmv_skipped_files
Column Name
Data Type
Description
job_id
NUMBER
Job identifier (StorageConsole generated)
last_updated
DATE
Date and time last updated
reason_id
NUMBER
Reason identifier (StorageConsole generated)
seq_number
NUMBER
Sequential number
apt_v_cmv_storcopy_dedupstore
The apt_v_cmv_storcopy_dedupstore view contains backup copy and deduplication information.
Table 3.59 apt_v_cmv_storcopy_dedupstore
Column Name
Data Type
Description
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
cmv_dedup_store_id
NUMBER
Deduplication store identifier (StorageConsole generated)
last_updated
DATE
Date and time last updated
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
apt_v_cmv_storcopy_drvpools
The apt_v_cmv_storcopy_drvpools view contains backup copy and drive pool information.
Table 3.60 apt_v_cmv_storcopy_drvpools
Column Name
Data Type
Description
cmv_backup_copy_id
NUMBER
Backup copy identifier (StorageConsole generated)
cmv_drivepool_id
NUMBER
Drive pool identifier (StorageConsole generated)
is_hardware_compressed
STRING
Hardware compressed flag
is_hardware_encrypted
STRING
Hardware encrypted flag
last_updated
DATE
Date and time last updated
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
apt_v_cmv_subclient
The apt_v_cmv_subclient view contains subclient information.
Table 3.61 apt_v_cmv_subclient
Column Name
Data Type
Description
client_id
NUMBER
Client identifier (StorageConsole generated)
cmv_backup_policy_id
NUMBER
Backup policy identifier (StorageConsole generated)
cmv_backupset_id
NUMBER
Backup set identifier (StorageConsole generated)
cmv_dbinstance_id
NUMBER
DB Instance identifier (StorageConsole generated)
cmv_idataagent_id
NUMBER
IDataAgent identifier (StorageConsole generated)
cmv_subclient_id
NUMBER
Subclient identifier (StorageConsole generated)
cmv_subclient_id_ext
NUMBER
Subclient identifier (Commvault generated)
last_updated
DATE
Date and time last updated
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
subclient_name
STRING
Subclient name
apt_v_cmv_tape_drive
The apt_v_cmv_tape_drive view contains tape drive information.
Table 3.62 apt_v_cmv_tape_drive
Column Name
Data Type
Description
cmv_drive_status
NUMBER
Drive status
cmv_drivepool_id
NUMBER
Drive pool identifier (StorageConsole generated)
cmv_tape_drive_id_ext
NUMBER
Tape drive identifier (Commvault generated)
drive_external_name
NUMBER
Drive external name
drive_name
STRING
Drive name
drive_number
NUMBER
Drive number
drive_offline_reason
NUMBER
Drive offline reason
drive_vendor
STRING
Drive vendor
drive_vendor_model
STRING
Drive vendor model
firmware_revision
STRING
Firmware revision
is_broken
STRING
Broken flag
is_enabled
STRING
Enabled flag
last_clean_time
DATE
Last clean time
last_updated
DATE
Date and time last updated
nbr_backups_life
NUMBER
Number of backups
nbr_hard_errors_life
NUMBER
Number of hard errors
nbr_hard_errors_since_clean
NUMBER
Numbers of hard errors since clean
nbr_minutes_used_life
NUMBER
Number of minutes used
nbr_minutes_used_since_clean
NUMBER
Number of minutes used since clean
nbr_mounts
NUMBER
Number of mounts
nbr_restores_life
NUMBER
Number of restores
nbr_soft_errors_life
NUMBER
Number of soft errors
nbr_soft_errors_since_clean
NUMBER
Number of soft errors since clean
serial_number
STRING
Serial number
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
status_last_updated
DATE
Status last updated date
tape_drive_id
NUMBER
Tape drive identifier (StorageConsole generated)
wwn_number
STRING
WWN number
apt_v_cmv_tape_library
The apt_v_cmv_tape_library view contains tape library information.
Table 3.63 apt_v_cmv_tape_library
Column Name
Data Type
Description
cmv_tape_library_id_ext
NUMBER
Tape library identifier (Commvault generated)
firmware_revision
STRING
Firmware Revision
has_bar_code_reader
STRING
Bar code reader flag
is_broken
STRING
Broken flag
is_enabled
STRING
Enabled flag
last_updated
DATE
Date and time last updated
library_name
STRING
Library name
library_vendor
STRING
Library vendor
library_vendor_model
STRING
Library vendor model
nbr_hard_errors
NUMBER
Number of hard errors
nbr_mounts
NUMBER
Number of mounts
nbr_soft_errors
NUMBER
Number of soft errors
serial_number
STRING
Serial number
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
tape_library_id
NUMBER
Tape library identifier (StorageConsole generated)
wwn_number
STRING
WWN number
apt_v_cmv_tape_media
The apt_v_cmv_tape_media view contains tape media information.
Table 3.64 apt_v_cmv_tape_media
Column Name
Data Type
Description
bar_code
STRING
Bar code
block_size_kb
NUMBER
Block size in KiB
cmv_current_drive_id
NUMBER
Current drive identifier
cmv_media_status
NUMBER
Media status
cmv_tape_media_id_ext
NUMBER
Tape media identifier (Commvault generated)
export_location
STRING
Export location
free_space_kb
NUMBER
Free space in KiB
last_backup_time
DATE
Last backup time
last_export_time
DATE
Last export time
last_restore_time
DATE
Last restore time
last_updated
DATE
Date and time last updated
media_creation_time
DATE
Media creation time
media_location
NUMBER
Media location
media_name
STRING
Media name
media_type
NUMBER
Media type
media_vendor_type
STRING
Media vendor type
nbr_backups
NUMBER
Number of backups taken
nbr_hard_errors
NUMBER
Number of hard errors
nbr_restores
NUMBER
Number of times the tape was restored
nbr_reuse
NUMBER
Number of times the tape is reused
nbr_sides
NUMBER
Number of sides
nbr_soft_errors
NUMBER
Number of soft errors
server_instance_id
NUMBER
Server instance identifier (StorageConsole generated)
slot_name
STRING
Slot name
slot_type
NUMBER
Slot type
tape_media_id
NUMBER
Tape media identifier (StorageConsole generated)
total_space_kb
NUMBER
Total space in KiB
used_space_kb
NUMBER
Used space in KiB