Storage Viewer for Virtual Servers Database Views > apt_v_vmw_vmfile
  
Version 10.0.01
apt_v_vmw_vmfile
The apt_v_vmw_vmfile view contains a single row for each VM file.
NOTE: Beginning with Storage Viewer 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