Capacity Manager Database Views > EMC VNX Array Database Views
  
Version 10.0.00
EMC VNX Array Database Views
aps_v_vnx_array_group
The aps_v_vnx_group view contains a single row for each array group.
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
aps_v_vnx_array_port
The aps_v_vnx_array_port contains a single row for each array port.
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
aps_v_vnx_backend_storage_sys
The aps_v_vnx_backend_storage_sys contains a single row for each Celerra backend system.
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
 
aps_v_vnx_checkpoint
The aps_v_vnx_checkpoint contains a single row for each Celerra checkpoint.
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
aps_v_vnx_cifs_share
The aps_v_vnx_cifs_share contains a single row for each CIFS share.
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
 
aps_v_vnx_control_station
The aps_v_vnx_control_station contains a single row for each control station.
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
aps_v_vnx_domain_server
The aps_v_vnx_domain_server contains a single row for each mover domain server.
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
aps_v_vnx_file_system
The aps_v_vnx_file_system contains a single row for each file system.
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
aps_v_vnx_file_system_log
The aps_v_vnx_file_system_log contains a single row for each file system log.
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.
aps_v_vnx_logical_network_dev
The aps_v_vnx_logical_network_dev contains a single row for each logical network device.
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
aps_v_vnx_logical_unit
The aps_v_vnx_logical_unit contains a single row for each logical unit.
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
aps_v_vnx_map_filesystem_vol
The aps_v_vnx_map_filesystem_vol contains a single row mapping for each file system and volume.
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
aps_v_vnx_map_mover_checkpoint
The aps_v_vnx_map_mover_checkpoint contains a single row mapping for each mover and checkpoint.
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
aps_v_vnx_map_mover_filesystem
The aps_v_vnx_map_mover_filesystem contains a single row mapping for each mover and file 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
aps_v_vnx_map_mover_pool
The aps_v_vnx_map_mover_pool contains a single row mapping for each mover and storage pool.
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
aps_v_vnx_map_mover_volume
The aps_v_vnx_map_mover_volume contains a single row mapping for each mover and volume.
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
aps_v_vnx_map_volumes
The aps_v_vnx_map_volumes contains a single row mapping for each volume and member 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
aps_v_vnx_mover
The aps_v_vnx_mover contains a single row for each mover.
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
aps_v_vnx_mover_domain
The aps_v_vnx_mover_domain contains a single row for each mover domain.
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
aps_v_vnx_mover_interface
The aps_v_vnx_mover_interface contains a single row for each mover interface.
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
aps_v_vnx_mover_route
The aps_v_vnx_mover_route contains a single row for each mover route.
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
aps_v_vnx_nfs_export
The aps_v_vnx_nfs_export contains a single row for each NFS export.
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
aps_v_vnx_nfs_export_host
The aps_v_vnx_nfs_export_host contains a single row for each NFS export host.
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
aps_v_vnx_pdev
The aps_v_vnx_pdev contains a single row for each pdev.
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
aps_v_vnx_physical_device
The aps_v_vnx_physical_device contains a single row for each physical device.
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
aps_v_vnx_storage_endpoint
The aps_v_vnx_storage_endpoint contains a single row for each endpoint.
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
aps_v_vnx_storage_pool
The aps_v_vnx_storage_pool contains a single row for each storage pool.
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
aps_v_vnx_storage_pool_log
The aps_v_vnx_storage_pool_log contains a single row for each storage pool log.
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.
aps_v_vnx_storage_system
The aps_v_vnx_storage_system contains a single row for each Celerra storage system.
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
aps_v_vnx_tree
The aps_v_vnx_tree contains a single row for each tree.
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
aps_v_vnx_user_quota
The aps_v_vnx_user_quota contains a single row for each user quota.
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
aps_v_vnx_volume
The aps_v_vnx_volume contains a single row for each volume.
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
aps_v_vnx_volume_log
The aps_v_vnx_volume_log view contains a single row for each volume log.
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.
aps_v_vnx_volume_free_space
The aps_v_vnx_volume_free_space contains a single row for each volume free space.
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