Storage Viewer for Capacity Database Views > aps_v_vnx_user_quota
  
Version 10.0.01
aps_v_vnx_user_quota
The aps_v_vnx_user_quota contains a single row for each user quota.
Table 4.169 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