HP EVA Database Views Version 9.2.01

Table 4.170 aps_v_eva_array_group
Column Name	Data Type	Description
array_group_id	NUMBER	Foreign key to aps_v_eva_array_group
comments	STRING	Comments
current_spare_policy	STRING	Current spare policy
drive_type	STRING	Drive type
last_updated	DATE	Date and time last updated
levelling_process	STRING	Levelling process
levelling_state	STRING	Levelling state
object_name	STRING	Object name
occupancy_alarm_level	NUMBER	Occupancy alarm level
requested_spare_policy	STRING	Requested spare policy
rss_disk_state	STRING	RSS disk state
src_level_actual	STRING	SRC actual level
src_level_requested	STRING	SRC level requested
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array
total_disks	NUMBER	Total disks
transition_percent	NUMBER	Transition percent
transition_state	STRING	Transition state
v_raid_0_storage_space_kb	NUMBER	RAID 0 storage space in KiB
v_raid_1_storage_space_kb	NUMBER	RAID 1 storage space in KiB
v_raid_5_storage_space_kb	NUMBER	RAID 5 storage space in KiB
v_raid_6_storage_space_kb	NUMBER	RAID 6storage space in KiB

Table 4.171 aps_v_eva_array_port
Column Name	Data Type	Description
eva_controller_id	NUMBER	Foreign key to aps_v_eva_controller
last_updated	DATE	Date and time last updated
object_name	STRING	Object name
port_id	NUMBER	Port ID
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array

Table 4.172 aps_v_eva_cache_memory
Column Name	Data Type	Description
cache_condition	STRING	Cache condition
eva_controller_id	NUMBER	aps_v_eva_controller
last_updated	DATE	Date and time last updated
memory_capacity_kb	NUMBER	Memory capacity in KiB
mirror_connection_state	STRING	Mirror connection state 1
mirror_connection_state2	STRING	Mirror connection state 2
mirror_port1_state	STRING	Mirror port 1 state
mirror_port2_state	STRING	Mirror port 2 state
object_id	STRING	Object ID
object_name	STRING	Object name
read_capacity_kb	NUMBER	Read capacity in KiB
write_capacity_kb	NUMBER	Write capacity in KiB
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array

Table 4.173 aps_v_eva_controller
Column Name	Data Type	Description
comments	STRING	Comments
data_block_size_kb	NUMBER	Data block size in KiB
eva_controller_id	NUMBER	Primary key
fan_fru	STRING	Fan FRU
firmware_version	STRING	Firmware version
last_updated	DATE	Date and time last updated
main_memory_kb	NUMBER	Main memory in KiB
manufacturer	STRING	Manufacturer
model_number	STRING	Model Number
node_name	STRING	Node name
nsc_condition	STRING	NSC Condition
object_id	STRING	Object ID
object_name	STRING	Object name
rohs_compliant	STRING	Is the controller ROHAS compliant
scell_participation	STRING	Scell participation
serial_number	STRING	Serial number
shelf_nbr	NUMBER	Shelf number
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array

Table 4.174 aps_v_eva_host
Column Name	Data Type	Description
comments	STRING	Comments
direct_eventing	STRING	Direct Eventing
eva_host_type	STRING	EVA host type
host_id	NUMBER	Foreign key to apt_v_server
last_updated	DATE	Date and time last updated
object_id	STRING	Object ID
object_name	STRING	Object name
os_mode	STRING	OS mode
OD_mode_bitmask	STRING	OS mode bitmask
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array

Table 4.175 aps_v_eva_host_port
Column Name	Data Type	Description
host_id	NUMBER	Foreign key to apt_v_server
last_updated	DATE	Date and time last updated
host_port_id	NUMER	Primary key
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array

Table 4.176 aps_v_eva_logical_unit
Column Name	Data Type	Description
allocated_capacity_kb	NUMBER	Allocated capacity in KiB
comments	STRING	Comments
creation_date	DATE	Creation date
dirty_block_count	NUMBER	Dirty block count
does_mirror_exist	STRING	Does mirror exist?
eva_controller_id	NUMBER	Foreign key to aps_v_eva_controller
family_name	STRING	Family name
host_type	STRING	Host type
is_allocated	STRING	Is allocated?
is_allocated_to_iscsi_host	STRING	Is allocated to iSCSI host?
is_mirror_suspended	STRING	Is mirror suspended?
iscsi_cont_obj_name	STRING	iSCSI object name
logical_unit_id	NUMBER	Primary key
mirror_cache	STRING	Mirror cache
os_unit_identifier	NUMBER	OS unit identifier
partition_name	STRING	Partition name
preffered_path	STRING	Preferred path
prev_clone_source_lun_uid	STRING	Previous clone source LUN UID
read_cache	STRING	Read cache
restore_progress	STRING	Restore progress
scvd_enable	STRING	SCVD enable
secondary_state	STRING	Secondary state
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array
write_cache	STRING	Write cache
write_cache_actual	STRING	Write cache actual
ww_lun_identifier	STRING	WWLUN identifier

Table 4.177 aps_v_eva_pdev
Column Name	Data Type	Description
actual_usage	STRING	Actual usage
can_locate_rrss	STRING	Can locate RSS?
comments	STRING	Comments
disk_bay_number	NUMBER	Disk bay number
disk_drive_type	STRING	Disk drive type
failure_predicted	STRING	Failure predicted?
is_disk_code_loadable	STRING	Is disk code loadable?
is_media_accessible	STRING	Is media accessible?
migration_process	STRING	Migration process
migration_state	STRING	Migration state
node_ww_identifier	STRING	Node WW identifier
object_name	STRING	Object name
pdev_id	NUMBER	Primary key
qorum_disk	STRING	Quorum disk
requested_usage	STRING	Requested usage
rss_identifier	NUMBER	RSS identifier
storage_array_id	NUMBER	Foreign key to aps_v_eva_storage_array
used_space_kb	NUMBER	Used space KB

Table 4.178 aps_v_eva_storage_array
Column Name	Data Type	Description
basic_licensed	STRING	Basic licensed
comments	STRING	Comments
control_time	DATE	Control time
controller_memory_kb	NUMBER	Controller memory in kilobytes
device_additional_policy	STRING	Device additional policy
drm_licensed	STRING	DRM licensed
firmware_version	STRING	Firmware version
last_updated	DATE	Date and time last updated
license_state	STRING	License state
management_host_ip_address	STRING	Management host IP address
management_host_name	STRING	Management host name
nbr_of_array_groups	NUMBER	Number of array groups
nbr_of_folders	NUMBER	Number of folders
nbr_of_grouped_disks	NUMBER	Number of grouped disks
nbr_of_ungrouped_disks	NUMBER	Number of ungrouped disks
os_unit_identifier	NUMBER	OS unit identifier
snap_licensed	STRING	Snap licensed
state	STRING	State
storage_array_id	NUMBER	Primary key
volume_replacement_delay_min	NUMBER	Volume replacement delay in minutes