EMC VNX Array Database Views Version 10.0.00

Table 4.135 aps_v_vnx_array_group
Column Name	Data Type	Description
array_group_id	NUMBER	Internal key, foreign key to (RAID group) aps_array_group.array_group_id
array_group_obj_id	STRING	RAID group Configuration id column
last_updated	DATE	Last updated date
state	STRING	RAID group Configuration state column
storage_obj_id	STRING	Specifies ID of the RAID group Configuration storage
system_name	STRING	System name
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.136 aps_v_vnx_array_port
Column Name	Data Type	Description
agent_version	STRING	Specifies the agent (Navisphere) version of the storage processor
last_updated	DATE	Last updated date
microcode_version	STRING	Specifies the version (revision) of the microcode (Flair code version)
port_id		Internal key, foreign key to the aps_array_port.port_id
storage_obj_id	STRING	Specifies ID of the storage that incorporates this storage processor
storage_processor_id	STRING	Specifies ID of the storage processor
switch_uid	STRING	Specifies unique ID of the switch to which this port is connected
system_name	STRING	System name
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.137 aps_v_vnx_backend_storage_sys
Column Name	Data Type	Description
backend_ss_uid	STRING	Specifies the CLARiiON UID identifier
cache_kb	NUMBER	Returns the size of the cache in this storage system
component_type	STRING	Returns the type of component. In this case, it is storage System
disk_count	NUMBER	Returns the number of physical disk devices in this storage system
frontend_system_name	STRING	System name
high_watermark_pct	NUMBER	Specifies the percentage of dirty pages required to start a cache flush
is_local	CHAR	Indicates that if false then the storage is a remote storage system
last_updated	DATE	Last updated date
low_watermark_pct	NUMBER	Specifies the percentage of dirty pages required to stop a cache flush
max_severity	STRING	Returns the maximum (worst) severity among all problems that the task or query experienced during the run
nbr_of_luns	NUMBER	Number of logical units
nbr_of_raid_groups	NUMBER	Specifies the number of RAID groups
nbr_of_storage_groups	NUMBER	Specifies the number of storage groups
nbr_of_visible_luns	NUMBER	Number of visible LUNs
serial_nbr	STRING	Returns the EMC Serial number assigned to this storage System
snapshot_time_sec	NUMBER	Specifies the GMT time in seconds when this snapshot of data was taken
software_version	STRING	Returns the software version of this system software
ss_model	STRING	Returns EMC storage model
storage_obj_id	STRING	Specifies the ID of the storage system
system_name	STRING	Returns the Celerra name of this storage system
up_time	STRING	Returns the time passed since Symmetrix bootup
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.138 aps_v_vnx_checkpoint
Column Name	Data Type	Description
baseline_checkpoint_id	NUMBER	Returns the baseline check point id, if the checkpoint is a baseline checkpoint
checkpoint_name	STRING	Returns the name of the checkpoint
checkpoint_obj_id	STRING	Specifies the ID of the checkpoint
checkpoint_state	STRING	Returns the checkpoint state
checkpoint_time	DATE	Returns the time the checkpoint was taken
file_system_size_kb	NUMBER	Returns the apparent size of the file system to clients; that is, the size of the source file system at the moment the checkpoint was taken
last_updated	DATE	Last updated date
system_name	STRING	System name
vnx_checkpoint_id	NUMBER	Internal Key, Primary key in aps_v_vnx_checkpoint
vnx_file_system_id	NUMBER	Internal Key, foreign key to the aps_vnx_file_system
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id
writeable_checkpoint_id	NUMBER	Returns the writable checkpoint id, if the checkpoint is a baseline checkpoint

Table 4.139 aps_v_vnx_cifs_share
Column Name	Data Type	Description
cifs_share_comment	STRING	Returns the user comment
cifs_share_name	STRING	Specifies the name of the share
file_system_obj_id	STRING	Specifies the ID of the file system
last_updated	DATE	Last updated date
max_nbr_of_users	NUMBER	Returns the maximum number of simultaneous users permitted for a share
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
path	STRING	Returns the path to the exported directory
system_name	STRING	System name
vnx_cifs_share_id	NUMBER	Internal Key, Primary Key in aps_vnx_cifs_share
vnx_file_system_id	NUMBER	Internal key, foreign key to the aps_vnx_file_system.vnx_file_system_id
vnx_mover_id	NUMBER	Internal key, foreign key to the aps_vnx_mover.vnx_mover_id
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.140 aps_v_vnx_control_station
Column Name	Data Type	Description
component_type	STRING	Indicates the type of component. In this case, Control Station
dns_domain_name	STRING	Returns the DNS domain name
dns_server_list	STRING	Returns the list of DNS servers configured on this Control Station
gateway	STRING	Returns the IP address of the subnet gateway
host_name	STRING	Returns the host name of control station on network
ip_address	STRING	Returns the external IP address
ipv6_address	STRING	Returns the IPv6 address of the Control Station
ipv6_gateway	STRING	Returns the IPv6 gateway of the Control Station that is used to access the IPv6 network
ipv6_prefix_length	NUMBER	Returns the IPv6 prefix length of the IPv6 address of the Control Station
last_updated	DATE	Last updated date
max_severity	STRING	Returns the maximum (worst) severity among all problems that the task or query experienced during the run
nas_version	STRING	Returns the version of NAS software installed on this Control Station
ntp_server	STRING	Returns the address of the network time server
slot	STRING	Specifies the slot of the Control Station
standby_status	STRING	Indicates the actual status of the standby Control Station
subnet_mask	STRING	Returns the subnet mask for the address
system_name	STRING	System name
system_time	DATE	Returns the system time at the time of the request
time_zone	STRING	Returns the current time zone setting for the control station
vnx_control_station_id	NUMBER	Internal Key, Primary Key in aps_vnx_control_station
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.141 aps_v_vnx_domain_server
Column Name	Data Type	Description
domain_name	STRING	Domain name
last_updated	DATE	Last updated date
server_name	STRING	Server name
system_name	STRING	System name
vnx_mover_domain_id	NUMBER	Internal key, foreign key to the aps_vnx_mover_domain.vnx_mover_domain_id
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.142 aps_v_vnx_file_system
Column Name	Data Type	Description
base_volume_id	NUMBER	Returns the ID of the volume object this file system is based on
checkpoint_data_service_policy	STRING	The data service policies associated with the savvol of the PFS
cifs_access_policy	STRING	Indicates the access checking policy for mounting the CIFS share
cifs_is_notify	CHAR	Indicates, if true, inform the client of changes made to the directory file structure
cifs_is_notify_on_access	CHAR	Provides a notification when the file system is accessed
cifs_is_notify_on_write	CHAR	Provides a notification when the file system is accessed
cifs_is_oplock_disabled	CHAR	Indicates, if true, turn oplocks (opportunistic locks) off
cifs_is_sync_write	CHAR	Indicates, if true, that any write to the Celerra Network Server is synchronous
cifs_locking_policy	STRING	Indicates the impact of locking behavior on NFS clients in the case of concurrent NFS and CIFS file locking
cifs_trigger_level	NUMBER	Defines the number of subdirectories where the notification change is applied
cworm_state	STRING	Returns CWORM state
data_service_policy_list	STRING	The data service policies associated with the file system object
file_system_name	STRING	Returns the name (alias) of the file system. Name is unique among all file system
file_system_obj_id	STRING	Specifies the ID of the file system
file_system_type	STRING	Returns the type of the file system
flr_time	STRING	Current value of non-modifiable software clock for file system
high_watermark	NUMBER	Returns the size threshold that must be reached before the file system is automatically extended
is_auto_extend	CHAR	Specifies whether auto extension is enabled/disabled on the file system
is_contain_slices	CHAR	Indicates that the file system contains slices
is_internal_use	CHAR	Indicates the file system is used internally by Celerra software
is_nt_credential	CHAR	Indicates, if true, that the system matches a UID/GID to a SID during an access request to create one common credential called the NT credential
is_rde_running	CHAR	Returns true when rde state enabled and indicates that the Data Mover is performing space reduction in the files of the file system
is_unmounted	CHAR	Indicates, if true that the file system is temporarily unmounted
is_virtual_provisioning	CHAR	Specified whether virtual provisioning is enabled/disabled
last_updated	DATE	Last updated date
max_auto_extend_size_kb	NUMBER	Returns the maximum file system size to which a file system can be extended
max_nbr_of_files	NUMBER	Returns the maximum number of files and/or directories possible on this file system
max_retention_time	STRING	The maximum retention time for all protected files on the file system
migration_process_state	STRING	Indicates the state of the migration process
mount_point_path	STRING	Specifies the mount point path
nbr_of_files	NUMBER	Returns the current number of files and/or directories on this file system
nfs_is_prefetch	CHAR	Indicates, if true, that the pre-fetch option performs read ahead processing for the file systems
nfs_is_readonly	CHAR	Indicates, if true, that mount is in read-only mode
nfs_is_uncached	CHAR	Indicates, if true, allow well-formed writes
nfs_is_virus_scan	CHAR	Indicates, if false, disable the Virus Checker protocol for a file system
rde_access_time	NUMBER	Returns the minimum required file age (in days) based on read access time
rde_backup_data_high_watermark	NUMBER	Returns the percentage full that a de-duplicate file has to be below, in order to trigger space reduced backups for NDMP
rde_curr_free_space_kb	NUMBER	Returns the current file system free size at the time of the request (dynamic)
rde_curr_total_space_kb	NUMBER	Returns the current file system size at the time of request
rde_curr_used_space_kb	NUMBER	Returns the current RDE used file system size at the time of the request
rde_duplicate_detection_method	STRING	Returns the method used to detect the duplicate data for Celerra
rde_file_extension_excl_list	STRING	Returns a colon delimited list of filename extensions to be excluded from deduplication
rde_is_case_sensitive	CHAR	Returns whether case-sensitive or case-insensitive string comparisons will be used during scans in the NFS namespace
rde_is_cifs_compression	CHAR	Returns whether or not CIFS compression and display are allowed
rde_last_scan_time	DATE	Returns the time of last successful scan of the file system since epoch
rde_max_deduplication_size_kb	NUMBER	Returns the deduplication maximum size
rde_min_deduplication_size_kb	NUMBER	Returns the minimum deduplication size
rde_min_modify_day	NUMBER	Returns the minimum required file age (in days) based on modification time
rde_min_scan_day	NUMBER	Returns the minimum number of days between scans for a filesystem
rde_nbr_of_files	NUMBER	Returns the total number of regular files in the file system as seen from the last successful scan of the file system
rde_nbr_of_recalled_files	NUMBER	Returns the number of files that have been recalled during the inflation process when the status of RDE Running is true and RDE State is off
rde_nbr_of_scanned_files	NUMBER	Returns the current number of files that are seen by the RDE Policy Engine (PE) when the status of RDE Running is true and RDE State is enabled
rde_nbr_of_space_reduced_files	NUMBER	Returns the number of space reduced files in the file system as detected from the last successful scan of the file system
rde_off_space_used	NUMBER	Returns the usage of file system, if RDE were in the off state, as detected from the last successful scan of the file system
rde_path_name_excl_list	STRING	Any directory below a path name that includes this setting will be excluded from deduplication
rde_savvol_high_watermark_pct	NUMBER	Represents the percentage of SavVol space that can be used during the deduplication
rde_space_saved_kb	NUMBER	Returns the amount of space saved by deduplication in MB
rde_state	STRING	Specifies the RDE De-duplication state
recommended_pool	STRING	Returns the ID of the storage pool to use when extending this file system
recommended_storage	STRING	Returns the ID of the storage to use when extending this file system using disk volumes
replication_role	STRING	Indicates the role the file system is playing in the replication process
savvol_raw_size_kb	NUMBER	Returns the raw size of the savVol
savvol_total_space_kb	NUMBER	Returns the logical capacity of savVol; that is, the capacity that can be used to store user data
savvol_used_space_kb	NUMBER	Returns the used space of savVol; that is, the capacity currently used by user data
savvol_volume_id	NUMBER	Returns the ID of the volume that is used to allocate checkpoints for this file system
scaling_factor_mb	NUMBER	Returns the constant factor calculated by the core that is used to compute the default savVol size as factor*(100-High Watermark) in megabytes
storage_obj_id_list	STRING	Returns the list of IDs of storages from which this file system was allocated
system_name	STRING	System name
total_capacity_kb	NUMBER	Returns the total data capacity of the file system
underlying_volume_size_kb	NUMBER	Returns the size of the underlying volume
used_capacity_kb	NUMBER	Returns the amount of space currently used by the user data
valid_pools	STRING	Returns the list of IDs of storage pools that can be used for storage allocation for this file system
valid_storages	STRING	Returns the list of IDs of storages to use when extending this file system using disk volumes
vnx_file_system_id	NUMBER	Internal Key, Primary Key in aps_vnx_file_system
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id

Table 4.143 aps_v_vnx_file_system_log
Column Name	Data Type	Description
file_system_name	STRING	Returns the name (alias) of the file system. Name is unique among all file system.
log_date	DATE	Log date.
max_nbr_of_files	NUMBER	Returns the maximum number of files and/or directories possible on this file system.
nbr_of_files	NUMBER	Returns the current number of files and/or directories on this file system.
savvol_raw_size_kb	NUMBER	Returns the raw size of the savVol.
savvol_total_space_kb	NUMBER	Returns the logical capacity of savVol; that is, the capacity that can be used to store user data.
savvol_used_space_kb	NUMBER	Returns the used space of savVol; that is, the capacity currently used by user data.
system_name	STRING	System name
total_capacity_kb	NUMBER	Returns the total data capacity of the file system.
underlying_volume_size_kb	NUMBER	Returns the size of the underlying volume.
used_capacity_kb	NUMBER	Returns the amount of space currently used by the user data.
vnx_file_system_id	NUMBER	Internal Key, Primary Key in aps_vnx_file_system.
vnx_storage_system_id	NUMBER	Internal key, foreign key to the aps_vnx_storage_system.vnx_storage_system_id.

Table 4.144 aps_v_vnx_logical_network_dev
Column Name	Data Type	Description
device_name	STRING	Specifies the name of the device
device_type	STRING	Returns the type of the device
fsn_active	STRING	Returns the name of the currently active device
fsn_primary	STRING	Returns the name of the primary device
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
speed	STRING	Returns the speed setting of this device
system_name	STRING	System name
trunk_owner	STRING	Returns the name of the container virtual device, if any
virtual_device_id	NUMBER	Returns the list of device names that make up this virtual device
vnx_logical_network_id	NUMBER	Internal key, primary key in aps_vnx_logical_network_device
vnx_mover_id	NUMBER	Internal key, foreign key to aps_vnx_mover.vnx_mover_id
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.145 aps_v_vnx_logical_unit
Column Name	Data Type	Description
array_group_id	NUMBER	Internal key, foreign key to aps_array_group, specifies the ID of the RAID group to which this device belongs
auto_assignment	STRING	Specifies the current state of auto assignment
auto_trespass	STRING	Specifies the state (disabled/enabled) of auto-trespass
device_state	STRING	Specifies the current state of the CLARiiON device
first_stripe_nbr	NUMBER	Specifies the stripe number in RAID where the device starts
idle_delay_time	NUMBER	Specifies the amount of time device must be below the idle-threshold in order to be considered idle
idle_threshold	NUMBER	Specifies maximum number of I/Os that can be outstanding to the device and still have the device be considered idle
is_private	CHAR	Specifies, if true, that the device is not externally visible
last_updated	DATE	Last updated date
logical_unit_id	NUMBER	Internal key, foreign key to aps_v_logical_unit
lun_nbr	NUMBER	LUN number.
max_prefetch_blk	NUMBER	Specifies the maximum size to pre-fetch in response to read request
prefetch_disable_size_blk	NUMBER	Specifies the pre-fetch disable size, in blocks
prefetch_idle_count	NUMBER	Specifies the maximum number of outstanding I/Os the device can have and still perform pre-fetching
read_cache	STRING	Specifies current state of read cache
storage_obj_id	STRING	Specifies ID of the CLARiiON that contains the device
stripe_size_blk	NUMBER	Specifies the stripe size, in blocks
system_name	STRING	System name
variable_length_prefetch	STRING	Specifies the current state of variable length pre-fetch
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id
write_cache	STRING	Specifies the current state of write cache

Table 4.146 aps_v_vnx_map_filesystem_vol
Column Name	Data Type	Description
file_system_obj_id	STRING	Specifies the ID of the file system
last_updated	DATE	Last updated date
system_name	STRING	System name
vnx_file_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_file_system
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_system
vnx_volume_id	NUMBER	Internal key, foreign key to aps_v_vnx_volume
volume_name	STRING	Returns the name of the volume
volume_obj_id	STRING	Specifies the ID of the volume

Table 4.147 aps_v_vnx_map_mover_checkpoint
Column Name	Data Type	Description
checkpoint_name	STRING	Returns the name of the checkpoint
checkpoint_obj_id	STRING	Specifies the ID of the checkpoint
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
system_mode	STRING	File system mode
system_name	STRING	System name
vnx_checkpoint_id	NUMBER	Internal key, foreign key to aps_v_vnx_checkpoint
vnx_mover_id	NUMBER	Internal key, foreign key to aps_v_vnx_mover
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_system

Table 4.148 aps_v_vnx_map_mover_filesystem
Column Name	Data Type	Description
file_system_obj_id	STRING	Specifies the ID of the file system
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
system_mode	STRING	File system mode
system_name	STRING	System name
vnx_file_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_file_system
vnx_mover_id	NUMBER	Internal key, foreign key to aps_v_vnx_mover
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_system

Table 4.149 aps_v_vnx_map_mover_pool
Column Name	Data Type	Description
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
storage_pool_name	STRING	Returns the name of the storage pool
storage_pool_obj_id	STRING	Specifies the ID of the storage pool
system_name	STRING	System name
vnx_mover_id	NUMBER	Internal key, foreign key to aps_v_vnx_mover
vnx_storage_pool_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_pool
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_system

Table 4.150 aps_v_vnx_map_mover_volume
Column Name	Data Type	Description
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
system_name	STRING	System name
vnx_mover_id	NUMBER	Internal key, foreign key to aps_v_vnx_mover
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_system
vnx_volume_id	NUMBER	Internal key, foreign key to aps_v_vnx_volume
volume_name	STRING	Returns the name of the volume
volume_obj_id	STRING	Specifies the ID of the volume

Table 4.151 aps_v_vnx_map_volumes
Column Name	Data Type	Description
last_updated	DATE	Last updated date
map_to_vol_id	NUMBER	Map to volume ID
map_to_vol_name	STRING	Returns the name of the map to volume
map_to_vol_obj_id	STRING	Specifies the ID of the map to volume
system_name	STRING	System name
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_v_vnx_storage_system
vnx_volume_id	NUMBER	Internal key, foreign key to aps_v_vnx_volume
volume_name	STRING	Returns the name of the volume
volume_obj_id	STRING	Specifies the ID of the volume

Table 4.152 aps_v_vnx_mover
Column Name	Data Type	Description
aliases_list	STRING	Returns the list of NETBIOS aliases associated with this server
board_type	STRING	Returns the type of the mother board
bus_speed	NUMBER	Returns the speed of the board main bus
cifs_server_type	STRING	Returns the type of this CIFS server
collection_time	DATE	Time the data was collected
control_stattion_time	DATE	Returns Coordinated Universal Time (UTC) time according to the Control Station clock at the moment the request to DART operating system was made
cpu_speed	NUMBER	Returns the speed of the single CPU
cpu_type	STRING	Returns the type of the CPU
cpu_usage_pct	NUMBER	Percent of CPU Usage
failover_policy	STRING	Returns a failover policy (if the mover has a standby)
i18nmode	STRING	Returns the I18N mode of the mover
is_allow_local_user	CHAR	Indicates that this server allows the creation of a limited number of local user accounts
is_cifs_enabled	CHAR	Returns the state of CIFS service on this Data Mover or VDM
is_joined_domain	CHAR	Indicates whether the server joined the domain or not
is_vdm	CHAR	Indicates that if true, the mover refers to a VDM, otherwise it refers to a mover
last_updated	DATE	Last updated date
max_severity	STRING	Returns the maximum (worst) severity among all problems that the task or query experienced during the run
mem_usage_pct	NUMBER	Percent of memory usage
memory_size_kb	NUMBER	Returns the board main memory size
mover_host_obj_id	STRING	Specifies the ID of the mover host
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Returns the ID the mover hosted by this host
netbios_name	STRING	Specifies the NETBIOS name of the server
ntp_server_list	STRING	Returns the list IP addresses of the NTP server hosts
parent_mover_id	NUMBER	Internal key, foreign key to aps_vnx_mover.vnx_mover_id
role	STRING	Returns the role of this mover
root_file_system	STRING	Returns the ID of the root file system of this VDM
server_interfaces_list	STRING	Returns the list of interface IP addresses on which this server is available
server_workgroup_name	STRING	Returns the server workgroup name
slot	NUMBER	Returns physical slot number of the box
software_version	STRING	Returns the software version of the DART operating system this mover is running
stamp	STRING	Mover resource usage stamp
standby_for_movers_list	STRING	Returns the list of IDs of the movers this mover is a standby for
standby_movers_list	STRING	Returns the list of IDs of standby movers
system_name	STRING	System name
system_time	DATE	Returns Coordinated Universal Time (UTC) time according to the DART operating system at the time of the request
target_state	STRING	Returns the persistent (target) state of the Data Mover
time_zone	STRING	Returns the time zone of the data mover
up_time	NUMBER	Returns mover up-time
user_mapper_servers_list	STRING	Returns a list of host addresses of the external user mapper servers
vdm_state	STRING	Returns the state of the VDM
vnx_mover_id	NUMBER	Internal key, primary key in aps_vnx_mover
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id
win_computer_name	STRING	Returns the computer name
win_domain_name	STRING	Returns the fully qualified domain name
win_servers_list	STRING	Returns a list of IP addresses of WINS (Windows Internet Naming Service) servers

Table 4.153 aps_v_vnx_mover_domain
Column Name	Data Type	Description
domain_name	STRING	Specifies the domain name
domain_type	STRING	Specifies the domain type
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
protocol	STRING	Returns the network protocol used
system_name	STRING	System name
vnx_mover_domain_id	NUMBER	Internal key, primary key in aps_vnx_mover_domain
vnx_mover_id	NUMBER	Internal key, foreign key to aps_vnx_mover.vnx_mover_id
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.154 aps_v_vnx_mover_interface
Column Name	Data Type	Description
broadcast_address	STRING	Returns the broadcast address
interface_name	STRING	Returns the interface name
ip_address	STRING	Specifies the IP address of the interface
ip_version	STRING	Returns whether the IP address is IPv4 or IPv6 on this Control Station
is_up	CHAR	Indicates if true, the interface is up
last_updated	DATE	Last updated date
mac_address	STRING	Returns MAC address
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
net_mask	STRING	Returns the IPv4 subnet mask or IPv6 subnet prefix length
system_name	STRING	System name
vdm_mover_id	NUMBER	VDM mover id
vlan_id	NUMBER	Returns the VLAN ID for this interface
vnx_logical_network_id	NUMBER	Internal key, foreign key to aps_vnx_logical_network_device
vnx_mover_id	NUMBER	Internal key, foreign key to aps_vnx_mover.vnx_mover_id
vnx_mover_interface_id	NUMBER	Internal key, primary key in aps_vnx_mover_interface
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.155 aps_v_vnx_mover_route
Column Name	Data Type	Description
destination	STRING	Specifies the IP address of the destination subnet, subnet prefix in case of IPv6
gateway	STRING	Returns the IP address of the network gateway through which packets to the destination should be routed
interface_name	STRING	Returns the interface name
ip_version	STRING	Returns whether the IP address is IPv4 or IPv6 on this Control Station. Default is IPv4
is_default	CHAR	Specifies the IP address of the destination subnet, subnet prefix in case of IPv6
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
net_mask	STRING	Returns the IPv4 subnet mask or IPv6 subnet prefix length
system_name	STRING	System name
valid_till	STRING	Returns the age till when the route entry is valid
vnx_mover_id	NUMBER	Internal key, foreign key to aps_vnx_mover
vnx_mover_interface_id	NUMBER	Internal key, foreign key to aps_vnx_mover_route
vnx_mover_route_id	NUMBER	Internal key, primary key in aps_vnx_mover_route
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.156 aps_v_vnx_nfs_export
Column Name	Data Type	Description
is_read_only	CHAR	Indicates if true the file system is exported in read-only mode to all clients
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
path	STRING	Specifies the exported mount point path
system_name	STRING	System name
user_id	NUMBER	Returns the unknown user effective user ID
vnx_file_system_id	NUMBER	Returns the ID of the file system which is being exported
vnx_mover_id	NUMBER	Specifies the ID of the mover
vnx_nfs_export_id	NUMBER	Internal key, primary key in aps_vnx_nfs_export
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.157 aps_v_vnx_nfs_export_host
Column Name	Data Type	Description
host_name	STRING	List of Host Names
host_type	STRING	List of Host Types
last_updated	DATE	Last updated date
system_name	STRING	System name
vnx_nfs_export_id	NUMBER	Internal key, foreign key to aps_vnx_nfs_export.vnx_nfs_export_id
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.158 aps_v_vnx_pdev
Column Name	Data Type	Description
bus_nbr	NUMBER	Specifies the bus number on which the disk resides
disk_nbr	NUMBER	Specifies the disk number within the enclosure
disk_state	STRING	Specifies the current state of the disk
last_updated	DATE	Last updated date
nbr_of_remapped_blocks	NUMBER	Specifies the number of blocks that have been remapped due to errors
pdev_id	NUMBER	Internal key, foreign key to aps_pdev
storage_obj_id	STRING	Specifies ID of the CLARiiON that contains the Disk device
system_name	STRING	System name
used_capacity_kb	NUMBER	Specifies the amount of disk space already used
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.159 aps_v_vnx_physical_device
Column Name	Data Type	Description
allowed_speeds	STRING	Returns a list of speeds allowed on this device
description	STRING	Returns the description of the device
device_name	STRING	Specifies the name of the device
device_type	STRING	Returns the type of the device
irq	NUMBER	Returns the interrupt request level for this device
last_updated	DATE	Last updated date
mover_name	STRING	Returns the Name of the mover
mover_obj_id	STRING	Specifies the ID of the mover
nbr_of_scsi_chain	NUMBER	Returns the number of SCSI chains in the range
port_nbr	NUMBER	Returns device port number
port_wwn_id	NUMBER	Returns the World Wide Name of the Fibre Channel port
scsi_chain_start	NUMBER	Returns the beginning of the range of virtual SCSI chains this connection emulates
system_name	STRING	System name
vnx_mover_id	NUMBER	Specifies the ID of the mover host where each device resides
vnx_physical_device_id	NUMBER	Internal key, primary key in aps_vnx_physical_device
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.160 aps_v_vnx_storage_endpoint
Column Name	Data Type	Description
director_nbr	NUMBER	Returns the storage director number
director_type	STRING	Either FC or Other
last_updated	DATE	Last updated date
port_nbr	NUMBER	Returns the director fibre channel port number
port_wwn_id	NUMBER	Returns the world wide name (WWN)
storage_id	STRING	Returns the storage ID
system_name	STRING	System name
vnx_physical_device_id	NUMBER	Internal key, foreign key to aps_vnx_physical_device
vnx_storage_endpoint_id	NUMBER	Internal key, primary key in aps_vnx_storage_endpoint
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.161 aps_v_vnx_storage_pool
Column Name	Data Type	Description
auto_size_kb	NUMBER	For the pools that are not dynamic, returns the total size of all members of the pool
description	STRING	Returns the description of the storage pool
disk_type	STRING	Returns the type of disks that compose this storage pool
is_backend_pool	CHAR	Whether it is a backend pool
is_contain_slices	CHAR	Returns the default value of the mayContainSlices property of the NewFileSystem request within the AllocateFrom sub-element
is_dynamic	CHAR	Indicates, if true, this system defined pool can extend or shrink itself
is_greedy	CHAR	Indicates, if true, this storage pool attempts to create new member volumes before using space from existing member volumes
is_virtual_provisioning	CHAR	Returns whether virtual provisioning is enabled/disabled on this storage pool
last_updated	DATE	Last updated date
nbr_of_stripes	NUMBER	Returns the number of stripe members in the current pool
potential_additional_size_kb	NUMBER	Returns the amount of space that can potentially be added to this storage pool
storage_pool_name	STRING	Returns the name of the storage pool
storage_pool_obj_id	STRING	Specifies the ID of the storage pool
storage_system_list	STRING	Returns the list of IDs of storage systems providing storage for this storage pool
stripe_size_kb	NUMBER	Returns the stripe size in KiB of the current pool
system_name	STRING	System name
template_pool_obj_id	STRING	Returns the system storage pool id used to create user-defined pools by size
total_size_kb	NUMBER	Returns the size of the storage pool as it is used in operations
total_virtual_pool_size_kb	NUMBER	Returns the physical size of this system-defined virtual pool as it is used in operations
used_size_kb	NUMBER	Returns the amount of space already used on this storage pool
used_virtual_pool_size_kb	NUMBER	Returns the physical size of this system-defined virtual pool as it is used in operations
vnx_storage_pool_id	NUMBER	Internal key, primary key in aps_vnx_storage_pool
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id

Table 4.162 aps_v_vnx_storage_pool_log
Column Name	Data Type	Description
log_date	DATE	Log date.
potential_additional_size_kb	NUMBER	Returns the amount of space that can potentially be added to this storage pool.
storage_pool_name	STRING	Returns the name of the storage pool.
system_name	STRING	System name
total_size_kb	NUMBER	Returns the size of the storage pool as it is used in operations.
total_virtual_pool_size_kb	NUMBER	Returns the physical size of this system-defined virtual pool as it is used in operations.
used_size_kb	NUMBER	Returns the amount of space already used on this storage pool.
used_virtual_pool_size_kb	NUMBER	Returns the physical size of this system-defined virtual pool as it is used in operations.
vnx_storage_pool_id	STRING	Internal key, primary key in aps_vnx_storage_pool.
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id.

Table 4.163 aps_v_vnx_storage_system
Column Name	Data Type	Description
avm_allocated_kb	NUMBER	Automatic volume management, allocated volume in KiB
avm_available_kb	NUMBER	Automatic volume management, available volume in KiB
avm_capacity_kb	NUMBER	Automatic volume management capacity in KiB
component_type	STRING	Returns the type of component. In this case, system
free_hard_kb	NUMBER	Free Hard size in KiB
free_soft_kb	NUMBER	Free Soft size in KiB
last_updated	DATE	Last updated date
machine_model	STRING	Machine model
machine_type	STRING	Machine type
max_severity	STRING	Returns the maximum (worst) severity among all problems that the task or query experienced during the run
mvm_allocated_kb	NUMBER	Manual volume management, allocated volume in KiB
mvm_available_kb	NUMBER	Manual volume management, available volume in KiB
mvm_capacity_kb	NUMBER	Manual volume management capacity in KiB
nbr_allocated_luns	NUMBER	Number of allocated LUNs
nbr_of_disk_volumes	NUMBER	Number of disk volumes
nbr_of_luns	NUMBER	Number of LUNs
nbr_of_meta_volumes	NUMBER	Number of Meta volumes
nbr_of_movers	NUMBER	Number of mover
nbr_of_pool_volumes	NUMBER	Number of pool volumes
nbr_of_slice_volumes	NUMBER	Number of slice volumes
nbr_of_stripe_volumes	NUMBER	Number of stripe volumes
nbr_of_vdm	NUMBER	Number of vdm mover
savvol_allocated_kb	NUMBER	Savvol allocated volume in KiB
savvol_available_kb	NUMBER	Savvol available volume in KiB
savvol_capacity_kb	NUMBER	Savvol capacity in KiB
serial_nbr	STRING	Serial number
system_name	STRING	System name
system_obj_id	STRING	Specifies the ID of the Celerra system object
system_version	STRING	System version
total_disk_volume_kb	NUMBER	Total of disk volume in KiB
total_free_kb	NUMBER	Total Soft size in KiB
total_hard_kb	NUMBER	Total Hard size in KiB
total_pool_potential_kb	NUMBER	Total of pool potential in KiB
vnx_storage_system_id	NUMBER	Internal key, primary key in aps_vnx_storage_system

Table 4.164 aps_v_vnx_tree
Column Name	Data Type	Description
file_system_obj_id	STRING	Specifies the ID of the file system
grace_period_time_remain_files	NUMBER	Returns the time remaining after the grace period for files has been started
grace_period_time_remain_space	NUMBER	Returns the time that remains after the grace period takes effect
group_files_hard_limit	NUMBER	Specifies the group absolute limit
group_files_soft_limit	NUMBER	Specifies the group soft limit
group_space_hard_limit_kb	NUMBER	Specifies the group space absolute limit in KiB
group_space_soft_limit_kb	NUMBER	Specifies the group space soft limit in KiB
last_updated	DATE	Last updated date
nbr_of_files_used	NUMBER	Number of files used
space_used_kb	NUMBER	Returns the amount of space currently used by this user in KiB
system_name	STRING	System name
tree_comment	STRING	Comment associated with this tree quota
tree_files_hard_limit	NUMBER	Specifies the absolute limit, after which no more files (inodes) can be created
tree_files_soft_limit	NUMBER	Specifies the soft limit for the number of files that can be created
tree_obj_id	STRING	Specifies the tree ID
tree_path	STRING	Specifies the path to the directory within the file system
tree_quota_time_remain_files	NUMBER	Returns the time remaining after the tree quota for files has been started
tree_quota_time_remain_space	NUMBER	Returns the time that remains after the quota exceeded soft limit and before the hard limit behavior takes effect
tree_space_hard_limit_kb	NUMBER	Specifies the absolute limit, after which no more data can be written
tree_space_soft_limit_kb	NUMBER	Specifies the soft limit on used space. If the amount of user data on this file system exceeds this limit
user_files_hard_limit	NUMBER	Specifies user absolute limit
user_files_soft_limit	NUMBER	Specifies user soft limit
user_space_hard_limit_kb	NUMBER	Specifies user space absolute limit in KiB
user_space_soft_limit_kb	NUMBER	Specifies user space soft limit in KiB
vnx_file_system_id	NUMBER	Internal key, foreign key to aps_vnx_file_system.vnx_file_system_id
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id
vnx_tree_id	NUMBER	Internal key, primary key in aps_vnx_tree

Table 4.165 aps_v_vnx_user_quota
Column Name	Data Type	Description
files_hard_limit	NUMBER	Specifies the absolute limit, after which no more files (inodes) can be created
files_soft_limit	NUMBER	Specifies the soft limit for the number of files that can be created
is_group	CHAR	Indicates that if true (default), this is a group and not a user ID
last_updated	DATE	Last updated date
nbr_of_files_used	NUMBER	Returns the number of files (inodes) currently used
space_hard_limit_kb	NUMBER	Specifies the absolute limit, after which no more data can be written
space_soft_limit_kb	NUMBER	Specifies the soft limit on used space
space_used_kb	NUMBER	Returns the amount of space currently used by this user
system_name	STRING	System name
time_remain_files	NUMBER	Returns the time remaining after the grace period for files has been started
time_remain_space	NUMBER	Returns the time that remains after the quota exceeded soft limit and before the hard limit behavior takes effect
tree_obj_id	STRING	Specifies the tree ID
tree_path	STRING	Specifies the path to the directory within the file system
user_quota_uid	STRING	Specifies the user or group ID
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id
vnx_tree_id	NUMBER	Internal key, foreign key to aps_vnx_tree.vnx_tree_id
vnx_user_quota_id	NUMBER	Internal key, primary key in aps_vnx_user_quota
win_security_id_list	STRING	Returns a list of Windows security IDs (users or groups) that correspond to this UID

Table 4.166 aps_v_vnx_volume
Column Name	Data Type	Description
data_service_policy_list	STRING	The data service policies associated with the volume object
disk_type	STRING	Returns the type of the underlying storage device
is_virtual_provisioning	CHAR	Returns whether virtual provisioning is enabled/disabled on this volume
last_updated	DATE	Last updated date
lun_nbr	NUMBER	Returns the logical unit number
parent_volume_id	NUMBER	Column not used
size_kb	NUMBER	Returns the size of the volume as it is used in operations
slice_vol_offset	NUMBER	Returns the address of the slice within the volume of which this volume is slice
storage_obj_id	STRING	Returns the ID of the storage array to which this disk belongs
stripe_size_kb	NUMBER	Returns the size of a single stripe
system_name	STRING	System name
vnx_logical_unit_id	NUMBER	Internal key, foreign key to aps_vnx_logical_unit.vnx_logical_unit_id
vnx_storage_pool_id	NUMBER	Returns the ID of a storage pool, in case the volume is a direct member of the pool
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id
vnx_volume_id	NUMBER	Internal key, primary key in aps_vnx_volume
volume_name	STRING	Returns the name of the volume. The name is unique, but mutable
volume_obj_id	STRING	Specifies the ID of the volume
volume_type	STRING	Returns the type of the volume

Table 4.167 aps_v_vnx_volume_log
Column Name	Data Type	Description
log_date	DATE	Log date.
size_kb	NUMBER	Returns the size of the volume as it is used in operations.
system_name	STRING	System name
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id.
vnx_volume_id	NUMBER	Internal key, primary key in aps_vnx_volume.
volume_name	STRING	Returns the name of the volume. The name is unique, but mutable.

Table 4.168 aps_v_vnx_volume_free_space
Column Name	Data Type	Description
last_updated	DATE	Last updated date
offset	NUMBER	Returns the offset of the free space chunk from the beginning of the volume
size_kb	NUMBER	Returns the size of the free space chunk
system_name	STRING	System name
vnx_storage_system_id	NUMBER	Internal key, foreign key to aps_vnx_storage_system.vnx_storage_system_id
vnx_volume_id	NUMBER	Internal key, foreign key to aps_vnx_volume.vnx_volume_id