Column Name | Data Type | Description |
allocated_capacity_gb | NUMBER | Allocated configured capacity in GiB. |
allocation_unit_gb | NUMBER | Growth increment allocated when Storage Volume or Dynamic Pool set to grow on demand. |
array_group_id | NUMBER | Foreign key to aps_array_group. |
array_grp_operational_status | STRING | Operational status for array group. |
current_space_used_gb | NUMBER | Space being used by all Storage Volumes allocated from pool, including RAID overhead. |
disk_device_type | NUMBER | Disk device type. |
free_capacity_gb | NUMBER | Free configured capacity in GiB. |
group_name | STRING | Name of the array group. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
last_updated | DATE | Last updated date. |
low_space_warning_threshold | NUMBER | Percentage low space warning threshold. |
object_id | STRING | Unique internal identifier for the array group. |
pool_type | NUMBER | Instance of TPD_Storage Pool, instance of TPD_DynamicStoragePool. |
snapdata_warning_limit_gb | NUMBER | Warning if space allocated exceeds this amount. |
space_limit_determination | NUMBER | Space limit determination. |
space_limit_gb | NUMBER | Space limit in GiB. |
system_name | STRING | System name. |
thin_provision_metadata_gb | NUMBER | Size of meta data consumed by pool. |
total_capacity_gb | NUMBER | Total configured capacity in GiB. |
usable_capacity_gb | NUMBER | Usable capacity after RAID overhead. |
used_snapadmin_metadata_gb | NUMBER | Actually allocated snapshot admin in GiB. |
used_snapadmin_space_gb | NUMBER | Allocated for snapshot admin space in GiB. |
used_snapdata_metadata_gb | NUMBER | Actually allocated not including RAID overhead. |
used_snapdata_space_gb | NUMBER | Allocated for snapshot data in pool, not including RAID overhead. |
used_space_gb | NUMBER | Consumed space in GiB. |
Column Name | Data Type | Description |
active_cos | STRING | Active COS. |
active_fc_type | STRING | Active port type. |
class_support | NUMBER | Class support. |
connection_type | NUMBER | Connection type. |
device_type | NUMBER | Device type. |
fc_configuration | NUMBER | Port configuration. |
fc_device_id_ext | STRING | Unique identifier for FC port. |
fc_operational_status | STRING | Operational status for FC port. |
fc_other_operational_status | STRING | Other operational status. |
fc_speed | NUMBER | FC port speed. |
fc_topology | NUMBER | Topology. |
fc_vcn | NUMBER | VCN. |
h3p_node_id | NUMBER | Foreign key to aps_h3p_node. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
is_auto_sense | STRING | Auto sense indicator. |
is_full_duplex | STRING | Full duplex indicator. |
last_updated | DATE | Last updated date. |
max_speed | NUMBER | Maximum speed. |
object_id | STRING | A unique identifier for array port. |
permanent_address | STRING | Permanent address. |
port_id | NUMBER | Foreign key to aps_array_port. |
port_name | STRING | Port name. |
port_nbr | NUMBER | Port number. |
port_type | NUMBER | Port type. |
port_wwn_id | NUMBER | Foreign key to port world wide name detail. |
system_name | STRING | System name. |
usage_restriction | NUMBER | Usage restriction. |
Column Name | Data Type | Description |
h3p_node_id | NUMBER | Foreign key to aps_h3p_node. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
is_auto_sense | STRING | Auto sense indicator. |
is_full_duplex | STRING | Full duplex. |
iscsi_device_id_ext | STRING | Unique identifier for ISCSI port. |
last_updated | DATE | Last updated date. |
network_address | STRING | Network address. |
object_id | STRING | A unique identifier for array port. |
operational_status | STRING | Operational status for ISCSI port. |
other_operational_status | STRING | Other operational status. |
port_id | NUMBER | Foreign key to aps_array_port. |
port_name | STRING | Port name. |
port_nbr | NUMBER | Port number. |
port_type | NUMBER | Port type. |
port_wwn_id | NUMBER | Foreign key to port world wide name details. |
system_name | STRING | System name. |
Column Name | Data Type | Description |
extent_status | STRING | Extent status. |
h3p_ldev_id | NUMBER | System generated identifier. Primary key in this view. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
last_updated | DATE | Last updated date. |
ldev_device_id_ext | STRING | Unique identifier for logical device. |
ldev_operational_status | STRING | Operational status for logical device. |
raw_capacity_gb | NUMBER | Raw capacity in GiB. |
system_name | STRING | System name. |
usable_capacity_gb | NUMBER | Usable capacity in GiB. |
Column Name | Data Type | Description |
backup_node1 | NUMBER | Backup node one. |
backup_node2 | NUMBER | Backup node two. |
consumable_admin_gb | NUMBER | Consumable admin capacity in GiB. |
consumable_copy_gb | NUMBER | Consumable copy capacity in GiB. |
current_availability | NUMBER | Current availability. |
data_redundancy | NUMBER | Data redundancy. |
date_created | DATE | Date created. |
device_nbr | NUMBER | Device number. |
disk_device_type | NUMBER | Disk device type. |
expiration_time | DATE | Expiration time. |
export_state | NUMBER | Export state. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
is_thinly_provisioned | STRING | Thin provisioned indicator. |
is_underlying_redundancy | STRING | Underlying redundancy indicator. |
last_updated | DATE | Last updated date. |
logical_unit_id | NUMBER | Foreign key to aps_logical_unit. |
logical_unit_name | STRING | Logical unit name. |
lun_access | NUMBER | Logical unit access. |
lun_domain | STRING | Logical unit domain. |
lun_operational_status | STRING | Operational status for logical unit. |
lun_other_operational_status | STRING | Other operational status. |
lun_policy | NUMBER | Logical unit policy. |
master_node | NUMBER | Master node. |
name_format | NUMBER | Name format. |
name_space | NUMBER | Name space. |
object_id | STRING | Unique identifier for logical unit. |
package_redundancy | NUMBER | Package redundancy. |
preferred_availability | NUMBER | Preferred availability. |
raw_admin_gb | NUMBER | Raw admin capacity in GiB. |
raw_blocks_gb | NUMBER | Raw blocks in GiB. |
raw_copy_gb | NUMBER | Raw copy capacity in GiB. |
retention_time | DATE | Retention time. |
set_data | NUMBER | Set data. |
set_size | NUMBER | Set size. |
snap_dsp_name | STRING | Snap dsp name. |
snap_space_allocation_limit | NUMBER | Snap space allocation limit. |
snap_space_allocation_warning | NUMBER | Snap space allocation warning. |
system_name | STRING | System name. |
total_capacity_gb | NUMBER | Total capacity in GiB. |
used_snapshot_admin_space_gb | NUMBER | Used snapshot admin space in GiB. |
used_snapshot_data_space_gb | NUMBER | Used snapshot data space in GiB. |
user_dsp_name | STRING | User dsp name. |
user_space_allocation_limit | NUMBER | User space allocation limit. |
user_space_allocation_warning | NUMBER | User space allocation warning. |
volume_type | NUMBER | Volume type. |
Column Name | Data Type | Description |
device_nbr | NUMBER | Device number. |
h3p_ldev_id | NUMBER | Foreign key to aps_h3p_ldev. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
last_updated | DATE | Last updated date. |
ldev_device_id_ext | STRING | Unique identifier for logical device. |
logical_unit_id | NUMBER | Foreign key to aps_logical_unit. |
logical_unit_name | STRING | Logical unit name. |
object_id | STRING | Unique identifier for logical unit. |
raw_capacity_gb | NUMBER | Raw capacity in GiB. |
system_name | STRING | System name. |
total_capacity_gb | NUMBER | Total capacity in GiB. |
usable_capacity_gb | NUMBER | Usable capacity in GiB. |
Column Name | Data Type | Description |
capacity_gb | NUMBER | Capacity in gigabytes. |
disk_type | STRING | Disk type. |
h3p_ldev_id | NUMBER | Foreign key to aps_h3p_ldev. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
last_updated | DATE | Last updated date. |
ldev_device_id_ext | STRING | Unique identifier for logical device. |
pdev_id | NUMBER | Foreign key to aps_pdev. |
pdev_name | STRING | Physical device name. |
raw_capacity_gb | NUMBER | Raw capacity in GiB. |
rpm | NUMBER | RPM. |
serial_nbr | STRING | Serial number. |
system_name | STRING | System name. |
usable_capacity_gb | NUMBER | Usable capacity in GiB. |
Column Name | Data Type | Description |
bios_version | STRING | Bios version. |
cache_enabled | NUMBER | The number of cache enabled. |
description | STRING | Description for node. |
element_name | STRING | Element name. |
h3p_node_id | NUMBER | System generated identifier. Primary key to this view. |
h3p_storage_system_id | STRING | Foreign key to aps_v_h3p_storage_system. |
is_cluster | STRING | Cluster indicator. |
is_master | STRING | Master node indicator. |
is_online | STRING | Online indicator. |
kernel_version | STRING | Kernel version. |
last_updated | DATE | Last updated date. |
node_name | STRING | Name of the node system. |
node_operational_status | STRING | Operational status for node. |
node_other_operational_status | STRING | Other operational status. |
node_position | NUMBER | Node position. |
system_name | STRING | System name. |
Column Name | Data Type | Description |
bus_speed | NUMBER | Bus speed. |
element_name | STRING | Element name. |
h3p_node_cpu_id | NUMBER | System generated identifier. Primary key in this view. |
h3p_node_id | NUMBER | Foreign key to aps_h3p_node. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
last_updated | DATE | Last updated date. |
manufacturer | STRING | Manufacturer. |
ncpu_device_id_ext | STRING | Unique identifier for node cpu. |
ncpu_model | STRING | Model. |
ncpu_role | STRING | Node cpu role. |
node_name | STRING | Name of the node |
system_name | STRING | System name. |
Column Name | Data Type | Description |
cage_type | NUMBER | Cage type. |
capacity_gb | NUMBER | Capacity in gigabytes. |
chunk_normal_unused_fail | NUMBER | Chunk normal unused failed capacity. |
chunk_normal_unused_free | NUMBER | Chunk normal unused free capacity. |
chunk_normal_unused_uninit | NUMBER | Chunk normal unused uninit capacity. |
chunk_normal_used_fail | NUMBER | Chunk normal used failed capacity. |
chunk_normal_used_ok | NUMBER | Chunk normal used ok capacity. |
chunk_size | NUMBER | Chunk size. |
chunk_spare_unused_fail | NUMBER | Chunk spare unused failed capacity. |
chunk_spare_unused_free | NUMBER | Chunk spare unused free capacity. |
chunk_spare_unused_uninit | NUMBER | Chunk spare unused uninit capacity. |
chunk_spare_used_fail | NUMBER | Chunk spare used failed capacity. |
chunk_spare_used_ok | NUMBER | Chunk spare used ok capacity. |
correctable_read_error | NUMBER | Correctable read error. |
correctable_write_error | NUMBER | Correctable write error. |
disk_type | STRING | Disk type. |
esi_state | NUMBER | ESI state. |
firmware_status | NUMBER | Firmware status. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_h3p_storage_system. |
initiator_porta | STRING | Initiator port A. |
initiator_portb | STRING | Initiator port B. |
is_esi | STRING | ESI. |
is_ld_allocatable | STRING | Logical device allocatable indicator. |
last_updated | DATE | last updated date. |
pdev_id | NUMBER | Foreign key to aps_pdev. |
pdev_name | STRING | Pdev name. |
pdev_operational_status | STRING | Operational status for pdev. |
pdev_other_operational_status | STRING | Other operational status. |
pdev_position | NUMBER | Position. |
primary_port_path | STRING | Primary port path. |
rpm | NUMBER | Revolutions per minute. |
serial_nbr | STRING | Serial Number. |
state_on_loopa | NUMBER | State on loop A. |
state_on_loopb | NUMBER | State on loop B. |
system_name | STRING | System name. |
uncorrectable_read_error | NUMBER | Uncorrectable read error. |
uncorrectable_write_error | NUMBER | Uncorrectable write error. |
Column Name | Data Type | Description |
alloc_snapadmin_gb | NUMBER | Allocated snapshot admin in GiB. |
alloc_snapdata_gb | NUMBER | Allocated snapshot data capacity in GiB. |
build_number | NUMBER | Build number. |
free_hard_gb | NUMBER | Free hard size in GiB. |
free_soft_gb | NUMBER | Free soft size in GiB. |
h3p_storage_system_id | NUMBER | Foreign key to aps_v_storage_array. |
install_date | DATE | Install date. |
ipv4_address | STRING | IP v4 address. |
last_updated | DATE | Last updated date. |
location | STRING | Location. |
machine_model | STRING | Machine model. |
machine_type | STRING | Machine type. |
max_space_limit_gb | NUMBER | Max space limit in GiB. |
nbr_allocated_luns | NUMBER | Number of allocated LUNs. |
nbr_of_10gb_ports | NUMBER | Number of 10gb ports. |
nbr_of_1gb_ports | NUMBER | Number of 1gb ports. |
nbr_of_assoc_ldev | NUMBER | Number of associated logical devices. |
nbr_of_hosts | NUMBER | Number of hosts. |
nbr_of_logical_disks | NUMBER | Number of logical disks. |
nbr_of_luns | NUMBER | Number of luns. |
operational_status | STRING | Operational status for storage system. |
primary_owner_contact | STRING | Primary owner contact. |
primary_owner_name | STRING | Primary owner name. |
serial_nbr | STRING | Serial number. |
system_name | STRING | System name. |
system_version | STRING | System version. |
time_zone | STRING | Time zone. |
total_free_gb | NUMBER | Total soft size in GiB. |
total_hard_gb | NUMBER | Total hard size in GiB. |
vlun_capacity_gb | NUMBER | Virtual logical unit capacity in GiB. |