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 |
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 |
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 |
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 |
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 |
remote_host_name | STRING | Remote host name |
remote_path_name | STRING | Remote path 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |