Column Name | Data Type | Description |
allocated_capacity_kb | NUMBER | Array group allocated capacity in KiB |
array_group_id | NUMBER | Foreign key to aps_v_array_group |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
free_capacity_kb | NUMBER | Array group available capacity in KiB |
group_name | STRING | The array group name |
is_assigned | STRING | A flag indicator whether the array group is assigned |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
nbr_of_volumes | NUMBER | Number of volumes |
system_name | STRING | System name |
total_capacity_kb | NUMBER | Array group total capacity in KiB |
total_spare_kb | NUMBER | Total spare capacity in KiB |
total_volume_active_kb | NUMBER | Total active volume/LUNs in KiB |
total_volume_free_kb | NUMBER | Available volume/LUNs in KiB |
total_volume_replay_kb | NUMBER | Total replay volume/LUNs in KiB |
usable_capacity_kb | NUMBER | Array group usable capacity in KiB |
Column Name | Data Type | Description |
controller_index | NUMBER | Unique identifier for the controller |
controller_name | STRING | Name of the controller |
cpl_controller_id | NUMBER | Primary key in this table |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
health_state | NUMBER | Health state of the controller |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
operational_status | STRING | Operational status of the controller |
system_name | STRING | System name |
version | STRING | Controller version |
Column Name | Data Type | Description |
cpl_controller_id | NUMBER | Foreign key to aps_v_cpl_controller |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
health_state | NUMBER | Health state for array port |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
operational_status | STRING | Operational status for array port |
port_id | NUMBER | Foreign key to aps_v_array_port |
port_name | STRING | Name of the port |
port_wwn_id | NUMBER | Foreign key to aps_wwn |
system_name | STRING | System name |
wwn | STRING | FC port WWN |
Column Name | Data Type | Description |
cpl_controller_id | NUMBER | Foreign key to aps_v_cpl_controller |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_cpl_controller |
ipv4_address | STRING | IPv4 address |
ipv6_address | STRING | IPv6 address |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
operational_status | STRING | Operational status of the ISCSI port |
port_id | NUMBER | Foreign key to aps_v_array_port |
port_name | STRING | Name of the port |
port_wwn_id | NUMBER | Foreign key to aps_wwn |
system_name | STRING | System name |
wwn | STRING | FC port WWN |
Column Name | Data Type | Description |
active_size_kb | NUMBER | Active size of the logical unit in kilobytes |
cpl_storage_array_id | NUMBER | Foreign key to aps_storage_array |
cpl_storage_profile_id | NUMBER | Foreign key to aps_v_cpl_storage_profile |
cpl_volume_folder_id | NUMBER | Foreign key to aps_cpl_volume_folder |
health_state | NUMBER | Health state for logical unit |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
logical_unit_id | NUMBER | Foreign key to aps_v_logical_unit |
logical_unit_name | STRING | Name of the logical unit |
nbr_of_replays | NUMBER | Number of replays |
operational_status | STRING | Operational status for logical unit |
replay_profile | STRING | Replay profile |
replay_size_kb | NUMBER | Replay size in KiB |
system_name | STRING | System name |
total_capacity_kb | NUMBER | Logical unit total capacity in KiB |
volume_type | STRING | Volume type |
Column Name | Data Type | Description |
actual_capacity_kb | NUMBER | Actual capacity in KiB |
bad_capacity_kb | NUMBER | Bad capacity in KiB |
capacity_kb | NUMBER | Capacity of the physical device |
classification | STRING | Classification of the physical device |
control_type | NUMBER | Control type |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
disk_index | NUMBER | Disk index |
enclosure_position | NUMBER | Enclosure position |
free_space_kb | NUMBER | Free space capacity in kilobytes |
health_state | NUMBER | Health state for physical device |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
nbr_of_read_requests | NUMBER | Number of read requests |
nbr_of_write_requests | NUMBER | Number of write requests |
operational_status | STRING | Operational status for physical device |
pdev_id | NUMBER | Foreign key to aps_pdev |
pdev_name | STRING | Name of the physical device |
product | STRING | Product for the physical device |
read_request_kb | NUMBER | Read request in KiB |
system_name | STRING | System name |
write_request_kb | NUMBER | Write request in KiB |
Column Name | Data Type | Description |
cpl_replay_id | NUMBER | Primary key in this table |
cpl_storage_array_id | NUMBER | Foreign key to aps_storage_array |
expire | DATE | Expiration date of the replay |
freeze | DATE | Freeze date of the replay |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
logical_unit_id | NUMBER | Foreign key to aps_v_logical_unit |
replay_index | NUMBER | Replay index |
replay_name | STRING | Name of the replay |
system_name | STRING | System name |
Column Name | Data Type | Description |
amount_remaining_kb | NUMBER | Amount remaining in KiB |
async_behind_kb | NUMBER | Async behind in KiB |
copy_methodology | NUMBER | Copy methodology |
copy_state | NUMBER | Copy state |
copy_type | NUMBER | Copy type |
cpl_replication_id | NUMBER | Primary key in this table |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
current_replay | STRING | Current replay |
dst_array_name | STRING | Destination storage array name |
dst_array_nbr | NUMBER | Destination storage array number |
dst_storage_array_id | NUMBER | Destination storage array ID. Foreign key to aps_v_storage_array |
last_restore_replay | STRING | Last restored replay |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
percent_complete | NUMBER | % of the replication that has completed |
progress_status | NUMBER | Progress status |
replica_type | NUMBER | Replica type |
replication_index | NUMBER | Replication index |
src_array_name | STRING | Source storage array name |
src_array_nbr | NUMBER | Source storage array number |
src_logical_unit_id | NUMBER | Source logical unit ID. Foreign key to aps_v_logical_unit |
src_storage_array_id | NUMBER | Source storage array ID. Foreign key to aps_storage_array |
src_volume_index | NUMBER | Source volume index |
src_volume_name | STRING | Source volume name |
state | NUMBER | State of the replication |
state_desc | STRING | State description |
state_message | STRING | State message |
status_time | DATE | Status date and time |
sync_type | STRING | Sync type |
system_name | STRING | System name |
when_synced | DATE | When synced |
Column Name | Data Type | Description |
cpl_server_folder_id | NUMBER | Foreign key to aps_v_cpl_server_folder |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
display_name | STRING | Host name |
host_id | NUMBER | Foreign key to apt_v_server |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
port_wwn_id | NUMBER | Foreign key to aps_wwn |
server_folder_name | STRING | Server Folder name |
server_index | NUMBER | Server index |
system_name | STRING | System name |
wwn | STRING | Host port WWN |
Column Name | Data Type | Description |
cpl_parent_server_folder_id | NUMBER | Parent server folder ID |
cpl_server_folder_id | NUMBER | Primary key in this table |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
server_folder_index | NUMBER | Server folder index |
server_folder_name | STRING | Server Folder name |
system_name | STRING | System name |
Column Name | Data Type | Description |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
free_hard_kb | NUMBER | Free Hard size in KiB |
free_soft_kb | NUMBER | Free Soft size in KiB |
health_state | NUMBER | Health State for storage array |
ip_address | STRING | IP address |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
machine_model | STRING | Machine model |
machine_type | STRING | Machine type |
nbr_allocated_luns | NUMBER | Number of allocated LUNs |
nbr_of_controllers | NUMBER | Number of controllers |
nbr_of_hba_ports | NUMBER | Number of HBA ports |
nbr_of_luns | NUMBER | Number of LUNs |
nbr_of_servers | NUMBER | Number of servers |
operational_status | STRING | Operational Status for storage array |
serial_nbr | STRING | Serial number |
storage_array_system_nbr | NUMBER | Storage array number |
system_name | STRING | System name |
system_version | STRING | System version |
total_free_kb | NUMBER | Total Soft size in KiB |
total_hard_kb | NUMBER | Total Hard size in KiB |
Column Name | Data Type | Description |
cpl_storage_array_id | NUMBER | Foreign key to aps_storage_array |
cpl_storage_profile_id | NUMBER | Primary key in this table |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
name | STRING | Storage profile name |
raid_type | STRING | RAID type |
system_name | STRING | System name |
Column Name | Data Type | Description |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
cpl_tier_class_id | NUMBER | Primary key in this table |
cpl_tier_type_id | NUMBER | Foreign key to aps_v_cpl_tier_type |
disk_classes | STRING | Disk classes |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
speed_zone | STRING | Speed Zone |
system_name | STRING | System name |
tier_class_index | NUMBER | Tier class index |
tier_type_name | STRING | Tier type name |
total_size_kb | NUMBER | Total size in KiB |
total_used_kb | NUMBER | Amount used in KiB |
Column Name | Data Type | Description |
array_group_id | NUMBER | Foreign key to aps_v_array_group |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
cpl_tier_type_id | NUMBER | Primary key in this table |
disk_classes | STRING | Disk classes |
group_name | STRING | Array group name |
log_date | DATE | Log date |
nbr_of_managed_disks | NUMBER | Number of managed disks |
nbr_of_spare_disks | NUMBER | Number of spare disks |
redundancy | NUMBER | Redundancy |
system_name | STRING | System name |
tier_type_index | NUMBER | Tier type index |
tier_type_name | STRING | Tier type name |
total_disk_free_kb | NUMBER | Total available disk in KiB |
total_managed_capacity_kb | NUMBER | Total managed capacity in KiB |
total_spare_capacity_kb | NUMBER | Total spare capacity in KiB |
total_volume_allocated_kb | NUMBER | Total volume allocated in KiB |
Column Name | Data Type | Description |
array_group_id | NUMBER | Foreign key to aps_v_array_group |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
cpl_tier_type_id | NUMBER | Primary key in this table |
disk_classes | STRING | Disk classes |
group_name | STRING | Array group name |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
nbr_of_managed_disks | NUMBER | Number of managed disks |
nbr_of_spare_disks | NUMBER | Number of spare disks |
redundancy | NUMBER | Redundancy |
system_name | STRING | System name |
tier_type_index | NUMBER | Tier Type index |
tier_type_name | STRING | Tier type name |
total_disk_free_kb | NUMBER | Total available disk in KiB |
total_managed_capacity_kb | NUMBER | Total managed capacity in KiB |
total_spare_capacity_kb | NUMBER | Total spare capacity in KiB |
total_volume_allocated_kb | NUMBER | Total volume allocated in KiB |
Column Name | Data Type | Description |
cpl_parent_volume_folder_id | NUMBER | Parent volume folder ID |
cpl_storage_array_id | NUMBER | Foreign key to aps_v_storage_array |
cpl_volume_folder_id | NUMBER | Primary key in this table |
last_updated | DATE | Date and time this data was last updated in the StorageConsole database |
name | STRING | Volume folder name |
system_name | STRING | System name |
volume_folder_index | NUMBER | Volume folder index |