Column Name | Data Type | Description |
allocated_capacity_gb | NUMBER | Allocated configured capacity in Gigabytes |
array_group_id | NUMBER | Foreign key to array group (RAID group) details |
array_name | STRING | Array name |
chassis_nbr | NUMBER | Chassis Number |
emc_sym_tier_id | NUMBER | Foreign key to EMC symmetrix tier details |
free_capacity_gb | NUMBER | Free configured capacity in Gigabytes |
group_name | STRING | Name of the server group |
group_nbr | NUMBER | Group Number |
is_external | STRING | Whether the Array Group is external or not |
last_updated | DATE | Last updated date |
object_id | STRING | Unique internal identifier for the array group |
overhead_gb | NUMBER | Overhead in Gigabytes |
raid_type | STRING | RAID type of used by the volume: possible values disk - non raided else RAID1,RAID2...RAID5 etc. |
storage_array_id | NUMBER | Foreign key to storage array details |
tier_name | STRING | Tier name |
total_capacity_gb | NUMBER | Total configured capacity in Gigabytes |
usable_capacity_gb | NUMBER | Usable capacity after RAID overhead |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_fast_policy_id | NUMBER | System-generated identifier for the FAST policy. Primary key in this view |
emulation_type | STRING | Emulation type |
fast_policy_name | STRING | FAST policy name |
last_updated | DATE | Last updated date |
storage_array_id | NUMBER | Foreign key to storage array details |
Column Name | Data Type | Description |
allocated_capacity_gb | NUMBER | Allocated capacity in GiB (calculated from KiB) |
allocated_capacity_kb | NUMBER | Allocated capacity in KiB |
array_family | STRING | Array family |
array_group_id | NUMBER | Foreign key to array group (RAID group) details |
array_name | STRING | Array name |
bcv_device_assoc_cg_name | STRING | BCV device associated CG name |
bcv_device_assoc_grp_name | STRING | BCV device associated group name |
bcv_device_status | STRING | BCV device status |
bcv_last_action_date | DATE | BCV last action date |
bcv_mirror_state | STRING | BCV mirror state |
bcv_split_pct | NUMBER | BCV split in percentage |
bvc_pair_state | STRING | BCV pair state |
device_group_name | STRING | Device group name |
device_rdf_state | STRING | Device RDF state |
device_rdf_status | STRING | Device RDF status |
device_state | STRING | Device state |
emc_rdf_group_id | NUMBER | Foreign key to EMC rdf group details |
emc_sym_storage_grp_id | NUMBER | Foreign key to EMC Symmetrix storage group details. |
emc_sym_storage_pool_id | NUMBER | Foreign key to EMC Symmetrix storage pool details |
emulation_type | STRING | Device Emulation Type - whether FB or CKD |
free_capacity_gb | NUMBER | Free capacity in GiB (calculated from KiB) |
free_capacity_kb | NUMBER | Free capacity in KiB |
group_name | STRING | Array group name in which this LUN resides |
is_bound | STRING | Indicates if the device is bound (Y, N) |
is_mapped | STRING | Y=Yes, N=No. The device is mapped to front end ports or not |
is_mapped_not_masked | STRING | Y=Yes, N=No. The device is mapped to front end ports but not masked to a host or not |
is_synchronized | STRING | Y=Yes, N=No. The device is synchronized or not |
last_updated | DATE | Last updated date |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name |
lun_type | STRING | LUN type |
nbr_allocated_luns | NUMBER | Total number of allocated logical units on the parent of this LUN |
nbr_of_luns | NUMBER | Number of logical units |
normalized_raid_type | STRING | Normalized RAID type |
object_id | STRING | Unique internal identifier for the logical unit |
parental_logical_unit_id | NUMBER | Parent logical unit ID. Foreign key to logical unit details |
pool_name | STRING | EMC Symmetrix storage pool name |
raid_type | STRING | RAID type of used by the volume: possible values disk - non-raided else RAID1,RAID2...RAID5 etc |
rdf_grp_name | STRING | RDF (RA) Group Name |
rdf_grp_nbr | NUMBER | RDF (RA) Group Number |
rdf_mode | STRING | RDF mode |
rdf_state | STRING | RDF state |
rdf_type | STRING | RDF type |
remote_device_rdf_state | STRING | Remote device RDF state |
std_device_cg_name | STRING | Standard device CG name |
std_device_grp_name | STRING | Standard device group name |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_group_name | STRING | EMC Symmetrix storage group name |
sym_lun_device_name | STRING | EMC Symmetrix LUN device name |
total_capacity_gb | NUMBER | Total capacity in GiB |
total_capacity_kb | NUMBER | Total capacity in KiB |
used_capacity_gb | NUMBER | Used capacity in GiB (calculated from KiB) |
used_capacity_kb | NUMBER | Used capacity in kilobytes |
written_capacity_gb | NUMBER | Written capacity in GiB (calculated from KiB) |
written_capacity_kb | NUMBER | Written capacity in KiB |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_fast_policy_id | NUMBER | Foreign key to EMC symmetrix FAST policy details |
emc_sym_storage_grp_id | NUMBER | Foreign key to EMC symmetrix storage group details |
emc_sym_tier_id | NUMBER | Foreign key to EMC symmetrix tier details |
fast_policy_name | STRING | FAST policy name |
last_updated | DATE | Last updated date |
priority | NUMBER | Priority of the storage group in the policy |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_group_name | STRING | EMC Symmetrix storage group name |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_fast_policy_id | NUMBER | Foreign key to EMC Symmetrix FAST policy details |
emc_sym_tier_id | NUMBER | Foreign key to EMC Symmetrix tier details |
fast_policy_name | STRING | FAST policy name |
last_updated | DATE | Last updated date |
max_storage_group_pct | NUMBER | Maximum percent the tier can be used by the policy |
storage_array_id | NUMBER | Foreign key to storage array details |
tier_name | STRING | Tier name |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_storage_grp_id | NUMBER | Foreign key to EMC Symmetrix storage group details |
last_updated | DATE | Last updated date |
logical_unit_id | NUMBER | Foreign key to logical unit details |
logical_unit_name | STRING | Logical unit name |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_group_name | STRING | EMC Symmetrix storage group name |
Column Name | Data Type | Description |
array_name | STRING | Array name |
director_id | STRING | Director Identification |
director_numeric_nbr | NUMBER | Director Numeric Number |
director_slot_nbr | NUMBER | Director Slot Number |
director_status | STRING | Director status |
director_symbolic_nbr | STRING | Director Symbolic Number |
director_type | STRING | Director type |
emc_rdf_group_id | NUMBER | Foreign key to EMC rdf group details |
emc_symmetrix_port_id | NUMBER | Foreign key to EMC Symmetrix port details |
last_updated | DATE | Last updated date |
node_wwn | STRING | The worldwide node name that is assigned to the symmetrix port |
node_wwn_id | NUMBER | Foreign key to WWN |
prevent_auto_rdf_link_recovery | STRING | Prevent Automatic RDF Link Recovery |
prevent_ra_online_upon_poweron | STRING | Prevent RAs Online Upon Power ON |
rdf_grp_name | STRING | RDF (RA) Group Name |
rdf_grp_nbr | NUMBER | RDF (RA) Group Number |
remote_symmetrix_id | STRING | Remote Symmetrix ID it got connected to |
remote_symmetrix_port_id | NUMBER | Foreign key to remote EMC symmetrix port details |
remote_symmetrix_symbolic_nbr | STRING | Remote RDF (RA) Director Symbolic |
storage_array_id | NUMBER | Foreign key to storage array details |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_storage_grp_id | NUMBER | EMC Symmetrix storage group ID |
is_fast_policy | STRING | Indicating if storage group is part of the FAST policy or not. Y/N |
is_masking_views | STRING | Indicating if storage group has masking views or not. Y/N |
last_updated | DATE | Last updated date |
nbr_of_storage_groups | NUMBER | Existing Storage Group contains number of other Storage Group |
parent_storage_grp_id | NUMBER | Foreign key into aps_v_emc_sym_storage_grp to locate the parent of this storage group if any |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_group_name | STRING | Storage group name |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_initiator_grp_id | NUMBER | Foreign key to EMC Symmetrix initiator group details |
emc_sym_masking_view_id | NUMBER | Foreign key to EMC Symmetrix masking view details |
emc_sym_port_grp_id | NUMBER | Foreign key to EMC Symmetrix port group details |
emc_sym_storage_grp_id | NUMBER | Foreign key to EMC Symmetrix storage group details |
initiator_group_name | STRING | EMC Symmetrix initiator group name |
last_updated | DATE | Last updated date |
masking_view_name | STRING | EMC Symmetrix masking view name |
path_id | NUMBER | Path ID |
port_group_name | STRING | EMC Symmetrix port group name |
storage_array_id | NUMBER | Foreign key to storage array details |
storage_group_name | STRING | Storage group name |
Column Name | Data Type | Description |
array_name | STRING | Array name |
dev_config | STRING | Device configuration |
dev_emulation | STRING | Device emulation |
emc_sym_storage_pool_id | NUMBER | Foreign key to EMC Symmetrix storage pool details |
emc_sym_tier_id | NUMBER | Foreign key to EMC Symmetrix tier details |
last_updated | DATE | Last updated date |
pct | NUMBER | Percentage |
pool_name | STRING | EMC Symmetrix storage pool name |
storage_array_id | NUMBER | Foreign key to storage array details |
subscribed_pct | NUMBER | Subscribed percentage |
tier_name | STRING | EMC Symmetrix tier name |
total_enabled_tracks_gb | NUMBER | Total enabled tracks in GiB |
total_enabled_tracks_kb | NUMBER | Total enabled tracks in KiB |
total_tracks_gb | NUMBER | Total tracks in GiB |
total_tracks_kb | NUMBER | Total tracks in KiB |
total_used_tracks_gb | NUMBER | Total used tracks in GiB |
total_used_tracks_kb | NUMBER | Total used tracks in KiB |
Column Name | Data Type | Description |
array_name | STRING | Array name |
available_capacity_gb | NUMBER | Available capacity in GiB (calculated from KiB) |
available_capacity_kb | NUMBER | Available capacity in KiB |
emc_sym_storage_pool_id | NUMBER | Foreign key to EMC Symmetrix storage pool details |
log_date | DATE | Log date |
pool_name | STRING | EMC Symmetrix storage pool name |
storage_array_id | NUMBER | Foreign key to storage array details |
subscribed_capacity_gb | NUMBER | Subscribed capacity in GiB (calculated from KiB) |
subscribed_capacity_kb | NUMBER | Subscribed capacity in KiB |
total_capacity_gb | NUMBER | Total capacity in GiB (calculated from KiB) |
total_capacity_kb | NUMBER | Total capacity in KiB |
used_capacity_gb | NUMBER | Used capacity in GiB (calculated from KiB) |
used_capacity_kb | NUMBER | Used capacity in KiB |
Column Name | Data Type | Description |
array_name | STRING | Array name |
emc_sym_tier_id | NUMBER | System generated identifier for the tier. Primary key in this view |
storage_array_id | NUMBER | Foreign key to storage array details |
tier_name | STRING | Tier name |
tier_type | STRING | Tier Type: DP = Disk Group Provisioning, VP = Virtual Pools |
disk_location | STRING | Whether the Disk is Located internally or Externally |
emulation | STRING | Emulation of the Tier: CKD or FBA |
allocated_capacity_gb | NUMBER | Allocated Capacity of tier in GiB |
enabled_capacity_gb | NUMBER | Enabled capacity of the Tier in GiB |
free_capacity_gb | NUMBER | Free capacity of the Tier in GiB |
include_type | STRING | Indicates whether the Tier is static or dynamic |
raid_type | STRING | RAID type of the Tier |
disk_type | STRING | Disk Type of the Tier: EFD, FC, SATA |
last_updated | DATE | Last updated date |