Virtualization Manager Database Views Version 10.0.00

Virtualization Manager Database Views

Version 10.0.00

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_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.2 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.3 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.4 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.5 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.6 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.7 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.8 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.9 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.10 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.11 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.12 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.13 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.14 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.15 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.16 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.17 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.18 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.19 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.20 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.21 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.22 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.23 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.24 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.25 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.26 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.27 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.28 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.29 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.30 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.31 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.32 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