EMC Isilon Array Database Views Version 10.0.00

Table 4.78 aps_v_isi_array_performance
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the cluster at collection time.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the cluster at collection time.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the cluster at collection time.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster at collection time
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the cluster at collection time.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the cluster at collection time.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the cluster at collection time.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the cluster at collection time.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the cluster at collection time.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all external interfaces in the cluster at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all external interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all internal interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all internal interfaces in the cluster at collection time.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	The date and time the samples were collected.
MAX_SINGLE_CPU_PCT	NUMBER	Single highest CPU usage (percent) in the cluster at collection time.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Total number of clients connected to the cluster at collection time.

Table 4.79 aps_v_isi_array_prf_log_day
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the cluster for the day.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the cluster for the day.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the cluster for the day.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the cluster for the day.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster for the day.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the cluster for the day.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) for the day.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the cluster for the day.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the cluster for the day.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the cluster for the day.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the cluster for the day.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the cluster for the day.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all external interfaces in the cluster for the day.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all external interfaces in the cluster for the day.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all internal interfaces in the cluster for the day.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all internal interfaces in the cluster for the day.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Midnight time stamp of the day the record was aggregated for the log entry.
MAX_SINGLE_CPU_PCT	NUMBER	Maximum CPU usage (percent) in the cluster for the day.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Average number of connected clients to the cluster for the day.

Table 4.80 aps_v_isi_array_prf_log_hr
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the cluster for the hour.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the cluster for the hour.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the cluster for the hour.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the cluster for the hour.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster for the hour.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the cluster for the hour.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster for the hour.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the cluster for the hour.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the cluster for the hour.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the cluster for the hour.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the cluster for the hour.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the cluster for the hour.
CUM_INTERVAL_SEC	NUMBER	Time interval
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all external interfaces in the cluster for the hour.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all external interfaces in the cluster for the hour.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all internal interfaces in the cluster for the hour.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all internal interfaces in the cluster for the hour.
INTERVAL_TYPE	STRING	Interval type for the array performance log collection.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated for the hourly array performance log.
MAX_SINGLE_CPU_PCT	NUMBER	Maximum CPU usage (percent) in the cluster for the hour.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Total number of clients connected to the cluster at collection time.

Table 4.81 aps_v_isi_array_prf_log_min
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the cluster at collection time.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the cluster at collection time.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the cluster at collection time.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster at collection time.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the cluster at collection time.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the cluster at collection time.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the cluster at collection time.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the cluster at collection time.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the cluster at collection time.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the cluster at collection time.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all external interfaces in the cluster at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all external interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all internal interfaces in the cluster at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all internal interfaces in the cluster at collection time.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date and time the samples were collected.
MAX_SINGLE_CPU_PCT	NUMBER	Single highest CPU usage (percent) in the cluster at collection time.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Total number of clients actively transferring to/from the cluster at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Total number of clients connected to the cluster at collection time.

Table 4.82 aps_v_isi_chassis
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CHASSIS_MODEL	STRING	The model of the chassis.
CHASSIS_NBR	NUMBER	Chassis number.
CONFIG_NBR	STRING	The chassis configuration number.
CREATION_DATE	DATE	The date and time the Isilon chassis data was created in the StorageConsole database.
IS_LIGHT_ON	STRING	Indicates if the unit ID light on the chassis is lit (may be NULL): Y or N.
ISI_CHASSIS_ID	NUMBER	Isilon chassis ID for internal use by the StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon chassis data was last updated in the StorageConsole database.
NODE_NAME	STRING	Node name
SERIAL_NBR	STRING	The chassis serial number.

Table 4.83 aps_v_isi_cifs_share
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CHANGE_NOTIFY	STRING	Specifies the level of change notification alerts on a share.
CIFS_SHARE_NAME	STRING	Name of the share.
CIFS_SHARE_PATH	STRING	File system path of the share.
CREATE_PERMISSIONS	STRING	The create permissions for new files and directories in a share.
CREATION_DATE	DATE	The date and time the Isilon CIFS data was created in the APTARE StorageConsole database.
CSC_POLICY	STRING	Client-side caching policy.
DESCRIPTION	STRING	Description of the share.
FS_ROOT_PATH	STRING	File System root path
IMPERSONATE_GUEST	STRING	When access should be as guest.
IMPERSONATE_USERNAME	STRING	The user account to be used as a guest account.
IS_BROWSABLE	STRING	Indicates if the share is visible in browse lists: Y or N.
IS_DELETE_READONLY_ALLOW	STRING	Indicates if deletion of read-only files in the share is allowed: Y or N.
IS_DOT_FILES_HIDDEN	STRING	Indicates if filenames beginning with a dot are hidden: Y or N.
IS_EXECUTE_ALWAYS_ALLOW	STRING	Indicates if users can execute files for which they have read rights: Y or N.
IS_INHERITABLE_ACL	STRING	Indicates if access control lists (ACLs) are inheritable: Y or N.
IS_NTFS_ACL_SUPPORTED	STRING	Indicates if New Technology File System (NTFS) access control lists (ACLs) on files and directories are supported: Y or N.
IS_OPLOCK_REQUESTS_ALLOW	STRING	Indicates if opportunistic locks (oplocks) requests are supported: Y or N.
IS_STRICT_FLUSH	STRING	Indicates if server message block (SMB) flush operations are strict: Y or N.
IS_STRICT_LOCKING	STRING	Indicates if byte-range locks contend with the server message block (SMB) I/O: Y or N.
is_usage_exact	STRING	Indicates whether the usage is an exact value or an “at least” value: Y or Null.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the APTARE StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon CIFS data was last updated in the APTARE StorageConsole database.
MANGLE_BYTE_START	STRING	Specifies the wchar_t starting point for automatic byte mangling.
MANGLE_MAP	STRING	The character mangle map.
nbr_of_FIles_dirs	NUMBER	Combined count of files and directories of all paths in the NFS export.
usage_with_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).

Table 4.84 aps_v_isi_cifs_share_log
Column Name	Data Type	Description
CIFS_SHARE_NAME	STRING	Name of the share.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the APTARE StorageConsole database.
log_date	DATE	The date and time the Isilon CIFS Log data was created in the database.
usage_with_overhead_gb	NUMBER	Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb	NUMBER	Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).

Table 4.85 aps_v_isi_disk
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CHASSIS_NBR	NUMBER	Chassis number.
CREATION_DATE	DATE	The date and time the Isilon disk data was created in the APTARE StorageConsole database.
DISK_LOGICAL_NBR	NUMBER	The disk logical number within the node.
DISK_NBR	NUMBER	The disk number within the node.
DRIVE_BAY_NBR	NUMBER	Drive Bay number.
FS_FREE_CAPACITY_GB	NUMBER	Free filesystem capacity on the drive (KiB)
FS_FREE_CAPACITY_KB	NUMBER	Free file system capacity on the drive.
FS_TOTAL_CAPACITY_GB	NUMBER	Total filesystem capacity on the drive, including metadata (GiB)
FS_TOTAL_CAPACITY_KB	NUMBER	Total file system capacity on the drive, including metadata.
FS_USED_CAPACITY_GB	NUMBER	Used filesystem capacity on the drive (GiB)
FS_USED_CAPACITY_KB	NUMBER	Used file system capacity on the drive.
ISI_CHASSIS_ID	NUMBER	Chassis ID, for internal use by the APTARE StorageConsole database.
ISI_DRIVE_BAY_ID	NUMBER	Drive Bay ID, for internal use by the APTARE StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the APTARE StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon disk data was last updated in the APTARE StorageConsole database.
NODE_NAME	STRING	Node name
PDEV_ID	NUMBER	Isilon disk physical device ID, for internal use by the APTARE StorageConsole database.

Table 4.86 aps_v_isi_disk_performance
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
DISK_BUSY_PCT	NUMBER	Disk busy (percent) at collection time.
DISK_LATENCY_MS	NUMBER	Disk latency (milliseconds) at collection time.
DISK_RATE_IN_BPS	NUMBER	Disk rate: Disk write performance (bytes/second) at collection time.
DISK_RATE_OUT_BPS	NUMBER	Disk rate: Disk read performance (bytes/second) at collection time.
DRIVE_BAY_NBR	NUMBER	Drive Bay number.
ISI_DRIVE_BAY_ID	NUMBER	Drive Bay ID, for internal use by the APTARE StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the APTARE StorageConsole database.
LOG_DATE	DATE	Date and time the samples were collected.
NODE_NAME	STRING	Node name
OPERATION_RATE_IN_OPS	NUMBER	Disk rate: Disk write performance (IOPS) at collection time.
OPERATION_RATE_OUT_OPS	NUMBER	Disk rate: Disk read performance (IOPS) at collection time.

Table 4.87 aps_v_isi_disk_pool
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon disk pool data was created in the APTARE StorageConsole database.
DISK_POOL_NAME	STRING	Disk pool name.
DISK_POOL_TYPE	STRING	The type of disk pool.
HEALTH_STATUS	STRING	Overall health of the disk pool.
IS_HEALTH_OK	STRING	Indicates if the node is OK: Y or N.
IS_MISSING_DRIVES	STRING	Indicates if there are drives missing from the Isilon disk pool: Y or N.
IS_NEED_REPAIR	STRING	Indicates if some Isilon nodes and/or drives need repair: Y or N.
IS_OFFLINE	STRING	Indicates if some Isilon nodes and/or drives are down: Y or N.
IS_SMART_FAILED	STRING	Indicates if some Isilon nodes and/or drives are smart-failed: Y or N.
IS_TOO_FEW_NODES	STRING	Indicates if there are too few nodes: Y or N.
ISI_DISK_POOL_ID	NUMBER	Disk pool ID, for internal use by the APTARE StorageConsole database.
ISI_NODE_POOL_ID	NUMBER	Node pool ID, for internal use by the APTARE StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the APTARE StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon disk pool data was last updated in the APTARE StorageConsole database.
NODE_POOL_NAME	STRING	Node pool Name.
PROTECTION_POLICY	STRING	The protection policy of the disk pool.

Table 4.88 aps_v_isi_disk_prf_log_day
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
DISK_BUSY_PCT	NUMBER	Average disk busy percent for the day.
DISK_LATENCY_MS	NUMBER	Average disk latency(milliseconds) for the day.
DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance(bytes/second) for the day.
DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance(bytes/second) for the day.
DRIVE_BAY_NBR	NUMBER	Drive Bay number.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_DRIVE_BAY_ID	NUMBER	Drive Bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Midnight time stamp of the day the record was aggregated for.
NODE_NAME	STRING	Node name
OPERATION_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performace(IOPS) for the day.
OPERATION_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance(IOPS) for the day.

Table 4.89 aps_v_isi_disk_prf_log_hr
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the hour for which the data was collected.
DISK_BUSY_PCT	NUMBER	Average disk busy percent for the hour.
DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) for the hour.
DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) for the hour.
DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance(bytes/second) for the hour.
DRIVE_BAY_NBR	NUMBER	Drive Bay number.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_DRIVE_BAY_ID	NUMBER	Drive Bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
NODE_NAME	STRING	Node name
OPERATION_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) for the hour.
OPERATION_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) for the hour.

Table 4.90 aps_v_isi_disk_prf_log_min
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for which the data was collected.
DISK_BUSY_PCT	NUMBER	Disk busy (percent) at collection time.
DISK_LATENCY_MS	NUMBER	Disk latency (milliseconds) at collection time.
DISK_RATE_IN_BPS	NUMBER	Disk rate: Disk write performance (bytes/second) at collection time.
DISK_RATE_OUT_BPS	NUMBER	Disk rate: Disk read performance (bytes/second) at collection time.
DRIVE_BAY_NBR	NUMBER	Drive Bay number.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_DRIVE_BAY_ID	NUMBER	Drive Bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date/time that the samples were collected.
NODE_NAME	STRING	Node name
OPERATION_RATE_IN_OPS	NUMBER	Disk rate: Disk write performance (IOPS) at collection time.
OPERATION_RATE_OUT_OPS	NUMBER	Disk rate: Disk read performance (IOPS) at collection time.

Table 4.91 aps_v_isi_drive_bay
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon drive bay data was created in the StorageConsole database.
DISK_POOL_NAME	STRING	Disk pool name.
DRIVE_BAY_NAME	STRING	The name of the drive bay.
DRIVE_BAY_NBR	NUMBER	Drive Bay number.
DRIVE_BAY_STATUS	STRING	The status of the drive bay or the drive in the bay (if any).
ISI_DISK_POOL_ID	NUMBER	Disk Pool ID, for internal use by the StorageConsole database.
ISI_DRIVE_BAY_ID	NUMBER	Unique drive bay ID, for internal use by the StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon drive bay data was last updated in the StorageConsole database.
NODE_NAME	STRING	Node name

Table 4.92 aps_v_isi_ftp
Column Name	Data Type	Description
ACCEPT_TIMEOUT_SEC	NUMBER	Accept timeout (seconds) for FTP.
ANONYMOUS_CHOWN_USERNAME	STRING	The owner of anonymously-uploaded files.
ANONYMOUS_PASSWORD_LIST	STRING	List of allowed anonymous passwords for FTP.
ANONYMOUS_ROOT_PATH	STRING	File system path for anonymous users for FTP.
ANONYMOUS_UMASK	STRING	Anonymous user file creation mask for FTP.
ARRAY_NAME	STRING	Array name
ASCII_MODE	STRING	Indicates if ASCII uploads and/or downloads are enabled for FTP: Y or N.
CHROOT_EXCEPTION_LIST	STRING	Exceptions to the chroot local mode setting.
CHROOT_LOCAL_MODE	STRING	Specifies which users are placed in a chroot jail after login.
CONNECT_TIMEOUT_SEC	NUMBER	Connect timeout (seconds) for FTP.
CREATION_DATE	DATE	The date and time the Isilon FTP data was created in the StorageConsole database.
DATA_TIMEOUT_SEC	NUMBER	Data timeout (seconds) for FTP.
DENIED_USER_LIST	STRING	The FTP denied user list.
DIR_LIST_NAMES	STRING	Specifies what user details are shown in directory lists for FTP.
FILE_CREATE_PERMISSIONS	STRING	File creation permissions for FTP.
FS_ROOT_PATH	STRING	File System root path
IS_ALWAYS_CHDIR_HOMEDIR	STRING	Indicates if changing to the home directory should always occur with FTP: Y or N.
IS_ANONYMOUS_ACCESS_ALLOW	STRING	Indicates if anonymous access is allowed for FTP: Y or N.
IS_ANONYMOUS_UPLOAD_ALLOW	STRING	Indicates if anonymous users can upload with FTP: Y or N.
IS_DIRECTORY_LISTS_ALLOW	STRING	Indicates if directory listing is allowed for FTP: Y or N.
IS_DIRLIST_USE_LOCALTIME	STRING	Indicates if the FTP directory list uses local time: Y or N.
IS_DOWNLOAD_ALLOW	STRING	Indicates if downloads are allowed for FTP: Y or N.
IS_LIMIT_ANONYMOUS_PASSWORDS	STRING	Indicates if anonymous passwords are limited for FTP: Y or N.
IS_LOCAL_ACCESS_ALLOW	STRING	Indicates if local access is allowed for FTP: Y or N.
IS_SERVER_TO_SERVER_ALLOW	STRING	Indicates if server-to-server file exchange protocol (FXP) transfers are allowed: Y or N.
IS_WRITE_ALLOW	STRING	Indicates if writes are allowed with FTP: Y or N.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon FTP data was last updated in the StorageConsole database.
LOCAL_UMASK	STRING	Local user file creation umask for FTP.
LOCAL_USER_ROOT_PATH	STRING	File system path for local users for FTP.
SESSION_TIMEOUT_SEC	NUMBER	Session timeout (seconds) for FTP.
USER_CONFIG_DIR	STRING	The user configuration directory.

Table 4.93 aps_v_isi_hdfs
Column Name	Data Type	Description
ADDRESS_POOLS	STRING	IP pools assigned to the rack.
ARRAY_NAME	STRING	Array name
AUTHENTICATION	STRING	Authentication method.
BLOCK_SIZE_KB	NUMBER	Hadoop block size (KiB).
CLIENT_ADDRESSES	STRING	IP addresses and address ranges of clients.
CREATION_DATE	DATE	The date and time the Isilon Hadoop Distributed File System (HDFS) data was created in the StorageConsole database.
FS_ROOT_PATH	STRING	File System root path
HDFS_RACK_NAME	STRING	Name of Hadoop Distributed File System (HDFS) rack.
HDSF_ROOT_PATH	STRING	Hadoop (HDFS) root path in the file system.
is_usage_exact	STRING	Indicates whether the usage is an exact value or an “at least” value: Y or Null.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon Hadoop Distributed File System (HDFS) was last updated in the StorageConsole database.
LOG_LEVEL	STRING	Logging level for Hadoop Distributed File System (HDFS).
nbr_of_FIles_dirs	NUMBER	Combined count of files and directories of all paths in the NFS export.
NBR_OF_THREADS	NUMBER	Number of threads for Hadoop Distributed File System (HDFS) processing.
usage_with_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
VERSION_SUPPORTED	STRING	Hadoop version supported.

Table 4.94 aps_v_isi_hdfs_log
Column Name	Data Type	Description
HDFS_RACK_NAME	STRING	Name of Hadoop Distributed File System (HDFS) rack.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
log_date	DATE	The date and time the Isilon HDFS log data was created in the database.
usage_with_overhead_gb	NUMBER	Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb	NUMBER	Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).

Table 4.95 aps_v_isi_license
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon license data was created in the StorageConsole database.
EXPIRATION_DATE	DATE	Date and time of the Isilon license expiration.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon license data was last updated in the StorageConsole database.
LICENSE_STATUS	STRING	Activation status of the module.
MODULE_NAME	STRING	Name of Isilon module/feature.

Table 4.96 aps_v_isi_nfs_client
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CLIENT_ACCESS	STRING	Access type for the clients to the NFS export.
CREATION_DATE	DATE	The date and time the Isilon NFS client data was created in the StorageConsole database.
ISI_NFS_EXPORT_ID	NUMBER	NFS Export ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon NFS client data was last updated in the StorageConsole database.
NFS_CLIENT_ADDRESS	STRING	Clients that can access this export.
NFS_EXPORT_ID	NUMBER	The NFS Export ID.

Table 4.97 aps_v_isi_nfs_export
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name.
BLOCK_SIZE_KB	NUMBER	Size of block used for the NFS export.
CREATION_DATE	DATE	The date and time the Isilon NFS export data was created in the StorageConsole database.
DESCRIPTION	STRING	Description of the NFS export.
DIRECTORY_TRANSFER_SIZE_GB	NUMBER	Directory transfer size (GiB)
DIRECTORY_TRANSFER_SIZE_KB	NUMBER	Directory transfer size (KiB).
ENCODING	STRING	Encoding method (character set).
FS_ROOT_PATH	STRING	File System root path.
IS_ALL_DIRECTORY	STRING	Indicates if mounting subdirectories directly is allowed: Y or N.
IS_COMMIT_ASYNC	STRING	Indicates if writes are committed asynchronously: Y or N.
IS_MAP_FULL	STRING	Indicates if full identity mapping resolution will be used for mapped users: Y or N.
IS_MAP_LOOKUP_UID	STRING	Indicates if incoming UNIX UIDs will be looked up locally: Y or N.
IS_MAP_RETRY	STRING	Indicates if failed user-mapping lookups will be retried: Y or N.
IS_READ_DIR_PLUS	STRING	Indicates if processing of readdir-plus requests are enabled: Y or N.
IS_READONLY	STRING	Indicates if the NFS export is read-only: Y or N.
IS_RETURN_32_BIT_FIELDS	STRING	Indicates if the size of file identifiers returned from readdir is limited to 32-bits: Y or N.
IS_SET_ATTR_ASYNC	STRING	Indicates if set-attributes operations are performed asynchronously for NFS exports: Y or N.
IS_SET_TIME_ALLOW	STRING	Indicates if the time can be set independent of the cluster system time: Y or N.
IS_SYMLINK_ALLOW	STRING	Indicates if support is advertised for symlinks: Y or N.
is_usage_exact	STRING	Indicates whether the usage is an exact value or an “at least” value: Y or Null.
ISI_NFS_EXPORT_ID	NUMBER	NFS Export ID, for internal use by the StorageConsole database.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon NFS export data was last updated in the StorageConsole database.
MAP_ALL_GROUPS	STRING	The groups by which operations by any user will execute.
MAP_ALL_USER	STRING	The identity by which operations by any user will execute.
MAP_ROOT_GROUPS	STRING	The groups by which operations by root will execute.
MAP_ROOT_USER	STRING	The identity by which operations by root will execute.
MAX_FILE_SIZE_GB	NUMBER	Maximum allowed file size on the server (GiB)
MAX_FILE_SIZE_KB	NUMBER	Maximum allowed file size on the server (KiB).
NBR_OF_ACCESS_CLIENT_ADDR	NUMBER	Number of client addresses that have access to this NFS export.
nbr_of_FIles_dirs	NUMBER	Combined count of files and directories of all paths in the NFS export.
NBR_OF_NFS_EXPORT_PATH	NUMBER	Number of NFS export paths in the cluster NFS export.
NBR_OF_READ_WRITE_CLIENT_ADDR	NUMBER	Number of client addresses that have read-write access to this NFS export.
NBR_OF_READONLY_CLIENT_ADDR	NUMBER	Number of client addresses that have read-only access to this NFS export.
NBR_OF_ROOT_CLIENT_ADDR	NUMBER	Number of client addresses that have root access to this NFS export.
NBR_OF_UNRESOLVED_CLIENT_ADDR	NUMBER	Number of client addresses that have access that is unresolved to this NFS export.
NFS_EXPORT_ID	NUMBER	The NFS Export ID.
READ_DIR_PLUS_PREFETCH	NUMBER	The number of file nodes to pre-fetch when a readdir-plus request is processed.
READ_TRANSFER_MAX_SIZE_GB	NUMBER	Maximum read transfer size to report to clients (GiB)
READ_TRANSFER_MAX_SIZE_KB	NUMBER	Maximum read transfer size to report to clients (KiB).
READ_TRANSFER_MULTIPLE	NUMBER	Suggested multiple read size to report to clients.
READ_TRANSFER_SIZE_GB	NUMBER	Preferred read transfer size to report to clients (GiB)
READ_TRANSFER_SIZE_KB	NUMBER	Preferred read transfer size to report to clients (KiB).
SECURITY_TYPE	STRING	Security flavor to support for NFS exports.
TIME_DELTA	NUMBER	Specifies host time granularity (in seconds).
TOTAL_NBR_OF_CLIENT_ADDR	NUMBER	Total number of client addresses in the NFS export.
usage_with_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).
WRITE_DATASYNC_ACTION	STRING	Specifies the datasync write method.
WRITE_DATASYNC_REPLY	STRING	Specifies the datasync reply method.
WRITE_FILESYNC_ACTION	STRING	Specifies the filesync write method.
WRITE_FILESYNC_REPLY	STRING	Specifies the filesync reply method.
WRITE_TRANSFER_MAX_SIZE_GB	NUMBER	Maximum write transfer size to report to clients (GiB)
WRITE_TRANSFER_MAX_SIZE_KB	NUMBER	Maximum write transfer size to report to clients (KiB)
WRITE_TRANSFER_MULITPLE	NUMBER	Suggested multiple write size to report to clients
WRITE_TRANSFER_SIZE_GB	NUMBER	Preferred wrote transfer size to report to clients (GiB)
WRITE_TRANSFER_SIZE_KB	NUMBER	Preferred write transfer size to report to clients (KiB)
WRITE_UNSTABLE_ACTION	STRING	Specifies the unstable-write method.
WRITE_UNSTABLE_REPLY	STRING	Specifies the unstable-reply method.

Table 4.98 aps_v_isi_nfs_export_log
Column Name	Data Type	Description
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
log_date	DATE	The date and time the Isilon NFS export Log data was created in the database.
NFS_EXPORT_ID	NUMBER	The NFS Export ID.
usage_with_overhead_gb	NUMBER	Combined used capacity (in GiB) of all paths in the export (including OneFS overhead).
usage_with_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (including OneFS overhead).
usage_without_overhead_gb	NUMBER	Combined used capacity (in GiB) of all paths in the export (not including OneFS overhead).
usage_without_overhead_kb	NUMBER	Combined used capacity (in KiB) of all paths in the export (not including OneFS overhead).

Table 4.99 aps_v_isi_nfs_export_path
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon NFS export path data was created in the StorageConsole database.
ISI_NFS_EXPORT_ID	NUMBER	NFS Export ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon NFS export path data was last updated in the StorageConsole database.
NFS_EXPORT_ID	NUMBER	The NFS Export ID.
NFS_EXPORT_PATH	STRING	File system paths available via this NFS export.

Table 4.100 aps_v_isi_node
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon node data was created in the StorageConsole database.
CURRENT_TIMESTAMP	DATE	Date/time and timezone of the Isilon node.
ENCODING	STRING	The default character encoding.
FS_SSD_FREE_CAPACITY_GB	NUMBER	Total SSD capacity free on the node (GiB)
FS_SSD_FREE_CAPACITY_KB	NUMBER	Total SSD capacity free on the node.
FS_SSD_TOTAL_CAPACITY_GB	NUMBER	Total SSD capacity on the node (GiB)
FS_SSD_TOTAL_CAPACITY_KB	NUMBER	Total SSD capacity on the node.
FS_SSD_USED_CAPACITY_GB	NUMBER	Total SSD capacity used on the node (GiB)
FS_SSD_USED_CAPACITY_KB	NUMBER	Total SSD capacity used on the node.
FS_TOTAL_CAPACITY_GB	NUMBER	Total filesystem capacity on the drive, including metadata (GiB)
FS_TOTAL_CAPACITY_KB	NUMBER	Total file system capacity on the node.
FS_TOTAL_FREE_CAPACITY_GB	NUMBER	Total filesystem capacity free on the node (GiB)
FS_TOTAL_FREE_CAPACITY_KB	NUMBER	Total file system capacity free on the node.
FS_TOTAL_USED_CAPACITY_GB	NUMBER	Total filesystem capacity used on the node (GiB)
FS_TOTAL_USED_CAPACITY_KB	NUMBER	Total file system capacity used on the node.
HEALTH_STATUS	STRING	Overall status/health of the node.
IS_READ_ONLY	STRING	Indicates if the node is read-only: Y or N.
IS_SMART_FAILED	STRING	Indicates if the node is SmartFailed: Y or N.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_NODE_POOL_ID	NUMBER	Node Pool ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_BOOT_TIME	DATE	Time at which the node was last booted.
LAST_UPDATED	DATE	The date and time the Isilon node data was last updated in the StorageConsole database.
LOGICAL_NODE_NBR	NUMBER	The logical number of the node.
MEMORY_GB	NUMBER	Total memory installed in the node (GiB)
MEMORY_KB	NUMBER	Total memory installed in the node.
NBR_OF_CPUS	NUMBER	The number of CPUs in the node.
NODE_DEVICE_ID	NUMBER	Unique ID assigned when the node joined the cluster.
NODE_GUID	STRING	Unique identifier (GUID) for the node.
NODE_NAME	STRING	Node name
NODE_POOL_NAME	STRING	Node pool Name.
NODE_TYPE	STRING	The type of Isilon node.
NVRAM_CHARGE_STATUS	STRING	Combined charge status for all batteries.
PRODUCT_NAME	STRING	The product name.
SERIAL_NBR	STRING	Serial number of the Isilon node.
UP_TIME_SEC	NUMBER	Seconds since the node was booted.

Table 4.101 aps_v_isi_node_interface
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon node interface data was created in the StorageConsole database.
DEVICE_NAME	STRING	The Unix device name for the interface.
INTERFACE_IANA_TYPE	NUMBER	The type of interface (assigned IANA value).
INTERFACE_STATUS	STRING	The status of the Isilon node interface.
IS_ETHERNET	STRING	Indicates if the Isilon node interface is Ethernet: Y or N.
IS_INFINIBAND	STRING	Indicates if the Isilon node interface is Infiniband: Y or N.
IS_INTERNAL	STRING	Indicates if the interface is internal: Y or N.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_NODE_INTERFACE_ID	NUMBER	Node Interface ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon node interface data was last updated in the StorageConsole database.
MTU_OCTETS	NUMBER	The largest packet size (octets) for the Isilon node interface.
NODE_INTERFACE_NAME	STRING	Node Interface Name
NODE_NAME	STRING	Node name
SPEED_MBPS	NUMBER	Estimate of the current bandwidth (Mbps) for the Isilon node interface.

Table 4.102 aps_v_isi_node_ip_address
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon node IP address data was created in the StorageConsole database.
IP_ADDRESS	STRING	The node’s IPv4 or IPv6 address.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_NODE_INTERFACE_ID	NUMBER	Node Interface ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon node IP address data was last updated in the StorageConsole database.
NODE_INTERFACE_NAME	STRING	Node Interface Name
NODE_NAME	STRING	Node name

Table 4.103 aps_v_isi_node_performance
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the node at collection time.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the node at collection time.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the node at collection time.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster at collection time.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the node at collection time.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the node at collection time.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the node at collection time.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the node at collection time.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the node at collection time.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all external interfaces in the node at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all external interfaces in the node at collection time.
FS_DATA_IN_GB	NUMBER	Cumulative data (Gigabytes) written to the OneFS file system on the node since node boot.
FS_DATA_IN_KB	NUMBER	Cumulative data (Kilobytes) written to the OneFS file system on the node since node boot.
FS_DATA_OUT_GB	NUMBER	Cumulative data (Gigabytes) read from the OneFS file system on the node since node boot.
FS_DATA_OUT_KB	NUMBER	Cumulative data (Kilobytes) read from the OneFS file system on the node since node boot.
FS_OPERATION_RATE_IN_OPS	NUMBER	Transfer rate of writes to the OneFS file system on the node (IOPS) at collection time.
FS_OPERATION_RATE_OUT_OPS	NUMBER	Transfer rate of reads from the OneFS file system on the node (IOPS) at collection time.
FS_RATE_IN_BPS	NUMBER	Transfer rate of writes to the OneFS file system on the node (bytes/second) at collection time.
FS_RATE_OUT_BPS	NUMBER	Transfer rate of reads from the OneFS file system on the node (bytes/second) at collection time.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all internal interfaces in the node at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all internal interfaces in the node at collection time.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
MAX_CPU_PCT	NUMBER	Single highest CPU usage (percent) in the node at collection time.
MEMORY_CACHE_KB	NUMBER	Memory used for cache (KiB) on the node at collection time.
MEMORY_FREE_KB	NUMBER	Memory free (KiB) on the node at collection time.
MEMORY_USED_KB	NUMBER	Memory used (KiB) on the node at collection time.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Total number of clients actively transferring to/from the node at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Total number of clients connected to the node at collection time.
NODE_NAME	STRING	Node name
TOTAL_DISK_RATE_IN_BPS	NUMBER	Disk rate: Total disk write performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_IN_OPS	NUMBER	Disk rate: Total disk write performance (IOPS) across the cluster at collection time.
TOTAL_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Total disk read performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Total disk read performance (IOPS) across the cluster at collection time.

Table 4.104 aps_v_isi_node_pool
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon node pool data was created in the StorageConsole database.
HEALTH_STATUS	STRING	Overall health of the Isilon node pool.
IS_HEALTH_OK	STRING	Indicates if the Isilon node is OK: Y or N.
IS_MISSING_DRIVES	STRING	Indicates if there are drives missing from the Isilon node pool: Y or N.
IS_NEED_REPAIR	STRING	Indicates if some nodes and/or drives need repair: Y or N.
IS_OFFLINE	STRING	Indicates if some nodes and/or drives are down: Y or N.
IS_SMART_FAILED	STRING	Indicates if some nodes and/or drives are smart-failed: Y or N.
IS_TOO_FEW_NODES	STRING	Indicates if there are too few Isilon nodes available.
ISI_NODE_POOL_ID	NUMBER	Node pool ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
ISI_TIER_ID	NUMBER	Isilon tier ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon node pool data was last updated in the StorageConsole database.
NODE_POOL_NAME	STRING	Node pool Name.
TIER_NAME	STRING	Tier Name

Table 4.105 aps_v_isi_node_prf_log_day
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the node for the day.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the node for the day.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the node for the day.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the node for the day.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster for the day.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the node for the day.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster for the day.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the node for the day.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the node for the day.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the node for the day.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the node for the day.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the node for the day.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all external interfaces in the node for the day.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all external interfaces in the node for the day.
FS_DATA_IN_GB	NUMBER	Cumulative data (GiB) written to the OneFS file system on the node for the day.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system on the node for the day.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system on the node for the day.
FS_DATA_OUT_KB	NUMBER	Cumulative data (KiB) read from the OneFS file system on the node for the day.
FS_OPERATION_RATE_IN_OPS	NUMBER	Average Transfer rate of writes to the OneFS file system on the node (IOPS) for the day.
FS_OPERATION_RATE_OUT_OPS	NUMBER	Average Transfer rate of reads from the OneFS file system on the node (IOPS) afor the day.
FS_RATE_IN_BPS	NUMBER	Average Transfer rate of writes to the OneFS file system on the node (bytes/second) for the day.
FS_RATE_OUT_BPS	NUMBER	Average Transfer rate of reads from the OneFS file system on the node (bytes/second) for the day.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all internal interfaces in the node for the day.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all internal interfaces in the node for the day.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Midnight time stamp of the day the record was aggregated for the log entry.
MAX_CPU_PCT	NUMBER	Maximum CPU usage (percent) in the node for the day.
MEMORY_CACHE_KB	NUMBER	Average memory used for cache (KiB) on the node for the day.
MEMORY_FREE_KB	NUMBER	Average memory free (KiB) on the node for the day.
MEMORY_USED_KB	NUMBER	Average memory used (KiB) on the node for the day.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Average clients actively transferring to/from the node for the day.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Average clients connected to the node for the day.
NODE_NAME	STRING	Node name
TOTAL_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the node for the day.
TOTAL_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster for the day.
TOTAL_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the node for the day.
TOTAL_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster for the day.

Table 4.106 aps_v_isi_node_prf_log_hr
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the node for the hour.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the node for the hour.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the node for the hour.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the node for the hour.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster for the hour.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the node for the hour.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster for the hour.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the node for the hour.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the node for the hour.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the node for the hour.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the node for the hour.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the node for the hour.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all external interfaces in the node for the hour.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all external interfaces in the node for the hour.
FS_DATA_IN_GB	NUMBER	Average rate of writes to the OneFS file system on the node (bytes/second) for the hour.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system on the node since node boot.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system on the node for the hour.
FS_DATA_OUT_KB	NUMBER	Average rate of reads from the OneFS file system on the node (bytes/second) for the hour.
FS_OPERATION_RATE_IN_OPS	NUMBER	Average rate of writes to the OneFS file system on the node (IOPS) for the hour.
FS_OPERATION_RATE_OUT_OPS	NUMBER	Average rate of reads from the OneFS file system on the node (IOPS) for the hour.
FS_RATE_IN_BPS	NUMBER	Average rate of writes to the OneFS file system on the node (bytes/second) for the hour.
FS_RATE_OUT_BPS	NUMBER	Average rate of reads from the OneFS file system on the node (bytes/second) for the hour.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Average network rate (in bytes/second) for all internal interfaces in the node for the hour.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Average network rate out (bytes/second) for all internal interfaces in the node for the hour.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
MAX_CPU_PCT	NUMBER	Maximum CPU usage (percent) in the node for the hour.
MEMORY_CACHE_KB	NUMBER	Memory used for cache (KiB) on the node for the hour.
MEMORY_FREE_KB	NUMBER	Average memory free (KiB) on the node for the hour.
MEMORY_USED_KB	NUMBER	Average memory used (KiB) on the node for the hour.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Average number of clients actively transferring to/from the node for the hour.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Average number of clients connected to the node for the hour.
NODE_NAME	STRING	Node name
TOTAL_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the node for the hour.
TOTAL_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster for the hour.
TOTAL_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the node for the hour.
TOTAL_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster for the hour.

Table 4.107 aps_v_isi_node_prf_log_min
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_CPU_PCT	NUMBER	Average CPU usage (percent) across the node at collection time.
AVG_DISK_BUSY_PCT	NUMBER	Average disk busy (percent) across the node at collection time.
AVG_DISK_LATENCY_MS	NUMBER	Average disk latency (milliseconds) across the node at collection time.
AVG_DISK_RATE_IN_BPS	NUMBER	Disk rate: Average disk write performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_IN_OPS	NUMBER	Disk rate: Average disk write performance (IOPS) across the cluster at collection time.
AVG_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Average disk read performance (bytes/second) across the node at collection time.
AVG_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Average disk read performance (IOPS) across the cluster at collection time.
AVG_IDLE_CPU_PCT	NUMBER	Average CPU idle (percent) across the node at collection time.
AVG_INTERRUPT_CPU_PCT	NUMBER	Average interrupt CPU usage (percent) across the node at collection time.
AVG_NICE_CPU_PCT	NUMBER	Average nice CPU (CPU scheduling priority) usage (percent) across the node at collection time.
AVG_SYSTEM_CPU_PCT	NUMBER	Average system CPU usage (percent) across the node at collection time.
AVG_USER_CPU_PCT	NUMBER	Average user CPU usage (percent) across the node at collection time.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
EXTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all external interfaces in the node at collection time.
EXTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all external interfaces in the node at collection time.
FS_DATA_IN_GB	NUMBER	Cumulative data (GiB) written to the OneFS file system on the node since node boot.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system on the node since node boot.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system on the node since node boot.
FS_DATA_OUT_KB	NUMBER	Cumulative data (KiB) read from the OneFS file system on the node since node boot.
FS_OPERATION_RATE_IN_OPS	NUMBER	Transfer rate of writes to the OneFS file system on the node (IOPS) at collection time.
FS_OPERATION_RATE_OUT_OPS	NUMBER	Transfer rate of reads from the OneFS file system on the node (IOPS) at collection time.
FS_RATE_IN_BPS	NUMBER	Transfer rate of writes to the OneFS file system on the node (bytes/second) at collection time.
FS_RATE_OUT_BPS	NUMBER	Transfer rate of reads from the OneFS file system on the node (bytes/second) at collection time.
INTERNAL_NETWORK_RATE_IN_BPS	NUMBER	Total network rate (in bytes/second) for all internal interfaces in the node at collection time.
INTERNAL_NETWORK_RATE_OUT_BPS	NUMBER	Total network rate out (bytes/second) for all internal interfaces in the node at collection time.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date/time that the samples were collected.
MAX_CPU_PCT	NUMBER	Single highest CPU usage (percent) in the node at collection time.
MEMORY_CACHE_KB	NUMBER	Memory used for cache (KiB) on the node at collection time.
MEMORY_FREE_KB	NUMBER	Memory free (KiB) on the node at collection time.
MEMORY_USED_KB	NUMBER	Memory used (KiB) on the node at collection time.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Total number of clients actively transferring to/from the node at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Total number of clients connected to the node at collection time.
NODE_NAME	STRING	Node name
TOTAL_DISK_RATE_IN_BPS	NUMBER	Disk rate: Total disk write performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_IN_OPS	NUMBER	Disk rate: Total disk write performance (IOPS) across the cluster at collection time.
TOTAL_DISK_RATE_OUT_BPS	NUMBER	Disk rate: Total disk read performance (bytes/second) across the node at collection time.
TOTAL_DISK_RATE_OUT_OPS	NUMBER	Disk rate: Total disk read performance (IOPS) across the cluster at collection time.

Table 4.108 aps_v_isi_onefs
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon OneFS file system data was created in the StorageConsole database.
FS_AVAILABLE_CAPACITY_GB	NUMBER	Available filesystem capacity (GiB)
FS_AVAILABLE_CAPACITY_KB	NUMBER	Available OneFS file system capacity.
FS_BLOCK_SIZE_KB	NUMBER	The size of blocks allocated in the OneFS file system.
FS_CAPACITY_INCL_SPARE_GB	NUMBER	Total filesystem capacity (GiB)
FS_CAPACITY_INCL_SPARE_KB	NUMBER	Total OneFS file system capacity.
FS_DISK_RESERVED_CAPACITY_GB	NUMBER	Capacity reserved per disk (GiB)
FS_DISK_RESERVED_CAPACITY_KB	NUMBER	Capacity reserved per disk (OneFS).
FS_HOT_SPARE_CAPACITY_GB	NUMBER	Virtual Hot Spare reserved (GiB)
FS_HOT_SPARE_CAPACITY_KB	NUMBER	Virtual Hot Spare reserved (OneFS)
FS_ROOT_PATH	STRING	File System root path
FS_SSD_FREE_CAPACITY_GB	NUMBER	Total SSD capacity free on the node (GiB)
FS_SSD_FREE_CAPACITY_KB	NUMBER	Free SSD capacity (OneFS).
FS_SSD_TOTAL_CAPACITY_GB	NUMBER	Total SSD capacity on the node (GiB)
FS_SSD_TOTAL_CAPACITY_KB	NUMBER	Total SSD capacity (OneFS).
FS_SSD_USED_CAPACITY_GB	NUMBER	Total SSD capacity used on the node (GiB)
FS_SSD_USED_CAPACITY_KB	NUMBER	Used SSD capacity (OneFS).
FS_USABLE_CAPACITY_GB	NUMBER	Total usable filesystem capacity (GiB)
FS_USABLE_CAPACITY_KB	NUMBER	Total usable OneFS file system capacity.
FS_USED_CAPACITY_GB	NUMBER	Used filesystem capacity on the drive (GiB)
FS_USED_CAPACITY_KB	NUMBER	Used OneFS file system capacity.
ISI_ONEFS_ID	NUMBER	ID for the Isilon OneFS distributed file system, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon OneFS file system data was last updated in the StorageConsole database.

Table 4.109 aps_v_isi_onefs_performance
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
FS_DATA_IN_GB	NUMBER	Cumulative data (GiB) written to the OneFS file system.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system.
FS_DATA_OUT_KB	NUMBER	Cumulative data (KiB) read from the OneFS file system.
FS_RATE_IN_BPS	NUMBER	Transfer rate of writes to the OneFS file system (bytes/second) at collection time.
FS_RATE_OUT_BPS	NUMBER	Transfer rate of reads from the OneFS file system (bytes/second) at collection time.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date/time that the samples were collected.

Table 4.110 aps_v_isi_onefs_prf_log_day
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
FS_DATA_IN_GB	NUMBER	Cumulative data (GiB) written to the OneFS file system for the day.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system for the day.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system for the day.
FS_DATA_OUT_KB	NUMBER	Cumulative data (KiB) read from the OneFS file system for the day.
FS_RATE_IN_BPS	NUMBER	Average rate of writes to the OneFS file system (bytes/second) for the day.
FS_RATE_OUT_BPS	NUMBER	Average rate of reads from the OneFS file system (bytes/second) for the day.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Midnight time stamp of the day the record was aggregated for.

Table 4.111 aps_v_isi_onefs_prf_log_hr
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
FS_DATA_IN_GB	NUMBER	Cumulative data (GiB) written to the OneFS file system for the hour.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system for the hour.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system for the hour.
FS_DATA_OUT_KB	NUMBER	Cumulative data (KiB) read from the OneFS file system for the hour.
FS_RATE_IN_BPS	NUMBER	Average rate of writes to the OneFS file system (bytes/second) for the hour.
FS_RATE_OUT_BPS	NUMBER	Average rate of reads from the OneFS file system (bytes/second) for the hour.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.

Table 4.112 aps_v_isi_onefs_prf_log_min
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
FS_DATA_IN_GB	NUMBER	Cumulative data (GiB) written to the OneFS file system.
FS_DATA_IN_KB	NUMBER	Cumulative data (KiB) written to the OneFS file system.
FS_DATA_OUT_GB	NUMBER	Cumulative data (GiB) read from the OneFS file system.
FS_DATA_OUT_KB	NUMBER	Cumulative data (KiB) read from the OneFS file system.
FS_RATE_IN_BPS	NUMBER	Transfer rate of writes to the OneFS file system (bytes/second) at collection time.
FS_RATE_OUT_BPS	NUMBER	Transfer rate of reads from the OneFS file system (bytes/second) at collection time.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date/time that the samples were collected.

Table 4.113 aps_v_isi_protocol_client
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name.
CLIENT_ADDRESS	STRING	Address of the client.
CREATION_DATE	DATE	The date and time the Isilon protocol data was created in the StorageConsole database.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon protocol data was last updated in the StorageConsole database.
NODE_NAME	STRING	Node name.
PROTOCOL_NAME	STRING	Name of the protocol for the client.

Table 4.114 aps_v_isi_protocol_performance
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name.
AVG_LATENCY_MS	NUMBER	The average latency in (milliseconds) for all operations for the protocol on this node.
AVG_OPERATION_SIZE_IN_BYTE	NUMBER	The average input size (bytes) of all operations for the protocol on this node.
AVG_OPS_SIZE_OUT_BYTE	NUMBER	The average output size (bytes) of all operations for the protocol on this node.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
isi_protocol_id	NUMBER	Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date/time that the samples were collected.
MAX_LATENCY_MS	NUMBER	The maximum latency in (milliseconds) for all operations for the protocol on this node.
MAX_OPERATION_SIZE_IN_BYTE	NUMBER	The largest input size (bytes) of all operations for the protocol on this node.
MAX_OPS_SIZE_OUT_BYTE	NUMBER	The largest output size (bytes) of all operations for the protocol on this node.
MIN_LATENCY_MS	NUMBER	The minimum latency (milliseconds) for all operations for the protocol on this node.
MIN_OPERATION_SIZE_IN_BYTE	NUMBER	The smallest input size (bytes) of all operations for the protocol on this node.
MIN_OPS_SIZE_OUT_BYTE	NUMBER	The smallest output size (bytes) of all operations for the protocol on this node.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Number of clients actively transferring to/from the node via this protocol at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Number of clients connected to the node via this protocol at collection time.
NODE_NAME	STRING	Node name
OPERATION_RATE_OPS	NUMBER	Transfer rate (IOPS) for this protocol on this node at collection time.
PROTOCOL_NAME	STRING	Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS	NUMBER	Transfer rate (in bytes/second) for this protocol on this node at collection time.
TRANSFER_RATE_OUT_BPS	NUMBER	Transfer rate out (bytes/second) for this protocol on this node at collection time.

Table 4.115 aps_v_isi_protocol_prf_log_day
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_LATENCY_MS	NUMBER	Average latency in (milliseconds) for all operations for the protocol on this node for the day.
AVG_OPERATION_SIZE_IN_BYTE	NUMBER	Average input size (bytes) of all operations for the protocol on this node for the day.
AVG_OPS_SIZE_OUT_BYTE	NUMBER	Average output size (bytes) of all operations for the protocol on this node for the day.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for the day for which the data was collected.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
isi_protocol_id	NUMBER	Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Midnight time stamp of the day the record was aggregated for.
MAX_LATENCY_MS	NUMBER	Maximum latency in (milliseconds) for all operations for the protocol on this node for the day.
MAX_OPERATION_SIZE_IN_BYTE	NUMBER	Maximum input size (bytes) of all operations for the protocol on this node for the day.
MAX_OPS_SIZE_OUT_BYTE	NUMBER	Maximum output size (bytes) of all operations for the protocol on this node for the day.
MIN_LATENCY_MS	NUMBER	Minimum latency (milliseconds) for all operations for the protocol on this node for the day.
MIN_OPERATION_SIZE_IN_BYTE	NUMBER	Minimum input size (bytes) of all operations for the protocol on this node for the day.
MIN_OPS_SIZE_OUT_BYTE	NUMBER	Minimum output size (bytes) of all operations for the protocol on this node for the day.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Average number of clients actively transferring to/from the node via this protocol for the day.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Average number of clients connected to the node via this protocol for the day.
NODE_NAME	STRING	Node name
OPERATION_RATE_OPS	NUMBER	Average transfer rate (IOPS) for this protocol on this node for the day.
PROTOCOL_NAME	STRING	Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS	NUMBER	Average transfer rate (in bytes/second) for this protocol on this node for the day.
TRANSFER_RATE_OUT_BPS	NUMBER	Average transfer rate out (bytes/second) for this protocol on this node for the day.

Table 4.116 aps_v_isi_protocol_prf_log_hr
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_LATENCY_MS	NUMBER	Average latency in (milliseconds) for all operations for the protocol on this node for the day.
AVG_OPERATION_SIZE_IN_BYTE	NUMBER	Average input size (bytes) of all operations for the protocol on this node for the day.
AVG_OPS_SIZE_OUT_BYTE	NUMBER	Average output size (bytes) of all operations for the protocol on this node for the day.
CUM_INTERVAL_SEC	NUMBER	Time interval in seconds for which the data was collected.
INTERVAL_TYPE	STRING	Interval type of the collection.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
isi_protocol_id	NUMBER	Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Hourly time stamp format (hh24:00:00) for the hour the log record was aggregated.
MAX_LATENCY_MS	NUMBER	Maximum latency in (milliseconds) for all operations for the protocol on this node for the day.
MAX_OPERATION_SIZE_IN_BYTE	NUMBER	Maximum input size (bytes) of all operations for the protocol on this node for the day.
MAX_OPS_SIZE_OUT_BYTE	NUMBER	Maximum output size (bytes) of all operations for the protocol on this node for the day.
MIN_LATENCY_MS	NUMBER	Minimum latency (milliseconds) for all operations for the protocol on this node for the day.
MIN_OPERATION_SIZE_IN_BYTE	NUMBER	Minimum input size (bytes) of all operations for the protocol on this node for the day.
MIN_OPS_SIZE_OUT_BYTE	NUMBER	Minimum output size (bytes) of all operations for the protocol on this node for the day.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Average number of clients actively transferring to/from the node via this protocol for the day.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Average number of clients connected to the node via this protocol for the day.
NODE_NAME	STRING	Node name
OPERATION_RATE_OPS	NUMBER	Average transfer rate (IOPS) for this protocol on this node for the day.
PROTOCOL_NAME	STRING	Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS	NUMBER	Average transfer rate (in bytes/second) for this protocol on this node for the day.
TRANSFER_RATE_OUT_BPS	NUMBER	Average transfer rate out (bytes/second) for this protocol on this node for the day.

Table 4.117 aps_v_isi_protocol_prf_log_min
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
AVG_LATENCY_MS	NUMBER	The average latency in (milliseconds) for all operations for the protocol on this node.
AVG_OPERATION_SIZE_IN_BYTE	NUMBER	The average input size (bytes) of all operations for the protocol on this node.
AVG_OPS_SIZE_OUT_BYTE	NUMBER	The average output size (bytes) of all operations for the protocol on this node.
CUM_INTERVAL_SEC	NUMBER	Time interval, in seconds, for which the Isilon protocol performance data was collected.
INTERVAL_TYPE	STRING	Interval type of the protocol performance collection.
ISI_NODE_ID	NUMBER	Node ID, for internal use by the StorageConsole database.
isi_protocol_id	NUMBER	Protocol ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LOG_DATE	DATE	Date and time the Isilon protocol performance samples were collected.
MAX_LATENCY_MS	NUMBER	The maximum latency in (milliseconds) for all operations for the protocol on this node.
MAX_OPERATION_SIZE_IN_BYTE	NUMBER	The largest input size (bytes) of all operations for the protocol on this node.
MAX_OPS_SIZE_OUT_BYTE	NUMBER	The largest output size (bytes) of all operations for the protocol on this node.
MIN_LATENCY_MS	NUMBER	The minimum latency (milliseconds) for all operations for the protocol on this node.
MIN_OPERATION_SIZE_IN_BYTE	NUMBER	The smallest input size (bytes) of all operations for the protocol on this node.
MIN_OPS_SIZE_OUT_BYTE	NUMBER	The smallest output size (bytes) of all operations for the protocol on this node.
NBR_OF_ACTIVE_CLIENTS	NUMBER	Number of clients actively transferring to/from the node via this protocol at collection time.
NBR_OF_CONNECTED_CLIENTS	NUMBER	Number of clients connected to the node via this protocol at collection time.
NODE_NAME	STRING	Node name
OPERATION_RATE_OPS	NUMBER	Transfer rate (IOPS) for this protocol on this node at collection time.
PROTOCOL_NAME	STRING	Protocol to which this performance data belongs.
TRANSFER_RATE_IN_BPS	NUMBER	Transfer rate (in bytes/second) for this protocol on this node at collection time.
TRANSFER_RATE_OUT_BPS	NUMBER	Transfer rate out (bytes/second) for this protocol on this node at collection time.

Table 4.118 aps_v_isi_quota
Column Name	Data Type	Description
advisory_threshold_kb	NUMBER	The advisory threshold (in KB).
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon snapshot data was created in the StorageConsole database.
fs_root_path	STRING	File System root path.
grace_period_sec	NUMBER	The soft threshold grace period (in seconds).
hard_threshold_kb	NUMBER	The hard threshold (in KB).
is_container	STRING	Whether the hard threshold is shown as the capacity of a CIFS share using this quota.
is_enforced	STRING	Whether the quota is an enforced quota (true) or an accounting quota (false).
is_include_overhead	STRING	Whether filesystem overheads are counted against the thresholds.
is_include_snap_usage	STRING	Whether snapshots are counted against the thresholds.
is_linked	STRING	Indicates if mounting subdirectories directly is allowed: Y or N.
isi_onefs_id	NUMBER	OneFS ID, for internal use by the database.
isi_quota_id	NUMBER	Quota ID, for internal use by the database.
isi_storage_system_id	NUMBER	Storage system ID, for internal use by the database.
LAST_UPDATED	DATE	The date and time the Isilon snapshot data was last updated in the StorageConsole database.
nbr_of_files_dirs	NUMBER	The number of files and/or directories under the quota path.
quota_path	STRING	The path to which the quota applies.
soft_threshold_kb	NUMBER	The soft threshold (in KB).
type_id	NUMBER	Quota type ID.
type_name	STRING	Quota type name.
usage_with_overhead_gb	NUMBER	The used capacity, including filesystem overheads (in GB).
usage_with_overhead_kb	NUMBER	The used capacity, including filesystem overheads (in KB).
usage_without_overhead_gb	NUMBER	The used capacity, not including filesystem overheads (in GB).
usage_without_overhead_kb	NUMBER	The used capacity, not including filesystem overheads (in KB).
user_group_id	NUMBER	The UID or GID that the quota applies to.
user_group_name	STRING	The user or group name that the quota applies to.

Table 4.119 aps_v_isi_snapshot
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon snapshot data was created in the StorageConsole database.
FS_ROOT_PATH	STRING	File System root path
FS_USED_PCT	NUMBER	Percentage of the file system used by this snapshot.
IS_SNAPSHOT_LOCKED	STRING	Indicates if the snapshot has any locks: Y or N.
ISI_ONEFS_ID	NUMBER	OneFS ID, for internal use by the StorageConsole database.
ISI_SNAPSHOT_SCHEDULE_ID	NUMBER	Snapshot Schedule ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon snapshot data was last updated in the StorageConsole database.
RESERVED_USED_PCT	NUMBER	Percentage of the snapshot reserve used by this snapshot.
SCHEDULE_NAME	STRING	Schedule Name
SCHEDULE_WHEN	STRING	When snapshots will be taken
SNAPSHOT_ALIAS	STRING	Alias for the snapshot.
SNAPSHOT_CREATION_DATE	DATE	The date and time the snapshot was created.
SNAPSHOT_EXPIRATION_DATE	DATE	The date and time the snapshot will expire.
SNAPSHOT_ID	NUMBER	Snapshot ID, for internal use by the StorageConsole database.
SNAPSHOT_NAME	STRING	Isilon snapshot name.
SNAPSHOT_PATH	STRING	Path for which the snapshot was taken.
SNAPSHOT_SHADOW_GB	NUMBER	The amount of data referenced from shadow stored (GiB)
SNAPSHOT_SHADOW_KB	NUMBER	The amount of data referenced from shadow stores (KiB).
SNAPSHOT_SIZE_GB	NUMBER	The size of the snapshot (GiB)
SNAPSHOT_SIZE_KB	NUMBER	The size of the snapshot (KiB).
SNAPSHOT_STATE	STRING	The state of the snapshot.

Table 4.120 aps_v_isi_snapshot_schedule
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
CREATION_DATE	DATE	The date and time the Isilon snapshot data was created in the StorageConsole database.
ISI_SNAPSHOT_SCHEDULE_ID	NUMBER	Snapshot Schedule ID, for internal use by the StorageConsole database.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon snapshot data was last updated in the StorageConsole database.
SCHEDULE_ALIAS	STRING	Alias for the latest snapshot generated by the schedule.
SCHEDULE_EXPIRE	STRING	When snapshots will expire (duration or date).
SCHEDULE_INDEX	NUMBER	The snapshot schedule index.
SCHEDULE_NAME	STRING	Schedule Name
SCHEDULE_PATH	STRING	The path that will be used by the schedule for the snapshot.
SCHEDULE_WHEN	STRING	When snapshots will be taken

Table 4.121 aps_v_isi_storage_system
Column Name	Data Type	Description
ARRAY_NAME	STRING	Array name
BUILD_VERSION	STRING	The build version string for the cluster.
CREATION_DATE	DATE	The date and time the Isilon storage system data was created in the StorageConsole database.
HEALTH_STATUS	STRING	Overall status/health of the cluster.
IS_ROOT_ACCESS_CIFS	STRING	Indicates if snapshot directories are accessible via CIFS: Y or N.
IS_ROOT_ACCESS_LOCAL	STRING	Indicates if snapshot directories are accessible via the local file system: Y or N.
IS_ROOT_ACCESS_NFS	STRING	Indicates if snapshot directories are accessible via NFS: Y or N.
IS_ROOT_VISIBLE_CIFS	STRING	Indicates if snapshot directories are visible via CIFS: Y or N.
IS_ROOT_VISIBLE_LOCAL	STRING	Indicates if snapshot directories are visible in the local file system: Y or N.
IS_ROOT_VISIBLE_NFS	STRING	Indicates if snapshot directories are visible via NFS: Y or N.
IS_SCHEDULE_CREATION_ENABLED	STRING	Indicates if scheduled snapshot creation is enabled: Y or N.
IS_SCHEDULE_DELETION_ENABLED	STRING	Indicates if scheduled snapshot deletion is enabled: Y or N.
IS_SUBDIR_ACCESS_CIFS	STRING	Indicates if snapshot subdirectories are accessible via CIFS: Y or N.
IS_SUBDIR_ACCESS_LOCAL	STRING	Indicates if snapshot subdirectories are accessible via the local file system: Y or N.
IS_SUBDIR_ACCESS_NFS	STRING	Indicates if snapshot subdirectories are accessible via NFS: Y or N.
ISI_STORAGE_SYSTEM_ID	NUMBER	Storage system ID, for internal use by the StorageConsole database.
LAST_UPDATED	DATE	The date and time the Isilon storage system data was last updated in the StorageConsole database.
NBR_OF_CHASSIS	NUMBER	Number of chassis associated with the cluster.
NBR_OF_CIFS_SHARES	NUMBER	Number of CIFS Shares associated with the cluster.
NBR_OF_CPUS	NUMBER	# CPUs across the entire cluster.
NBR_OF_DRIVE_BAYS	NUMBER	Number of drive bays associated with the cluster.
NBR_OF_FTPS	NUMBER	Number of FTP associated with the cluster.
NBR_OF_HDFS	NUMBER	Number of HDFS (Hadoop Distributed File Systems) associated with the cluster.
NBR_OF_NFS_EXPORTS	NUMBER	Number of NFS Exports associated with the cluster.
NBR_OF_NODES	NUMBER	Number of nodes associated with the cluster.
NBR_OF_SNAPSHOTS	NUMBER	Number of snapshots associated with the cluster.
OS_TYPE	STRING	The cluster operating system name.
SNAPSHOT_RESERVED_PCT	NUMBER	Percentage of the file system reserved for snapshots.
SNAPSHOT_USED_GB	NUMBER	Number of snapshot used in the cluster (GiB)
SNAPSHOT_USED_KB	NUMBER	Number of snapshots used in the cluster.