Capacity Manager Database Views > EMC CLARiiON Array Database Views
  
Version 9.2.00
EMC CLARiiON Array Database Views
aps_v_emc_cla_logical_unit
The aps_v_emc_cla_logical_unit view contains a single row for each EMC CLARiiON logical unit.
Table 4.73 aps_v_emc_cla_logical_unit
Column Name
Data Type
Description
array_name
STRING
Storage array name
consumed_capacity_gb
NUMBER
Consumed capacity
emc_cla_storage_pool_id
NUMBER
EMC CLARiiON storage pool ID
is_thin
STRING
Indicates if it is thinly provisioned storage
last_updated
DATE
Last updated date
logical_unit_id
NUMBER
Logical unit ID
logical_unit_name
STRING
Logical unit name
pool_name
STRING
Storage pool name
storage_array_id
NUMBER
Storage array ID
aps_v_emc_cla_pdev
The aps_v_emc_cla_pdev view contains a single row for each EMC CLARiiON physical device.
Table 4.74 aps_v_emc_cla_pdev
Column Name
Data Type
Description
array_name
STRING
Storage array name
emc_cla_storage_pool_id
NUMBER
Storage pool ID
last_updated
DATE
Last updated date
pdev_id
NUMBER
PDEV ID
pool_name
STRING
Storage pool name
storage_array_id
NUMBER
Foreign key to logical storage
aps_v_emc_cla_storage_pool
The aps_v_emc_cla_storage_pool view contains a single row for each EMC CLARiiON storage pool.
Table 4.75 aps_v_emc_cla_storage_pool
Column Name
Data Type
Description
array_name
STRING
Storage array name
available_capacity_blk
NUMBER
Available capacity in blocks
available_capacity_gb
NUMBER
Available capacity in GiB
consumed_capacity_blk
NUMBER
Consumed capacity in blocks
consumed_capacity_gb
STRING
Consumed capacity in GiB
description
STRING
Storage Pool description
disk_type
STRING
Disk type
emc_cla_storage_pool_id
NUMBER
Foreign key to logical storage pool details
full_threshold_pct
NUMBER
Full threshold percentage
last_updated
DATE
Last updated date
over_subscribed_blk
NUMBER
Over-subscribed capacity in blocks
over_subscribed_gb
NUMBER
Over-subscribed capacity in GiB
pool_name
STRING
Storage pool name
raid_type
STRING
RAID type
raw_capacity_blk
NUMBER
Raw capacity in blocks
raw_capacity_gb
NUMBER
Raw capacity in GiB
state
STRING
Storage Pool status
storage_array_id
NUMBER
Storage array ID
subscribed_pct
NUMBER
Subscribed percentage
total_subscribed_capacity_blk
NUMBER
Total subscribed capacity in blocks
total_subscribed_capacity_gb
NUMBER
Total subscribed capacity in GiB
user_capacity_blk
STRING
User capacity in blocks
user_capacity_gb
NUMBER
User capacity in GiB
aps_v_emc_cla_storage_pool_log
The aps_v_emc_cla_storage_pool_log view contains a single row for each EMC CLARiiON storage pool log.
Table 4.76 aps_v_emc_cla_storage_pool_log
Column Name
Data Type
Description
storage_array_id
NUMBER
Storage array ID
array_name
STRING
Storage array name
emc_cla_storage_pool_id
NUMBER
Storage pool ID
pool_name
STRING
Storage pool name
consumed_capacity_gb
NUMBER
Consumed capacity in GiB
available_capacity_gb
NUMBER
Available capacity in GiB
total_subscribed_capacity_gb
NUMBER
Total subscribed capacity in GiB
log_date
DATE
Log date