Capacity Manager Database Views > Dell Compellent Array Database Views
  
Version 10.0.01
Dell Compellent Array Database Views
aps_v_cpl_array_group
The aps_v_cpl_array_group contains a single row for each Dell Compellent array group.
Table 4.57 aps_v_cpl_array_group
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
aps_v_cpl_controller
The aps_v_cpl_controller contains a single row for each Dell Compellent controller.
Table 4.58 aps_v_cpl_controller
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
aps_v_cpl_fc_port
The aps_v_cpl_fc_port contains a single row for each Dell Compellent array port.
Table 4.59 aps_v_cpl_fc_port
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
aps_v_cpl_iscsi_port
The aps_v_cpl_iscsi_port contains a single row for each Dell Compellent array port.
Table 4.60 aps_v_cpl_iscsi_port
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
aps_v_cpl_logical_unit
The aps_v_cpl_logical_unit contains a single row for each Dell Compellent logical unit.
Table 4.61 aps_v_cpl_logical_unit
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
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
aps_v_cpl_pdev
The aps_v_cpl_pdev contains a single row for each Dell Compellent physical device.
Table 4.62 aps_v_cpl_pdev
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
aps_v_cpl_replay
The aps_v_cpl_replay contains a single row for each Dell Compellent replay.
Table 4.63 aps_v_cpl_replay
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
aps_v_cpl_replication
The aps_v_cpl_replication contains a single row for each Dell Compellent replication.
Table 4.64 aps_v_cpl_replication
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
aps_v_cpl_server
The aps_v_cpl_server contains a single row for each Dell Compellent server.
Table 4.65 aps_v_cpl_server
Column Name
Data Type
Description
cpl_server_folder_id
NUMBER
cpl_server_id
NUMBER
Internally generated sequential ID that uniquely identifies this server in the database table.
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
server_folder_name
STRING
Server Folder name
server_index
NUMBER
Server index
system_name
STRING
System name
aps_v_cpl_server_folder
The aps_v_cpl_server_folder contains a single row for each Dell Compellent server folder.
Table 4.66 aps_v_cpl_server_folder
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
aps_v_cpl_server_port
The aps_v_cpl_server_port contains a single row for each Dell Compellent server port.
Table 4.67 aps_v_cpl_server_port
Column Name
Data Type
Description
cpl_server_id
NUMBER
Internally generated sequential ID that uniquely identifies this server in the database table.
cpl_storage_array_id
NUMBER
Internally generated sequential ID that uniquely identifies the storage array.
display_name
STRING
Host name.
host_id
NUMBER
Internally generated sequential ID that uniquely identifies the host.
last_updated
DATE
The date and time the Dell Compellent server data was last updated in the database.
port_wwn_id
NUMBER
Internally generated sequential ID that uniquely identifies the port.
system_name
STRING
System name.
wwn
STRING
Port WWN.
aps_v_cpl_storage_array
The aps_v_cpl_storage_array view contains a single row for each Dell Compellent storage array.
Table 4.68 aps_v_cpl_storage_array
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
aps_v_cpl_storage_profile
The aps_v_cpl_storage_profile contains a single row for each Dell Compellent storage profile.
Table 4.69 aps_v_cpl_storage_profile
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
aps_v_cpl_tier_class
The aps_v_cpl_tier_class contains a single row for each Dell Compellent tier class.
Table 4.70 aps_v_cpl_tier_class
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
aps_v_cpl_tier_log
The aps_v_cpl_tier_log contains a single row for each Dell Compellent tier log.
Table 4.71 aps_v_cpl_tier_log
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
aps_v_cpl_tier_type
The aps_v_cpl_tier_type contains a single row for each Dell Compellent tier type.
Table 4.72 aps_v_cpl_tier_type
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
aps_v_cpl_volume_folder
The aps_v_cpl_volume_folder contains a single row for each Dell Compellent volume folder.
Table 4.73 aps_v_cpl_volume_folder
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