Capacity Manager Database Views > HP EVA Database Views
  
Version 9.2.00
HP EVA Database Views
aps_v_eva_array_group
The aps_v_eva_array_group view contains a single row for each HP EVA array group.
Table 4.164 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
 
aps_v_eva_array_port
The aps_v_eva_array_port view contains a single row for each HP EVA array port.
Table 4.165 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
aps_v_eva_cache_memory
The aps_v_eva_cache_memory view contains a single row for each HP EVA cache memory.
Table 4.166 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
aps_v_eva_controller
The aps_v_eva_controller view contains a single row for each HP EVA controller.
Table 4.167 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
aps_v_eva_host
The aps_v_eva_host view contains a single row for each HP EVA host.
Table 4.168 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
aps_v_eva_host_port
The aps_v_eva_host_port view contains a single row for each HP EVA host port
Table 4.169 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
aps_v_eva_logical_unit
The aps_v_eva_logical_unit view contains a single row for each HP EVA logical unit.
Table 4.170 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
aps_v_eva_pdev
The aps_v_eva_pdev view contains a single row for each HP EVA physical device.
Table 4.171 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
aps_v_eva_storage_array
The aps_v_eva_storage_array view contains a single row for each HP EVA storage array.
Table 4.172 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