Storage Viewer for Capacity Database Views > aps_v_emc_sym_srp
  
Version 10.0.01
aps_v_emc_sym_srp
The aps_v_emc_sym_srp view contains a single row for each EMC Symmetrix storage resource pool (SRP).
Table 4.133 aps_v_emc_sym_srp
Column Name
Data Type
Description
allocated_capacity_gb
NUMBER
Indicates the sum of the device allocations, snapshot allocations, and SRDF/A DSE allocations on the SRP (Storage Resource Pool) in GiB
allocated_capacity_kb
NUMBER
Indicates the sum of the device allocations, snapshot allocations, and SRDF/A DSE allocations on the SRP (Storage Resource Pool) in KiB
array_name
STRING
Array name
creation_date
DATE
Date and time this SRP (Storage Resource Pool) was created
emc_sym_srp_id
NUMBER
Foreign key to EMC symmetrix SRP details
free_capacity_kb
NUMBER
It is the difference between the usable and the allocated capacity in KiB
last_updated
DATE
Last updated date
nbr_of_luns
NUMBER
Number of LUNs associated with the EMC Symmetrix SRP (Storage Resource Pool)
nbr_of_pdevs
NUMBER
Number of Physical Disks associated with the EMC Symmetrix SRP (Storage Resource Pool)
srp_name
STRING
Name of the Storage Resource Pool
storage_array_id
NUMBER
Foreign key to storage array details
subscribed_capacity_gb
NUMBER
Subscribed Capacity — It is sum of the sizes of all the thin devices subscribed against the SRP (Storage Resource Pool) in GiB
subscribed_capacity_kb
NUMBER
Subscribed Capacity — It is sum of the sizes of all the thin devices subscribed against the SRP (Storage Resource Pool) in KiB
subscribed_pct
NUMBER
Subscribed Capacity percentage — It is the percentage of the Usable Capacity used by thin devices
usable_capacity_gb
NUMBER
Indicates the usable capacity of all the disk groups in the SRP (Storage Resource Pool) in GiB
usable_capacity_kb
NUMBER
Indicates the usable capacity of all the disk groups in the SRP (Storage Resource Pool) in KiB