Virtualization Manager Database Views
  
Version 10.0.01
Virtualization Manager Database Views
apt_v_partition
The apt_v_partition view contains one row for each VM partition.
Table 7.1 apt_v_partition
Column Name
Data Type
Description
partition_id
NUMBER
Primary Key
collection_status
NUMBER
Collection status of the partition
child_thread_id
NUMBER
Child thread ID
virtual_system_id
NUMBER
Foreign key to apt_v_virtual_system
partition_type
STRING
Partition Type
partition_name
STRING
Partition Name
host_id
NUMBER
Foreign key to apt_v_server
annotation
STRING
Annotation
nbr_cpu
NUMBER
Number of CPUs
memory_size_kb
NUMBER
Memory size in KiB
uuid
STRING
UUID
boot_time
STRING
Boot time
power_state
STRING
Power State
parent_partition_id
NUMBER
Partition ID of the parent
root_reference_name
STRING
Root reference name
last_updated
DATE
Date and time last updated
virtual_center_id
NUMBER
Foreign key to apt_v_virtual_center
domain_id
NUMBER
Foreign key to apt
apt_v_virtual_center
The apt_v_virtual_center view contains a single row for each vCenter.
Table 7.2 apt_v_virtual_center
Column Name
Data Type
Description
child_thread_id
NUMBER
Identifier for the collection processing
collection_status
NUMBER
Collection status
domain_id
NUMBER
Foreign key to aps_v_domain
host_id
NUMBER
Foreign key to host details
last_updated
DATE
Date and time last updated in database
virtual_center_id
NUMBER
Virtual Center ID
apt_v_virtual_system
The apt_v_virtual_system view contains a single row for each virtual system. While this is listed under Virtualization Manager, it is a view that applies to the StorageConsole platform.
Table 7.3 apt_v_virtual_system
Column Name
Data Type
Description
child_thread_id
NUMBER
Child thread ID
collection_status
NUMBER
Collection status code
domain_id
NUMBER
Foreign key to aps_v_domain
host_id
NUMBER
Foreign key to host details
is_active
STRING
Indicates if the virtual system is active: Y or N
last_updated
DATE
Date and time last updated in database
tot_cpu
NUMBER
Total CPU capacity
tot_memory_kb
NUMBER
Total memory capacity in KiB
virtual_center_id
NUMBER
Virtual Center ID
virtual_system_id
NUMBER
Sequence generated primary key of the view
virtual_system_name
STRING
Virtual system name
vmw_cluster_id
NUMBER
Foreign key to the cluster details
apt_v_vmw_cluster
The apt_v_vmw_cluster contains a single row for each VMware cluster.
Table 7.4 apt_v_vmw_cluster
Column Name
Data Type
Description
child_thread_id
NUMBER
Child thread ID
cluster_name
STRING
Cluster name
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
drs_is_autolevel
STRING
Indicates whether DRS Behavior overrides for individual virtual machines (ClusterDrsVmConfigInfo) are enabled. The default value is true
drs_is_enabled
STRING
Indicates if strict admission control is enabled
drs_mode
STRING
Indicates whether the service is enabled
effective_cpu_mhz
NUMBER
Effective CPU resources (in MHz) available to run virtual machines. This is the aggregated effective resource level from all running hosts. Hosts that are in maintenance mode or are unresponsive are not counted. Resources used by the VMware Service Console are not included in the aggregate. This value represents the amount of resources available for the root resource pool for running virtual machines.
effective_memory_kb
NUMBER
Effective memory resources (in MB) available to run virtual machines. This is the aggregated effective resource level from all running hosts. Hosts that are in maintenance mode or are unresponsive are not counted. Resources used by the VMware Service Console are not included in the aggregate. This value represents the amount of resources available for the root resource pool for running virtual machines.
ha_failover_level
NUMBER
Configured failover level. This is the number of physical host failures that can be tolerated without impacting the ability to satisfy the minimums for all running virtual machines.
ha_is_admission_ctrl_enabled
STRING
Default VM behavior: FullyAutomated, manual, or partiallyAutomated
ha_is_enabled
STRING
Indicates if the vSphere HA feature is enabled
ha_isolation_response
STRING
Indicates whether or not the virtual machine should be powered off if a host determines that it is isolated from the rest of the computing resource
ha_nbr_of_slots
NUMBER
The total number of slots available in the cluster
ha_nbr_of_used_slots
NUMBER
The number of slots currently being used
ha_nbr_of_virtual_cpu
NUMBER
The number of slots currently being used
ha_restart_priority
STRING
Restart priority for a virtual machine
ha_slot_cpu_speed_mhz
NUMBER
The CPU speed of a slot is defined as the maximum cpu reservation of any powered on virtual machine in the cluster, or any otherwise defined minimum, whichever is larger
ha_slot_memory_kb
NUMBER
The memory size of a slot is defined as the maximum memory reservation plus memory overhead of any powered on virtual machine in the cluster, or any otherwise defined minimum, whichever is larger.
last_updated
DATE
Last modified date
nbr_of_cpu_cores
NUMBER
Number of physical CPU cores. Physical CPU cores are the processors contained by a CPU package
nbr_of_cpu_threads
NUMBER
Aggregated number of CPU threads
nbr_of_effective_hosts
NUMBER
Total number of effective hosts
nbr_of_hosts
NUMBER
Total number of hosts
overall_status
STRING
The Status enumeration defines a general health value for a managed entity
swapfile_policy
STRING
Swapfile placement policy for virtual machines within cluster
total_cpu_mhz
NUMBER
Aggregated CPU resources of all hosts, in MHz
total_memory_kb
NUMBER
Aggregated memory resources of all hosts in KiB
vmw_cluster_id
NUMBER
Sequence generated Primary key
apt_v_vmw_container
The apt_v_vmw_container contains a single row for each VMWare virtual machine container.
Table 7.5 apt_v_vmw_container
Column Name
Data Type
Description
child_thread_id
NUMBER
Child thread ID
container_name
STRING
Container name
container_type
STRING
Container type
domain_id
NUMBER
Foreign key to apt_v_domain
domain_name
STRING
Domain Name
last_updated
DATE
Last modified date
parent_container_id
NUMBER
Parent Container ID
partition_id
NUMBER
Foreign key for apt_v_partition
partition_name
STRING
Partition name
reference_name
STRING
Reference name
root_container_id
NUMBER
Root Container ID
virtual_center_id
NUMBER
Virtual Center ID
virtual_system_id
NUMBER
Foreign key to apt_v_virtual_system
virtual_system_name
STRING
Name of the virtual system
vmw_container_id
NUMBER
Foreign key for VM Host
apt_v_vmw_datastore
The apt_v_vmw_datastore contains a single row for each VMWare datastore.
Table 7.6 apt_v_vmw_datastore
Column Name
Data Type
Description
block_size_kb
NUMBER
Block size in KiB
child_thread_id
NUMBER
Child thread ID
datastore_name
STRING
Datastore name
datastore_type
STRING
Datastore type
domain_id
NUMBER
Domain ID
free_capacity_kb
NUMBER
Available capacity to use in KiB
is_file_thin_prov_supported
STRING
Indicates whether or not the datastore supports thin provisioning on a per-file basis
is_multi_host_access
STRING
Is multi host access enabled?
is_thin_provisioned
STRING
Indicates if the virtual disk is thinly provisioned
last_updated
DATE
Date and time last updated
local_path_name
STRING
Local path name for the datastore. For example, the path attribute for the datastore type, LocalDatastoreInfo.
remote_host_name
STRING
Remote host name
remote_ip_address
STRING
Comma-separated list of IP addresses
remote_path_name
STRING
Remote path name
remote_storage_array_id
NUMBER
Remote storage array ID
remote_storage_array_name
STRING
Remote storage array name
tot_capacity_kb
NUMBER
Total capacity on the datastore in KiB
url
STRING
URL
uuid
STRING
UUID
version
STRING
Version of the datastore
vmw_datastore_id
NUMBER
Primary Key
apt_v_vmw_datastore_file
The apt_v_vmw_datastore_file contains a single row for each VMWare datastore file.
Table 7.7 apt_v_vmw_datastore_file
Column Name
Data Type
Description
child_thread_id
NUMBER
Foreign key from apt_child_thread
domain_id
NUMBER
Domain ID
file_name
STRING
Datastore file name
file_path
STRING
Datastore file path
file_type
STRING
Datastore file type
last_modified
DATE
Date and time the datastore file was modified
last_updated
DATE
Date and time last updated
size_kb
NUMBER
Datastore file size in KiB
top_folder
STRING
Top folder of the datastore file
vmw_datastore_file_id
NUMBER
Sequence generated primary key
vmw_datastore_id
NUMBER
Foreign key from apt_vmw_datastore
 
apt_v_vmw_datastore_usage
The apt_v_vmw_datastore_usage view contains a single row for each Datastore.
Table 7.8 apt_v_vmw_datastore_usage
Column Name
Data Type
Description
datastore_name
STRING
Datastore name
ds_free_kb
NUMBER
Datastore free space in KiB (1024 bytes)
ds_used_kb
NUMBER
Datastore used space in KiB (1024 bytes)
other_files_kb
NUMBER
Datastore space used by files other than VM files
total_ds_capacity_kb
NUMBER
Total Datastore capacity in KiB (1024 bytes)
total_other_vmfile_size_kb
NUMBER
Datastore used space by other vm files (exclude vm disk files) in inventory in kilobytes
total_snapshot_size_kb
NUMBER
Total snapshot file size in KiB (1024 bytes)
total_vm_not_inventory
NUMBER
Datastore space used by VMs that are not in the VM inventory
total_vm_size_kb
NUMBER
Datastore space used by VMs
total_vmdisk_size_kb
NUMBER
Datastore used space by vm disk files in inventory in kilobytes
vmw_datastore_id
NUMBER
Foreign key of the datastore
apt_v_vmw_extent
The apt_v_vmw_extent view contains a single row for each Datastore extent.
Table 7.9 apt_v_vmw_extent
Column Name
Data Type
Description
canonical_name
STRING
Name of the VMWare extent
capacity_kb
NUMBER
Capacity in KiB for the VMWare extent
child_thread_id
NUMBER
Child thread ID
datastore_name
STRING
Name of the datastore for the VMWare extent
domain_id
NUMBER
Foreign key from apt
extent_mode
STRING
Mode of the VMware extent
extent_type
STRING
Type of the VMWare extent
last_update
DATE
Last updated date of the extent
partition_num
NUMBER
Partition number of the VMWare extent
virtual_system_id
NUMBER
Foreign key to apt_v_virtual_system
virtual_system_name
STRING
Name of the virtual system
vmw_datastore_id
NUMBER
Foreign key from apt_vmw_datastore
vmw_extent_id
NUMBER
VMware extent unique identifier
vmw_physical_disk_id
NUMBER
Foreign key for physical disk
apt_v_vmw_fc_adapter
The apt_v_vmw_fc_adapter view contains a single row for each VMware Fibre Channel adapter..
Table 7.10 apt_v_vmw_fc_adapter
Column Name
Data Type
Description
device_name
STRING
Host bus adapter device name.
last_updated
DATE
Last updated date.
model
STRING
Model of the adpater.
node_wwn
STRING
Host bus adapter node world wide name.
node_wwn_id
NUMBER
Foreign key to aps_wwn.
pci
STRING
PCI - Peripheral Component Interconnect.
port_wwn
STRING
World Wide Name for the port.
port_wwn_id
NUMBER
Foreign key to port world wide name details.
speed_mbps
NUMBER
Speed in megabytes per second.
status
STRING
Status of the adapter.
virtual_system_id
NUMBER
Foreign key to the apt_v_virtual_system view.
virtual_system_name
STRING
Name of the Virtual System.
apt_v_vmw_fc_target
The apt_v_vmw_fc_target view contains a single row for each VMware Fibre Channel target.
Table 7.11 apt_v_vmw_fc_target
Column Name
Data Type
Description
array_node_wwn
STRING
Array node world wide name.
array_node_wwn_id
NUMBER
Array node world wide name ID.
array_port_wwn
STRING
Array port world wide name.
array_port_wwn_id
NUMBER
Foreign key to the aps_wwn table.
hba_node_wwn
STRING
Host bus adaptor node world wide name.
hba_node_wwn_id
NUMBER
Host bus adaptor node WWN ID.
hba_port_wwn
STRING
Host bus adaptor port world wide name.
hba_port_wwn_id
NUMBER
Host bus adaptor port WWN ID.
last_updated
DATE
Last updated date.
lun_nbr
NUMBER
Logical unit number.
path_name
STRING
Path name.
path_status
STRING
Path status.
target_nbr
NUMBER
Target number.
virtual_system_id
NUMBER
Foreign key to the apt_v_virtual_system view.
virtual_system_name
STRING
Name of the Virtual System.
vmw_physical_disk_id
NUMBER
Foreign key for the VMW Physical Disk.
apt_v_vmw_guest_allocusage_log
The apt_v_vmw_guest_allocusage_log view contains a single row for each VM Guest historical storage usage.
Table 7.12 apt_v_vmw_guest_allocusage_log
Column Name
Data Type
Description
host_id
NUMBER
Foreign key to host details
host_name
STRING
Host name
host_type
STRING
Host type
log_date
DATE
Date and time when the history was captured
total_volume_size_gb
NUMBER
Total volume size in GiB
total_volume_size_kb
NUMBER
Total volume size in KiB
used_volume_size_gb
NUMBER
Used volume size in GiB
used_volume_size_kb
NUMBER
Used volume size in KiB
vm_host_id
NUMBER
Foreign key to VM server details
vm_host_name
STRING
VM server name
vm_id
NUMBER
Foreign key to VM details
vm_name
STRING
VM name
vm_size_gb
NUMBER
VM size in GiB
vm_size_kb
NUMBER
VM size in KiB
apt_v_vmw_hardware
The apt_v_vmw_hardware contains a single row for each ESX host.
Table 7.13 apt_v_vmw_hardware
Column Name
Data Type
Description
cpu_description
STRING
CPU Description
cpu_package_num
NUMBER
CPU Package Number
cpu_speed_mhz
NUMBER
CPU Speed MHZ
cpu_thread_num
NUMBER
CPU thread Number
cpu_vendor
STRING
CPU Vendor
last_updated
DATE
Last modified date
system_model
STRING
System Model
system_uuid
STRING
System UUID
system_vendor
STRING
System Vendor
virtual_system_id
NUMBER
Virtual System ID
virtual_system_name
STRING
Name of the virtual system
apt_v_vmw_map_datastore_lun
The apt_v_vmw_map_datastore_lun view contains a single row for each mapping between a datastore and a LUN.
Table 7.14 apt_v_vmw_map_datastore_lun
Column Name
Data Type
Description
array_name
STRING
Array name
datastore_name
STRING
Datastore name
logical_unit_id
NUMBER
Foreign key to logical unit details
logical_unit_name
STRING
Logical unit name (or device number for un-named LUNs)
storage_array_id
NUMBER
Foreign key to storage array details
vmw_datastore_id
NUMBER
Foreign key of the datastore ID for VMware Datastore
 
apt_v_vmw_map_snapshot_file
The apt_v_vmw_map_snapshot_file view contains a single row for each mapping between a VMWare snapshot and a VM file.
Table 7.15 apt_v_vmw_map_snapshot_file
Column Name
Data Type
Description
datastore_name
STRING
Datastore name
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
file_name
STRING
Datastore file name
file_path
STRING
Datastore file path
last_updated
DATE
Last modified date
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
short_snapshot_name
STRING
Short snapshot name
virtual_system_id
NUMBER
Foreign key for VM Host
virtual_system_name
STRING
VM Host name
vms_datastore_id
NUMBER
Foreign key for the datastore
vmw_datastore_file_id
NUMBER
Foreign key for the datastore file
vmw_snapshot_id
NUMBER
Foreign key for VMW snapshot
apt_v_vmw_partition_profile
The apt_v_vmw_partition_profile view contains a single row for each VM partition profile.
Table 7.16 apt_v_vmw_partition_profile
Column Name
Data Type
Description
child_thread_id
NUMBER
Child thread ID
last_updated
DATE
Last modified date
nbr_ethernet_card
NUMBER
Number of Ethernet cards
OS
STRING
Operating System
partition_id
NUMBER
Foreign key for Partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type
virtual_system_id
NUMBER
Foreign key for the VM Host
apt_v_vmw_partition_stats
The apt_v_vmw_partition_stats view contains a single row for each VM partition’s statistics.
Table 7.17 apt_v_vmw_partition_stats
Column Name
Data Type
Description
child_thread_id
NUMBER
Child thread ID
connection_state
STRING
Connection state
cpu_usage
NUMBER
CPU Usage
guest_memory_usage_kb
NUMBER
Memory usage by guest in KiB
hardware_status
STRING
Hardware status
host_memory_usage_kb
NUMBER
Memory usage by host in KiB
last_updated
DATE
Last modified date
memory_usage_kb
NUMBER
Memory usage in KiB
overall_cpu_usage
NUMBER
Overall CPU usage
partition_id
NUMBER
Foreign key for Partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type
status
STRING
Status
suspend_time
STRING
Suspend time
virtual_system_id
NUMBER
Foreign key for the VM Host
apt_v_vmw_partition_stats_log
The apt_v_vmw_partition_stats_log view contains a single row for each VM partition statistics log.
Table 7.18 apt_v_vmw_partition_stats_log
Column Name
Data Type
Description
cpu_speed_mhz
NUMBER
CPU speed in MHz
cpu_usage
NUMBER
CPU Usage
guest_memory_usage_kb
NUMBER
Memory usage by guest in KiB
host_memory_usage_kb
NUMBER
Memory usage by host in KiB
log_date
DATE
Log date
memory_size_kb
NUMBER
Memory size in KiB
memory_usage_kb
NUMBER
Memory usage in KiB
nbr_cpu
NUMBER
Number of CPUs
overall_cpu_usage
NUMBER
Overall CPU usage
partition_id
NUMBER
Foreign key for Partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type
virtual_system_id
NUMBER
Foreign key for the VM Host
apt_v_vmw_perform_cpu_log
For VMware CPU performance, data collection creates an instance record for each CPU and an instance record for the partition. In the log, performance is listed for each CPU and then rolled up where the instance_name is null.
Table 7.19 apt_v_vmw_perform_cpu_log
Column Name
Data Type
Description
avg_cpu_ready_ms
NUMBER
Average CPU ready time in milliseconds
avg_cpu_usage_mhz
NUMBER
Average CPU usage in Mhz
avg_cpu_usage_pct
NUMBER
Average CPU usage in percentage
avg_cpu_wait_ms
NUMBER
Average CPU wait time in milliseconds
end_log_date
DATE
End timestamp
instance_name
STRING
Instance name
interval_sec
NUMBER
Interval in seconds
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type: Host or VM
start_log_date
DATE
Start timestamp
apt_v_vmw_perform_memory_log
The apt_v_vmw_perform_memory_log view contains a single row for each VM memory.
Table 7.20 apt_v_vmw_perform_memory_log
Column Name
Data Type
Description
avg_balloon_memory_kb
NUMBER
Average Balloon Memory usage in KiB
avg_memory_usage_kb
NUMBER
Average Memory usage in KiB
avg_memory_usage_pct
NUMBER
Average Memory usage in percentage
end_log_date
DATE
End timestamp
interval_sec
NUMBER
Interval in seconds
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type: Host or VM
start_log_date
DATE
Start timestamp
apt_v_vmw_perform_disk_log
The apt_v_vmw_perform_disk_log view contains a single row for each disk in the VM inventory.
Table 7.21 apt_v_vmw_perform_disk_log
Column Name
Data Type
Description
avg_device_read_latency_ms
NUMBER
Average device read latency in milliseconds
avg_device_write_latency_ms
NUMBER
Average device write latency in milliseconds
avg_of_all_disk_usage_kb
NUMBER
Average of all disks usage in KiB
avg_queue_latency_ms
NUMBER
Average amount of time spent in the VMkernal queue, per SCSI command, during the collection interval
avg_queue_read_latency_ms
NUMBER
Average amount of time spent in the VMkernal queue, per SCSI read command, during the collection interval
avg_queue_write_latency_ms
NUMBER
Average amount of time spent in the VMkernal queue, per SCSI write command, during the collection interval
disk_read_kbps
NUMBER
Disk reads in Kbps
disk_write_kbps
NUMBER
Disk writes in Kbps
end_log_date
DATE
End timestamp
instance_name
STRING
Instance name
interval_sec
NUMBER
Interval in seconds
max_queue_depth
NUMBER
Maximum queue depth
nbr_of_disk_read
NUMBER
Number of disk reads
nbr_of_disk_write
NUMBER
Number of disk writes
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type: Host or VM
start_log_date
DATE
Start timestamp
virtual_system_id
NUMBER
Virtual system ID
vmw_physical_disk_id
NUMBER
Foreign key for VMW Physical Disk
apt_v_vmw_physical_disk
The apt_v_vmw_physical_disk view contains a single row for each VM physical disk.
Table 7.22 apt_v_vmw_physical_disk
Column Name
Data Type
Description
adaptor_type
STRING
Adaptor type
canonical_name
STRING
Canonical name
capacity_kb
NUMBER
Capacity in KiB
device_name
STRING
Device name
device_type
STRING
Device type
domain_id
NUMBER
Foreign key to domain details
host_disk_id
NUMBER
Foreign key to host disk details
last_updated
DATE
Last modified date
model
STRING
Model
operational_state
STRING
Operational state
path_policy
STRING
Path policy
scsi_bus_nbr
NUMBER
SCSI bus number
scsi_device_name
STRING
SCSI device name
scsi_level
NUMBER
SCSI level
scsi_os_lun_nbr
NUMBER
SCSI OS LUN number
scsi_target_nbr
STRING
SCSI target number
uuid
STRING
UUID
vendor
STRING
Vendor name
virtual_system_id
NUMBER
Foreign key for VM host
virtual_system_name
STRING
VM host name
vmw_physical_disk_id
NUMBER
Foreign key for physical disk
apt_v_vmw_virtual_disk
The apt_v_vmw_virtual_disk view contains a single row for each VM virtual disk.
Table 7.23 apt_v_vmw_virtual_disk
Column Name
Data Type
Description
datastore_name
STRING
Datastore name
device_key
NUMBER
Device key
disk_label
STRING
Disk label
disk_type
STRING
Disk type
domain_id
NUMBER
Foreign key to domain details
file_name
STRING
File name
file_path
STRING
File path
is_thin_provisioned
STRING
Indicates if the virtual disk is thinly provisioned
last_updated
DATE
Last modified date
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
rdisk_lun_name
STRING
Raw disk LUN name
rdisk_mode
NUMBER
Raw disk mode
scsi_bus_num
NUMBER
SCSI bus number
scsi_bus_type
NUMBER
SCSI bus type
scsi_unit_num
NUMBER
SCSI unit number
vdisk_tot_capacity_kb
NUMBER
Virtual disk total capacity in KiB
virtual_system_id
NUMBER
Foreign key for VM Host
virtual_system_name
STRING
VM host name
vmw_datastore_id
NUMBER
Foreign key for VMW Datastore details
vmw_virtual_disk_id
NUMBER
Foreign key for virtual disk
apt_v_vmw_virtual_disk_log
The apt_v_vmw_virtual_disk_log view contains a single row for each VM virtual disk log.
Table 7.24 apt_v_vmw_virtual_disk_log
Column Name
Data Type
Description
log_date
DATE
Last modified date
partition_id
NUMBER
Foreign key for partition
total_size_kb
NUMBER
Total size in KiB
apt_v_vmw_virtual_machine
The apt_v_vmw_virtual_machine view contains a single row for each VM virtual machine.
Table 7.25 apt_v_vmw_virtual_machine
Column Name
Data Type
Description
child_thread_id
NUMBER
Child thread ID
current_snapshot
STRING
Current snapshot
domain_id
NUMBER
Foreign key to domain details
guest_state
STRING
VM Guest Tools state
host_name
STRING
Host name
ip_address
STRING
IP Address
last_updated
DATE
Last modified date
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
partition_type
STRING
Partition type
resource_pool_name
STRING
Resource pool name
tools_status
STRING
VM Tools status
tools_version
STRING
VM Tools version
total_size_kb
NUMBER
Total size in KiB
virtual_system_id
NUMBER
Foreign key for VM Host
virtual_system_name
STRING
VM host name
vm_path_name
STRING
VM path name
vmw_datastore_id
NUMBER
Foreign key for VMW Datastore details
apt_v_vmw_virtual_machine_log
The apt_v_vmw_virtual_machine_log view contains a single row for each VM virtual machine log.
Table 7.26 apt_v_vmw_virtual_machine_log
Column Name
Data Type
Description
guest_state
STRING
Guest state
log_date
DATE
Last modified date
partition_id
NUMBER
Foreign key for the partition
total_size_kb
NUMBER
Total size in KiB
apt_v_vmw_vm_datastore_usage
The apt_v_vmw_vm_datastore_usage view contains a single row for each VMWare VM guest/datastore relationship.
Table 7.27 apt_v_vmw_vm_datastore_usage
Column Name
Data Type
Description
committed_kb
NUMBER
Storage space, in KiB, on this datastore that is actually being used by the virtual machine
datastore_name
STRING
Datastore name
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
last_updated
DATE
Last modified date
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
uncommitted_kb
NUMBER
Additional storage space, in KiB, potentially used by the virtual machine on this datastore; For example, when lazily allocated disks grow, or storage for swap is allocated when powering on the virtual machine. If the virtual machine is running off delta disks (for example because a snapshot was taken), then only the potential growth of the currently used delta-disks is considered.
unshared_kb
NUMBER
Storage space, in kilobytes, occupied by the virtual machine on this datastore that is not shared with any other virtual machine
virtual_system_id
NUMBER
Foreign key for VM Host
virtual_system_name
STRING
VM host name
vmw_datastore_id
NUMBER
Foreign key for VMW Datastore details
apt_v_vmw_vmfile
The apt_v_vmw_vmfile view contains a single row for each VM file.
NOTE: Beginning with StorageConsole version 8.2, this view will list multiple rows for each vmfile, if the datastore is associated with more than one LUN.
Table 7.28 apt_v_vmw_vmfile
Column Name
Data Type
Description
array_name
STRING
Array name
datastore_name
STRING
Datastore name
file_name
STRING
VM file name
file_path
STRING
VM file path
file_size
NUMBER
VM file size in KiB (1024 bytes)
file_type
STRING
VM file type
host_id
NUMBER
Foreign key to the host details
host_name
STRING
Host name
last_updated
DATE
Last modified date
logical_unit_id
NUMBER
Foreign key to logical unit details
logical_unit_name
STRING
Logical unit name (or device number for un-named LUNs)
partition_id
NUMBER
Foreign key to VM details
storage_array_id
NUMBER
Foreign key to storage array details
virtual_system_id
NUMBER
Foreign key to the VM server details
vm_host_id
NUMBER
Foreign key to the VM server details
vm_host_name
STRING
VM server name
vm_id
NUMBER
Foreign key to VM details
vm_name
STRING
VM name
vm_status
STRING
VM status
vmw_datastore_file_id
Number
Foreign key to apt_v_vmw_datastore file
vmw_datastore_id
NUMBER
Foreign key of the datastore ID for VMWare datastore
apt_v_vmw_vmfile_not_inventory
The apt_v_vmw_vmfile_not_inventory view contains a single row for each VM file that is not in the VM inventory.
Table 7.29 apt_v_vmw_vmfile_not_inventory
Column Name
Data Type
Description
datastore_name
STRING
Datastore name
file_name
STRING
File name
file_path
STRING
File path
file_size
NUMBER
File size in KiB (1024 bytes)
file_type
STRING
File type
last_updated
DATE
Last modified date of the VM file
vmw_datastore_id
NUMBER
Foreign key of the datastore
apt_v_vmw_vmguest_disk
The apt_v_vmw_vmguest_disk view contains a single row for each VM guest disk in the VM inventory.
Table 7.30 apt_v_vmw_vmguest_disk
Column Name
Data Type
Description
capacity_gb
NUMBER
Total capacity in GiB
disk_path
STRING
Disk path
domain_id
NUMBER
Foreign key to Domain details
free_space_gb
NUMBER
Free space in GiB
host_id
NUMBER
Foreign key to Host details
host_name
STRING
Host name
partition_id
NUMBER
Foreign key to partition
partition_type
STRING
Partition type
percent_used
NUMBER
Percent of the VM guest disk in use
primary_ip_address
STRING
Primary IP address
used_space_gb
NUMBER
Used space in GiB
virtual_system_id
NUMBER
Foreign key for the VM host
virtual_system_name
STRING
VM host name
vm_guest_name
STRING
VM guest name
apt_v_vmw_vmguest_disk_log
The apt_v_vmw_vmguest_disk_log view contains a single row for each VM guest disk log.
Table 7.31 apt_v_vmw_vmguest_disk_log
Column Name
Data Type
Description
capacity_kb
NUMBER
Total capacity in KiB
disk_path
STRING
Path to the disk
free_space_kb
NUMBER
Free space in KiB
log_date
DATE
Last modified
partition_id
NUMBER
Foreign key for partition
virtual_system_id
NUMBER
Foreign key for the VM host
apt_v_vmw_vmsnapshot_log
The apt_v_vmw_vmsnapshot_log view contains a single row for each VMWare snapshot log.
Table 7.32 apt_v_vmw_vmsnapshot_log
Column Name
Data Type
Description
description
STRING
Description of the snapshot
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
full_snapshot_name
STRING
Full snapshot name
log_date
DATE
Log date
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
short_snapshot_name
STRING
Snapshot short name
virtual_system_id
NUMBER
Foreign key for VM Host
virtual_system_name
STRING
VM host name
vmw_snapshot_id
NUMBER
Foreign key for VMW snapshot
apt_v_vmw_vmsnapshot_tree
The apt_v_vmw_vmsnapshot_tree view contains a single row for each VMWare snapshot tree.
Table 7.33 apt_v_vmw_vmsnapshot_tree
Column Name
Data Type
Description
create_date
DATE
Create date
description
STRING
description
domain_id
NUMBER
Foreign key to domain details
full_snapshot_name
STRING
full snapshot name
last_updated
DATE
Last modified date
parent_snapshot_id
NUMBER
Parent vmw snapshot ID. Foreign key to vmw vmsnapshot tree details.
partition_id
NUMBER
Foreign key for partition
partition_name
STRING
Partition name
short_snapshot_name
STRING
short snapshot name
state
STRING
state
virtual_system_id
NUMBER
Foreign key for VM Host
virtual_system_name
STRING
VM Host name
vmw_snapshot_id
NUMBER
Foreign key for VMW snapshot