Storage Viewer for Capacity Database Views > aps_v_cpl_tier_log
  
Version 10.0.01
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