Storage Viewer for Capacity Database Views > aps_v_storage_array
  
Version 10.0.01
aps_v_storage_array
The aps_v_storage_array view contains a single row for each storage array.
Table 4.44 aps_v_storage_array
Column Name
Data Type
Description
agent_version
STRING
Agent version
allocated_gb
NUMBER
Allocated configured capacity in GiB
allocated_kb
NUMBER
Allocated configured capacity in KiB
array_family
STRING
Array family
array_group_allocated
NUMBER
Allocated capacity of the array groups in the array
array_group_available
NUMBER
Available capacity of the array groups in the array
array_group_capacity
NUMBER
Total capacity of the array groups in the array
array_name
STRING
Array name
array_type
STRING
Array type
available_gb
NUMBER
Available configured capacity in GiB
available_kb
NUMBER
Available configured capacity in KiB
cache_gb
NUMBER
Array cache size in GiB
cache_kb
NUMBER
Array cache size in KiB
capacity_gb
NUMBER
Configured capacity in GiB
capacity_kb
NUMBER
Configured capacity in KiB
controller_version
STRING
Storage array controller version
creation_date
DATE
Date and time the storage array was added to the database
device_manager_id
NUMBER
Foreign key to device manager details
domain_id
NUMBER
Foreign key to domain details
domain_name
STRING
Domain name
estimated_used_kb
NUMBER
Total estimated used capacity (KiB) of the logical units in the array.
ip_address
STRING
IP address of the storage array
is_active
STRING
Y or N. A flag indicating if this array is still active. Y = active, N = inactive. If several arrays had been managed by a device manager and then one array is removed, this flag will indicate which array is inactive and data collection will no longer occur for the inactive array. If the inactive array is moved to a different device manager, it will be treated as a new array because it is now managed by a different device manager; a new array ID will be created and collection will occur on this array (even though it was previously flagged as an inactive array).
is_rm_enabled
STRING
A flag indicating if this replication data is collected for this array
largest_free_space_gb
NUMBER
Largest free space available on the storage array, in GiB
largest_free_space_kb
NUMBER
Largest free space available on the storage array, in KiB
last_updated
DATE
Last updated date
nbr_allocated_luns
NUMBER
Number of allocated logical units
nbr_array_ports
NUMBER
Number of array ports
nbr_hosts
NUMBER
Number of hosts
nbr_of_array_groups
NUMBER
Number of Array Groups in the array
nbr_of_ethernet_ports
NUMBER
Number of Ethernet ports in the array
nbr_of_fc_ports
NUMBER
Number of Fibre Channel ports in the array
nbr_of_iscsi_ports
NUMBER
Number of iSCSI ports in the array
nbr_of_luns
NUMBER
Number of logical units
nbr_of_physical_disks
NUMBER
Number of physical disks in the array
nbr_of_storage_pools
NUMBER
Number of storage pools in the array
nbr_of_thin_pools
NUMBER
Number of thin pools in the array
object_id
STRING
Unique internal ID for the storage array
other_allocated_gb
NUMBER
Other allocated in GiB
other_allocated_kb
NUMBER
Other allocated in KiB
pool_allocate_kb
NUMBER
Total capacity of the storage pools in the array that have LUNs created
product_name
STRING
Product name
raw_allocated_gb
NUMBER
Allocated raw capacity in GiB
raw_allocated_kb
NUMBER
Allocated raw capacity in KiB
raw_available_gb
NUMBER
Available raw capacity in GiB
raw_available_kb
NUMBER
Available raw capacity in KiB
raw_capacity_gb
NUMBER
Raw capacity in GiB
raw_capacity_kb
NUMBER
Raw capacity in KiB
replication_capacity_kb
NUMBER
Total capacity of the logical units in the array that are marked as replication storage
root_group_id
NUMBER
Foreign key to root group details
serial_nbr
STRING
Storage array serial number
storage_array_id
NUMBER
Foreign key to the storage array details
thin_pool_allocated_kb
NUMBER
Total capacity of the thin pools in the array that have LUNs created
thin_pool_available_kb
NUMBER
Total capacity of the thin pools in the array that do not have LUNs created
thin_pool_capacity_kb
NUMBER
Total capacity of the thin pools in the array
thin_pool_subscribed_kb
NUMBER
Total capacity of the thin pools in the array that are subscribed by hosts
thin_pool_subscribed_pct
NUMBER
The percentage (%) of the thin pool subscribed capacity vs thin pool total capacity
usable_external_capacity_gb
NUMBER
Usable external capacity in GiB
usable_external_capacity_kb
NUMBER
Total Capacity from back-end, external volumes in KiB
usable_free_capacity_gb
NUMBER
Usable free capacity in GiB
usable_free_capacity_kb
NUMBER
Usable free capacity in KiB
usable_internal_capacity_gb
NUMBER
Usable internal capacity in GiB
usable_internal_capacity_kb
NUMBER
Usable internal capacity in KiB
usable_used_capacity_gb
NUMBER
Usable used capacity in GiB
usabled_used_capacity_kb
NUMBER
Usable used capacity in KiB
vendor_name
STRING
Vendor name
virtualized_capacity_kb
STRING
Total capacity for volumes that are in use, but are not allocated for the virtual array