Storage Viewer for Backup Database Views > apt_v_cmv_job_vm
  
Version 10.0.01
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 (Storage Viewer 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