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_srp_id

NUMBER

Foreign key to EMC Symmetrix SRP details

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.

srp_name

STRING

EMC Symmetrix SRP name

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

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

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

clone_parent_logical_unit_id

NUMBER

Internally generated sequential ID that uniquely identifies the clone parent logical unit.

clone_state

STRING

Clone state defines the type of copy option used when creating clones: Precopy, Copy, or Copied.

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_srp_id

NUMBER

Foreign key to EMC Symmetrix SRP 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

srp_name

STRING

EMC Symmetrix SRP name

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

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

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

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

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

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

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

array_name

STRING

Array name

emc_sym_srp_id

NUMBER

Foreign key to EMC Symmetrix SRP details

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

srp_name

STRING

EMC Symmetrix SRP name

storage_array_id

NUMBER

Foreign key to storage array details

storage_group_name

STRING

Storage group name

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

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

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

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