Capacity Manager Database Views > NetApp Cluster-Mode Database Views
  
Version 9.2.00
NetApp Cluster-Mode Database Views
aps_v_ntc_aggregate
The aps_v_ntc_aggregate view contains a single row for each NetApp Cluster Aggregate.
Table 4.270 aps_v_ntc_aggregate
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
AGGREGATE_STATE
STRING
Aggregate state.
AGGREGATE_TYPE
STRING
The type of aggregate.
AGGREGATE_UUID
STRING
Aggregate's universally unique Identifier.
AGGR_METADATA_USED_GB
NUMBER
This field represents space used by file system metadata of the aggregate. Range: [0..264-1]
AGGR_METADATA_USED_KB
NUMBER
This field represents space used by file system metadata of the aggregate. Range: [0..264-1]
AGGR_USED_INCL_SNAP_RESERVE_GB
NUMBER
Space used by the aggregate (bytes), including the aggregate's snapshot reserve.
AGGR_USED_INCL_SNAP_RESERVE_KB
NUMBER
Space used by the aggregate (bytes), including the aggregate's snapshot reserve.
ARRAY_NAME
STRING
Array name
BLOCK_TYPE
STRING
The indirect block format of the aggregate. A 64_bit value indicates that associated aggregates can be larger than 16TB.
CHECKSUM_STATUS
STRING
Checksum status (not available for a striped aggregate).
CHECKSUM_STYLE
STRING
Checksum style.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode aggregate data was created in the StorageConsole database.
FILE_SYSTEM_AVAILABLE_GB
NUMBER
Number of bytes still available in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_AVAILABLE_KB
NUMBER
Number of bytes still available in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_RESERVED_GB
NUMBER
The total disk space (in bytes) that is reserved on the file system.
FILE_SYSTEM_RESERVED_KB
NUMBER
The total disk space (in bytes) that is reserved on the file system.
FILE_SYSTEM_TOTAL_GB
NUMBER
Total size (in bytes) of the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_TOTAL_KB
NUMBER
Total size (in bytes) of the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_USED_GB
NUMBER
Number of bytes used in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_USED_KB
NUMBER
Number of bytes used in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_USED_PCT
NUMBER
Percentage of disk space currently in use on the referenced file system.
FREE_SPACE_REALLOC_STATE
STRING
Free space reallocation state of the aggregate.
FS_ID
NUMBER
Aggregate's file system identifier.
HAS_LOCAL_ROOT
STRING
Indicates if the aggregate contains the local root volume (not available for a striped aggregate).
HAS_PARTNER_ROOT
STRING
Indicates if the aggregate contains the partner's root volume (not available for a striped aggregate).
HA_POLICY
STRING
Aggregate's high-availability (HA) policy.
HOME_NODE_ID
NUMBER
Name of the node to which this aggregate's disks have been administratively assigned.
HOME_NODE_NAME
STRING
Home node name
HYBRID_AGGR_TOTAL_CACHE_GB
NUMBER
Total cache size (in bytes) for a hybrid aggregate.
HYBRID_AGGR_TOTAL_CACHE_KB
NUMBER
Total cache size (in bytes) for a hybrid aggregate.
INODE_USED_CAPACITY_PCT
NUMBER
The percentage of disk space in use, based on a file (inode) count on the file system.
IS_CHECKSUM_ENABLED
STRING
Indicates if checksum is enabled for the aggregate.
IS_HYBRID
STRING
Indicates if the aggregate contains both SSD and non-SSD RAID groups.
IS_HYBRID_ENABLED
STRING
Indicates if the aggregate is eligible to contain both SSD and non-SSD RAID groups.
IS_INCONSISTENT
STRING
Indicates if the aggregate is inconsistent.
IS_SNAPLOCK
STRING
Indicates if the aggregate is a SnapLock aggregate.
IS_SNAPSHOT_AUTO_CREATE
STRING
Indicates if auto-snapshot is enabled on the aggregate.
IS_SNAPSHOT_AUTO_DELETE
STRING
Indicates if snapshot auto-delete is enabled for the aggregate.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode aggregate data was last updated in the StorageConsole database.
MAX_CACHE_RAID_GROUP_GB
NUMBER
Maximum cache RAID group size of a hybrid aggregate. RAID group size is the maximum number of disks that can be added to a RAID group.
MAX_CACHE_RAID_GROUP_KB
NUMBER
Maximum cache RAID group size of a hybrid aggregate. RAID group size is the maximum number of disks that can be added to a RAID group.
MAX_USER_FILE_AVAILABLE
NUMBER
Maximum number of user-visible files allowable on the file system.
MAX_USER_FILE_POSSIBLE
NUMBER
Maximum value to which the Max User Files Available value can be increased, on the file system.
MAX_USER_FILE_USED
NUMBER
Number of user-visible files in use on the file system.
MAX_WRITE_ALLOC_BLOCKS
NUMBER
Maximum number of blocks used for write allocation. Some sequential read workloads may benefit from increasing this value.
MIRROR_STATUS
STRING
Aggregate's mirror status (not available for a striped aggregate).
MOUNT_STATE
STRING
Volume's mount state (not available for a striped aggregate).
NBR_OF_COLLECTIVE_FLEX_VOL
NUMBER
Number of striped volumes in the aggregate.
NBR_OF_DISKS
NUMBER
Number of disks in the aggregate.
NBR_OF_DP_SNAPMIRROR_DEST_VOL
NUMBER
When present, the number of data protection (dp) SnapMirror destination volumes.
NBR_OF_FLEX_VOL
NUMBER
Number of volumes in the aggregate.
NBR_OF_INODE_FOR_SYSTEM_FILE
NUMBER
Number of inodes that can be stored on disk for system files (not user-visible files). This number dynamically increases as additional system files are created.
NBR_OF_INODE_FOR_USER_FILE
NUMBER
Number of inodes that can be stored on disk for user-visible files. This number dynamically increases as additional user-visible files are created.
NBR_OF_LS_SNAPMIRROR_DEST_VOL
NUMBER
When present, this field indicates the number of load sharing SnapMirror destination volumes.
NBR_OF_MV_SNAPMIRROR_DEST_VOL
NUMBER
When present, this field indicates the number of move SnapMirror destination volumes that are created for volume move operations.
NBR_OF_NOT_ONLINE_FLEX_VOL
NUMBER
When present, this field indicates the number of volumes that are not online (offline and restricted volumes).
NBR_OF_PLEXES
NUMBER
Number of plexes in the aggregate. This value represents the size of the plex array.
NBR_OF_QUIESCED_FLEX_VOL
NUMBER
When present, this field indicates the number of quiesced online volumes.
NBR_OF_STRIPED_FLEX_VOL
NUMBER
Number of striped volumes in the aggregate. These volumes are also reported in the full volume count value.
NBR_OF_SYSTEM_FILE_USED
NUMBER
Number of system (not user-visible) files (inodes) used.
NBR_OF_THIN_VOLUMES
NUMBER
Number of thin volumes in the aggregate.
NBR_OF_USER_FILE_TOTAL
NUMBER
Maximum number of user-visible files (inodes) that the file system can hold.
NBR_OF_USER_FILE_USED
NUMBER
Number of user-visible files (inodes) used in the file system.
NBR_OF_VOLUMES
NUMBER
Number of volumes in the aggregate.
NODE_NAME
STRING
Node name
NTC_AGGREGATE_ID
NUMBER
Aggregate ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
List of node names.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
OWNER_NODE_ID
NUMBER
Name of the node that owns the aggregate.
OWNER_NODE_NAME
STRING
Owner node name
RAID_LOST_WRITE_STATE
STRING
State of the RAID Lost Write feature for an aggregate.
RAID_SIZE_GB
NUMBER
RAID group size. Not relevant for a striped aggregate.
RAID_SIZE_KB
NUMBER
RAID group size. Not relevant for a striped aggregate.
RAID_STATUS
STRING
RAID status.
RAID_TYPE
STRING
RAID type.
SNAPLOCK_TYPE
STRING
The type of the SnapLock aggregate. Possible values: compliance or enterprise.
SNAPSHOT_RESERVE_PCT
NUMBER
The percentage of aggregate disk space that has been set aside as reserve for snapshot usage. Default value is 0.
STRIPING_TYPE
STRING
Specifies the striping information about the aggregate. Possible values: not_striped, striped, and unknown.
VOLUME_FREE_CAPACITY_GB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_FREE_CAPACITY_KB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_GB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_KB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_USED_CAPACITY_GB
NUMBER
Sum of the used capacity of all the volumes.
VOLUME_USED_CAPACITY_KB
NUMBER
Sum of the used capacity of all the volumes.
VOL_USED_INCL_METADATA_GB
NUMBER
Space used by the sum of all data and metadata of all volumes in the aggregate. Range: [0..264-1].
VOL_USED_INCL_METADATA_KB
NUMBER
Space used by the sum of all data and metadata of all volumes in the aggregate. Range: [0..264-1].
aps_v_ntc_aggregate_log
The aps_v_ntc_aggregate_log view contains a single row for each NetApp Cluster Aggregate Log.
Table 4.271 aps_v_ntc_aggregate_log
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
AGGR_METADATA_USED_GB
NUMBER
This field represents space used by file system metadata of the aggregate. Range: [0..264-1]
AGGR_METADATA_USED_KB
NUMBER
This field represents space used by file system metadata of the aggregate. Range: [0..264-1]
AGGR_USED_INCL_SNAP_RESERVE_GB
NUMBER
Space used by the aggregate (bytes), including the aggregate's snapshot reserve.
AGGR_USED_INCL_SNAP_RESERVE_KB
NUMBER
Space used by the aggregate (bytes), including the aggregate's snapshot reserve.
ARRAY_NAME
STRING
Array name
FILE_SYSTEM_AVAILABLE_GB
NUMBER
Number of bytes still available in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_AVAILABLE_KB
NUMBER
Number of bytes still available in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_RESERVED_GB
NUMBER
The total disk space (in bytes) that is reserved on the file system.
FILE_SYSTEM_RESERVED_KB
NUMBER
The total disk space (in bytes) that is reserved on the file system.
FILE_SYSTEM_TOTAL_GB
NUMBER
Total size (in bytes) of the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_TOTAL_KB
NUMBER
Total size (in bytes) of the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_USED_GB
NUMBER
Number of bytes used in the file system. If the file system is restricted or offline, this value is 0.
FILE_SYSTEM_USED_KB
NUMBER
Number of bytes used in the file system. If the file system is restricted or offline, this value is 0.
HYBRID_AGGR_TOTAL_CACHE_GB
NUMBER
Total cache size (in bytes) for a hybrid aggregate.
HYBRID_AGGR_TOTAL_CACHE_KB
NUMBER
Total cache size (in bytes) for a hybrid aggregate.
INODE_USED_CAPACITY_PCT
NUMBER
The percentage of disk space in use, based on a file (inode) count on the file system.
LOG_DATE
DATE
The date and time the samples were collected.
MAX_CACHE_RAID_GROUP_GB
NUMBER
Maximum cache RAID group size of a hybrid aggregate. RAID group size is the maximum number of disks that can be added to a RAID group.
MAX_CACHE_RAID_GROUP_KB
NUMBER
Maximum cache RAID group size of a hybrid aggregate. RAID group size is the maximum number of disks that can be added to a RAID group.
NBR_OF_COLLECTIVE_FLEX_VOL
NUMBER
Number of striped volumes in the aggregate.
NBR_OF_DISKS
NUMBER
Number of disks in the aggregate.
NBR_OF_DP_SNAPMIRROR_DEST_VOL
NUMBER
When present, the number of data protection (dp) SnapMirror destination volumes.
NBR_OF_FLEX_VOL
NUMBER
Number of volumes in the aggregate.
NBR_OF_INODE_FOR_SYSTEM_FILE
NUMBER
Number of inodes that can be stored on disk for system files (not user-visible files). This number dynamically increases as additional system files are created.
NBR_OF_INODE_FOR_USER_FILE
NUMBER
Number of inodes that can be stored on disk for user-visible files. This number dynamically increases as additional user-visible files are created.
NBR_OF_LS_SNAPMIRROR_DEST_VOL
NUMBER
When present, this field indicates the number of load-sharing SnapMirror destination volumes.
NBR_OF_MV_SNAPMIRROR_DEST_VOL
NUMBER
When present, this field indicates the number of move SnapMirror destination volumes that are created for volume move operations.
NBR_OF_NOT_ONLINE_FLEX_VOL
NUMBER
When present, this field indicates the number of volumes that are not online (offline and restricted volumes).
NBR_OF_QUIESCED_FLEX_VOL
NUMBER
When present, this field indicates the number of quiesced online volumes.
NBR_OF_STRIPED_FLEX_VOL
NUMBER
Number of striped volumes in the aggregate. These volumes are also reported in the full volume count value.
NBR_OF_SYSTEM_FILE_USED
NUMBER
Number of system (not user-visible) files (inodes) used.
NBR_OF_THIN_VOLUMES
NUMBER
Number of thin volumes in the aggregate.
NBR_OF_USER_FILE_TOTAL
NUMBER
Maximum number of user-visible files (inodes) that the file system can hold.
NBR_OF_USER_FILE_USED
NUMBER
Number of user-visible files (inodes) used in the file system.
NBR_OF_VOLUMES
NUMBER
Number of volumes in the aggregate.
NODE_NAME
STRING
Node name
NTC_AGGREGATE_ID
NUMBER
Aggregate ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
List of node names.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
RAID_SIZE_GB
NUMBER
RAID group size. Not relevant for a striped aggregate.
RAID_SIZE_KB
NUMBER
RAID group size. Not relevant for a striped aggregate.
VOLUME_FREE_CAPACITY_GB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_FREE_CAPACITY_KB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_GB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_KB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_USED_CAPACITY_GB
NUMBER
Sum of the used capacity of all the volumes.
VOLUME_USED_CAPACITY_KB
NUMBER
Sum of the used capacity of all the volumes.
VOL_USED_INCL_METADATA_GB
NUMBER
Space used by the sum of all data and metadata of all volumes in the aggregate. Range: [0..264-1].
VOL_USED_INCL_METADATA_KB
NUMBER
Space used by the sum of all data and metadata of all volumes in the aggregate. Range: [0..264-1].
aps_v_ntc_aggregate_relocate
The aps_v_ntc_aggregate_relocate view contains a single row for each NetApp Cluster Aggregate Relocation Status.
Table 4.272 aps_v_ntc_aggregate_relocate
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster Aggregate Relocation data was created in the StorageConsole database.
DESTINATION_NODE
STRING
Destination for aggregate relocation.
DESTINATION_NODE_ID
NUMBER
Destination Node ID, for internal use by the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster aggregate relocation data was last updated in the StorageConsole database.
NTC_AGGREGATE_ID
NUMBER
Aggregate ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
RELOCATION_STATUS
STRING
Aggregate's relocation status attributes: non-creatable, non-modifiable.
SOURCE_NODE
STRING
Name of the source node in which the aggregate resides.
SOURCE_NODE_ID
NUMBER
Source Node ID, for internal use by the StorageConsole database.
aps_v_ntc_aggr_perform_log
The aps_v_ntc_aggr_perform_log view contains a single row for each NetApp Cluster Aggregate Performance.
Table 4.273 aps_v_ntc_aggr_perform_log
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode aggregate performance history data was collected.
INTERVAL_TYPE
STRING
Interval type of the processor performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NBR_OF_READS_HDD_PS
NUMBER
Number of reads per second done during a consistency point (CP) count check to the aggregate hard disk drive (HDD) disks.
NBR_OF_READS_PS
NUMBER
Number of reads per second done during a consistency point (CP) count check to the aggregate.
NBR_OF_READS_SSD_PS
NUMBER
Number of reads per second done during a consistency point (CP) count check to the aggregate solid state drive (SSD) disks.
NBR_OF_READ_BLKS_HDD_PS
NUMBER
Number of blocks read per second during a consistency point (CP) count check on the aggregate hard disk drive (HDD) disks.
NBR_OF_READ_BLKS_PS
NUMBER
Number of blocks read per second during a consistency point (CP) count check on the aggregate.
NBR_OF_READ_BLKS_SSD_PS
NUMBER
Number of blocks read per second during a consistency point (CP) count check on the aggregate solid state drive (SSD) disks.
NBR_OF_USER_READS_HDD_PS
NUMBER
Number of user reads per second to the aggregate hard disk drive (HDD) disks.
NBR_OF_USER_READS_PS
NUMBER
Number of user reads per second to the aggregate.
NBR_OF_USER_READS_SSD_PS
NUMBER
Number of user reads per second to the aggregate solid state drive (SSD) disks.
NBR_OF_USER_READ_BLKS_HDD_PS
NUMBER
Number of blocks read per second on the aggregate hard disk drive (HDD) disks.
NBR_OF_USER_READ_BLKS_PS
NUMBER
Number of blocks read per second on the aggregate.
NBR_OF_USER_READ_BLKS_SSD_PS
NUMBER
Number of blocks read per second on the aggregate solid state drive (SSD) disks.
NBR_OF_USER_WRITE_BLKS_HDD_PS
NUMBER
Number of blocks written per second to the aggregate hard disk drive (HDD) disks.
NBR_OF_USER_WRITE_BLKS_PS
NUMBER
Number of blocks written per second to the aggregate.
NBR_OF_USER_WRITE_BLKS_SSD_PS
NUMBER
Number of blocks written per second to the aggregate solid state drive (SSD) disks.
NBR_OF_USER_WRITE_HDD_PS
NUMBER
Number of user writes per second to the aggregate hard disk drive (HDD) disks.
NBR_OF_USER_WRITE_PS
NUMBER
Number of user writes per second to the aggregate.
NBR_OF_USER_WRITE_SSD_PS
NUMBER
Number of user writes per second to the aggregate solid state drive (SSD) disks.
NODE_NAME
STRING
Node name
NTC_AGGREGATE_ID
NUMBER
Name of the aggregate.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
TOTAL_TRANSFERS_HDD_PS
NUMBER
Total number of transfers per second serviced by the aggregate hard disk drive (HDD) disks.
TOTAL_TRANSFERS_PS
NUMBER
Total number of transfers per second serviced by the aggregate.
TOTAL_TRANSFERS_SSD_PS
NUMBER
Total number of transfers per second serviced by the aggregate solid state drive (SSD) disks.
aps_v_ntc_cache_policy
The aps_v_ntc_cache_policy view contains a single row for each NetApp Cluster Cache Policy.
Table 4.274 aps_v_ntc_cache_policy
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CACHE_POLICY_NAME
STRING
Cache policy name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode cache policy data was created in the StorageConsole database.
DELEG_LRU_TIMEOUT_SEC
NUMBER
Time out for the delegations least recently used (LRU) represents the time in seconds since the last use of the delegation, after which a cache considers it unused and returns it to the origin.
IS_PREFER_LOCAL_CACHE
STRING
If set to true, data is served from the local cache, otherwise from the local origin.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode cache policy data was last updated in the StorageConsole database.
NTC_CACHE_POLICY_ID
NUMBER
Cache policy ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
The name of the managing Vserver. Maximum length is 255 characters.
TIME_TO_LIVE_DIRECTORIES_SEC
NUMBER
Time To Live (TTL) for directories represents the time, in seconds, that a directory's attributes and data are served from the cache volume before they are verified with the origin volume.
TIME_TO_LIVE_FILES_SEC
NUMBER
The Time To Live (TTL) for files represents the time, in seconds, that a file's attributes and data are served from the cache volume before they are verified with the origin volume.
TIME_TO_LIVE_METAFILES_SEC
NUMBER
Represents the time, in seconds, that metafile attributes and data are served from the cache volume before they are verified with the origin volume.
TIME_TO_LIVE_OTHER_SEC
NUMBER
Relevant for any file that is not in other Time To Live (TTL) categories.
TIME_TO_LIVE_SYMBOLIC_SEC
NUMBER
Represents the time, in seconds, that symbolic link attributes and data are served from the cache volume before they are verified with the origin volume.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_cifs_perform_log
The aps_v_ntc_cifs_perform_log view contains a single row for each NetApp Cluster CIFS Performance Log.
Table 4.275 aps_v_ntc_cifs_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_CIFS_LATENCY_MS
NUMBER
Average latency for CIFS operations.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode CIFS performance history data was collected.
INTERVAL_TYPE
STRING
Interval type of the CIFS performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NBR_OF_ACTIVE_SEARCHES
NUMBER
Number of active searches over SMB and SMB2.
NBR_OF_AUTH_REJECTED
NUMBER
Authentication refused after too many requests were made in rapid succession.
NBR_OF_CIFS_CMDS_OUTSTANDING
NUMBER
Number of SMB and SMB2 commands in process.
NBR_OF_CIFS_CONNECT_ESTD
NUMBER
Number of established SMB and SMB2 sessions.
NBR_OF_CIFS_CONNECT_SHARES
NUMBER
Number of SMB and SMB2 share connections.
NBR_OF_CIFS_CONNECT_TOTAL
NUMBER
Number of connections.
NBR_OF_CIFS_READ_OPS
NUMBER
Total number of CIFS read operations.
NBR_OF_CIFS_TOTAL_OPS
NUMBER
Total number of CIFS operations.
NBR_OF_CIFS_WRITE_OPS
NUMBER
Total number of CIFS write operations.
NBR_OF_OPEN_FILES
NUMBER
Number of open files over SMB and SMB2.
NBR_OF_OUT_CHANGE_NOTIFICATION
NUMBER
Number of active change notifications over SMB and SMB2.
NBR_OF_SIGNED_SESSIONS
NUMBER
Number of signed SMB and SMB2 session.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
TOTAL_CIFS_LATENCY_OPERATIONS
NUMBER
Total observed CIFS operations to be used as a base counter for a CIFS average latency calculation.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_cifs_server
The aps_v_ntc_cifs_server view contains a single row for each NetApp Cluster CIFS Server.
Table 4.276 aps_v_ntc_cifs_server
Column Name
Data Type
Description
ADMIN_STATUS
STRING
CIFS Server Administrative Status.
ARRAY_NAME
STRING
Array name
AUTH_STYLE
STRING
The authentication style to be used for CIFS clients connecting to the CIFS server. Possible values: domain, workgroup.
CIFS_SERVER_NAME
STRING
CIFS server name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode CIFS Server data was created in the StorageConsole database.
DEFAULT_SITE
STRING
The default site used by logical interfaces (LIF) that do not have a site membership.
DOMAIN_NAME
STRING
Fully qualified domain name (FQDN) of the Windows Active Directory to which this CIFS server belongs.
DOMAIN_WORKGROUP
STRING
The NetBIOS name of the domain or workgroup to which this CIFS server belongs.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode CIFS server data was last updated in the StorageConsole database.
NTC_CIFS_SERVER_ID
NUMBER
CIFS server ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver containing the CIFS server.
ORGANIZATIONAL_UNIT
STRING
The Organizational Unit (OU) within the Windows Active Directory to which this CIFS server belongs.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_cifs_session
The aps_v_ntc_cifs_session view contains a single row for each NetApp Cluster CIFS Session.
Table 4.277 aps_v_ntc_cifs_session
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AUTH_MECHANISM
STRING
The authentication mechanism used to establish the session.
CONNECTED_TIME
STRING
The time duration since the session was established.
CONNECTION_ID
NUMBER
The connection that is used to establish the session.
CONTINUOUSLY_AVAILABLE
STRING
The type of continuous available protection provided to the session.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode CIFS Session data was created in the StorageConsole database.
ELASPED_TIME
STRING
The time duration since the session was established.
IDLE_TIME
STRING
The time duration since there was last activity on the session.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode CIFS session data was last updated in the StorageConsole database.
LIF_ADDRESS
STRING
The data logical interface (LIF) that is used to establish the session.
NBR_OF_FILES
NUMBER
The number of the regular files that are opened under the session.
NBR_OF_SHARES
NUMBER
The number of the CIFS shares that are opened under the session.
NBR_OF_SPEICAL_FILES
NUMBER
The number of the special files that are opened under the session.
NODE_NAME
STRING
Node name
NTC_CIFS_SESSION_ID
NUMBER
CIFS session ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
Name of the node on which the session listing is done.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver name on which the session listing is done.
PROTOCOL_VERSION
STRING
CIFS protocol version that is used to establish the session.
SESSION_ID
STRING
Unique identifier for the session.
UNIX_USER_NAME
STRING
Name of the UNIX user for which the session is established.
VSERVER_NAME
STRING
Vserver name
WINDOWS_USER_NAME
STRING
Name of the CIFS user for which the session is established.
WORKSTATION_IP_ADDRESS
STRING
IP address of the workstation from which the session is opened.
aps_v_ntc_cifs_share
The aps_v_ntc_cifs_share view contains a single row for each NetApp Cluster CIFS Share.
Table 4.278 aps_v_ntc_cifs_share
Column Name
Data Type
Description
ACL
STRING
Access Control List (ACL) for the CIFS share. Each list entry is a slash-separated (/) pair of the user or group name and the permissions.
ARRAY_NAME
STRING
Array name
ATTRIBUTE_CACHE_LIFETIME_SEC
NUMBER
The lifetime of an entry in the file attribute cache, in seconds.
CIFS_SERVER_NAME
STRING
CIFS server name
CIFS_SHARE_COMMENT
STRING
Description of the CIFS share. CIFS clients see this description when browsing the Vserver's CIFS shares.
CIFS_SHARE_NAME
STRING
The CIFS share name is a UTF-8 string.
CIFS_SHARE_PROPERTIES
STRING
The list of properties for the CIFS share.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode CIFS share data was created in the StorageConsole database.
DIR_UMASK
NUMBER
The value of this field controls the file mode creation mask for the CIFS share in Qtrees with UNIX or Mixed security styles.
FILE_SYSTEM_PATH
STRING
File system path that is shared through this CIFS share. This is the full, user-visible path relative to the Vserver root, and it may cross junction mount points.
FILE_UMASK
NUMBER
The value of this field controls the file mode creation mask for the CIFS share in Qtrees with UNIX or Mixed security styles.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode CIFS share data was last updated in the StorageConsole database.
NTC_CIFS_SERVER_ID
NUMBER
NetBIOS name of the CIFS server that owns this share.
NTC_CIFS_SHARE_ID
NUMBER
CIFS share ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume where the root of the CIFS share resides.
NTC_VSERVER_ID
NUMBER
Name of the Vserver.
OFFLINE_FILES_MODE
STRING
Mode of the offline file for the CIFS share. The default value is manual.
SYMLINKS_PROPERTIES
STRING
This flag controls the accessibility of the symlinks under the shared directory.
VOLUME_NAME
STRING
Volume name
VSCAN_FILE_OP_PROFILE
STRING
Set of file-ops to which Vscan On-Access scanning is applicable. The default value is standard.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_cluster_peer
The aps_v_ntc_cluster_peer view contains a single row for each NetApp Cluster Peer.
Table 4.279 aps_v_ntc_cluster_peer
Column Name
Data Type
Description
ACTIVE_ADDRESSES
STRING
Active IP addresses of the peer cluster.
ARRAY_NAME
STRING
Array name
CONNECTION_STATUS
STRING
Status of the peer cluster connection.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode peer data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode peer data was last updated in the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PEER_ADDRESSES
STRING
IPv4 address or host name.
REMOTE_CLUSTER_NAME
STRING
The current name of the peer cluster.
SERIAL_NBR
STRING
Serial number of the peer cluster, assigned at cluster creation.
TIMEOUT_SEC
NUMBER
Timeout for operations in the peer cluster in seconds.
aps_v_ntc_disk
The aps_v_ntc_disk view contains a single row for each NetApp Cluster Disk.
Table 4.280 aps_v_ntc_disk
Column Name
Data Type
Description
ACTIVE_NODE_ID
NUMBER
Name of the node that is the active RAID controller for this disk, if any. Omitted if unavailable or excluded by desired-attrributes.
ACTIVE_NODE_NAME
STRING
Active node name
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
CARRIER_ID
STRING
Unique identifier of the disk carrier.
CARRIER_SERIAL_NBR
STRING
Unique serial number of the disk carrier.
CHECKSUM_TYPE
STRING
The checksum type that has been assigned to this disk.
CONTAINER_TYPE
STRING
Type of overlying disk container.
COPY_DESTINATION_NAME
STRING
Name of copy destination.
CREATION_DATE
DATE
The date and time the NetApp disk data was created in the StorageConsole database.
DISK_COPY_COMPLETE_PCT
NUMBER
Disk copy completion percentage.
DISK_RECONSTRUCT_COMPLETE_PCT
NUMBER
Disk reconstruction completion percentage.
DISK_ZEROING_COMPLETE_PCT
NUMBER
Disk zeroing completion percentage.
DR_HOME_NODE_ID
NUMBER
For Disaster Recovery (DR), this is the name of the home owner of a disk in switchover state when a serious event has occurred.
DR_HOME_NODE_NAME
STRING
Dr home node name
EFFECTIVE_DISK_TYPE
STRING
Effective disk interface type. Disks can report a different physical disk type, but the same effective disk type.
EFFECTIVE_RPM
NUMBER
Effective rotational speed in revolutions per minute. Disks can report different actual RPM, but have the same effective RPM.
HOME_NODE_ID
NUMBER
Name of the home node to which this disk is assigned.
HOME_NODE_NAME
STRING
Home node name
IS_DISK_FAILED
STRING
Indicates if a disk failed or the system marked it for rapid RAID recovery.
IS_DYNAMICALLY_QUALIFIED
STRING
Indicates if the drive was dynamically qualified.
IS_FAILED
STRING
Indicates that a disk has failed and its ownership cannot be determined.
IS_FOREIGN
STRING
Indicates if an array LUN has been designated as a foreign LUN and cannot be assigned.
IS_IN_FDR
STRING
Indicates if the disk has an entry in the failed disk registry.
IS_MEDIA_SCRUBBING
STRING
Indicates if media scrub is currently active for the disk.
IS_MULTI_DISK_CARRIER
STRING
Indicates if the disk is in a carrier that contains more than one disk.
IS_OFFLINE
STRING
Indicates if the disk is offline.
IS_RECONSTRUCTING
STRING
Indicates if the disk is being reconstructed.
IS_REPLACING
STRING
Indicates if the disk is being replaced with a specified replacement disk.
IS_SPARECORE
STRING
Indicates if the disk is a sparecore disk.
IS_ZEROED
STRING
Indicates if the disk is in a pre-zeroed state.
IS_ZEROING
STRING
Only true if the disk position is pending and the disk is being zeroed.
LAST_UPDATED
DATE
The date and time the NetApp disk data was last updated in the StorageConsole database.
MEDIA_SCRUB_LAST_DONE_SEC
NUMBER
Number of seconds since a media scrub last completed.
NBR_OF_BLOCKS
NUMBER
RAID recorded disk capacity expressed in units of 4096-byte blocks.
NBR_OF_BYTES_PER_SECTOR
NUMBER
Number of bytes per disk sector.
NBR_OF_ENTRY_GROWN_DEFECT_LIST
NUMBER
Number of entries in the drive's grown defect list.
NBR_OF_MEDIA_SCRUBBED
NUMBER
Number of times the media has been scrubbed since the controller last powered on.
NBR_OF_RIGHT_SIZE_SECTORS
NUMBER
Number of usable disk sectors that remain after subtracting the right-size adjustment for this disk.
NBR_OF_SECTORS
NUMBER
Total number of disk sectors on the disk.
NBR_OF_USED_BLOCKS
NUMBER
RAID-recorded size of the file system area on the disk.
NODE_NAME
STRING
Node name
NTC_AGGREGATE_ID
NUMBER
Name of the aggregate or traditional volume with which the disk is associated.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_PLEX_ID
NUMBER
Name of the plex with which the disk is associated.
NTC_RAID_GROUP_ID
NUMBER
Name of RAID group to which this disk belongs.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
OWNER_NODE_ID
NUMBER
Name of the node that currently owns this disk.
OWNER_NODE_NAME
STRING
Owner node name
PDEV_ID
NUMBER
PDEV ID, for internal use by the StorageConsole database.
PDEV_NAME
STRING
Pdev name
PLEX_NAME
STRING
Plex name
POOL
NUMBER
Pool to which the disk is assigned.
POSITION
STRING
Position of the disk, relative to its container type.
RAID_GROUP_NAME
STRING
Raid group name
RATED_LIFE_USED_PCT
NUMBER
Estimate of the percentage of device life that has been used, based on the actual device usage and the manufacturer's prediction of device life.
REASON
STRING
Reason the disk is not in service.
RESERVED_BY_NODE_NVRAM_ID
NUMBER
Reserved Node NVRAM ID, for internal use by the StorageConsole database.
SHELF
STRING
Disk shelf, if it can be determined.
SHELF_BAY
STRING
Disk shelf bay, if it can be determined.
SPARES_CONSUMED_PCT
NUMBER
Percentage of device spare blocks that have been used. Each device has a number of spare blocks that will be used when a data block can no longer be used to store data.
SPARES_CONSUMED_PCT_LIMIT
NUMBER
Spares consumed percentage limit reported by the device.
SPARE_POOL_NAME
STRING
Name of RAID-managed spare pool with which the disk is associated.
STORAGE_HEALTH_MONITOR_SEC
NUMBER
Number of seconds errors have been tracked by the storage health monitor (SHM).
SUPPORT_CHECKSUM_TYPES
STRING
Checksum types that this disk is capable of supporting.
aps_v_ntc_disk_path
The aps_v_ntc_disk_path view contains a single row for each NetApp Cluster Disk Path.
Table 4.281 aps_v_ntc_disk_path
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode disk path data was created in the StorageConsole database.
DISK_ARRAY_NAME
STRING
Disk array name
DISK_PORT
STRING
Disk port associated with this path.
DISK_PORT_NAME
STRING
Disk port name associated with this path. .
INITIATOR_IO_KBPS
NUMBER
Rolling average of kilobytes per second, read and written over this initiator port. Range: [0..264-1]
INITIATOR_IO_OPS
NUMBER
Rolling average of I/O operations per second, read and written over this initiator port. Range: [0..264-1]
INITIATOR_LUN_IN_USE_CNT
NUMBER
Number of LUNs in the in-use state on this initiator. Range: [0..264-1]
INITIATOR_PORT_NAME
STRING
Initiator port name, for example: 0a.
INITIATOR_PORT_SPEED
STRING
The speed that the initiator port has negotiated with its connected switch, or target port if direct-attached.
INITIATOR_SWITCH_PORT_NAME
STRING
The name of the switch connected to the controller's initiator port, or N/A when using direct attach.
IS_PREFERRED_TARGET_PORT_ROUTE
STRING
For a logical unit that reports asymmetric access, this indicates that a path, regardless of the current access state, routes to a preferred target port group.
LAST_UPDATED
DATE
The date and time the NetApp Disk Path data was last updated in the StorageConsole database.
LUN_IO_KBPS
NUMBER
Rolling average of kilobytes per second read and written to this LUN. Range: [0..264-1]
LUN_IO_OPS
NUMBER
Rolling average of I/O operations per second read and written to this LUN. Range: [0..264-1]
LUN_NBR
NUMBER
Logical unit number. Range: [0..65535]
LUN_PATH_USE_STATE
STRING
Currently supported ONTAP state is INU - In Use.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
Controller with the initiator port for this path.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PATH_IO_KBPS
NUMBER
Rolling average of kilobytes per second, read and written to this path. Range: [0..264-1]
PATH_IO_OPS
NUMBER
Rolling average of I/O operations per second, read and written to this path. Range: [0..264-1]
PATH_LINK_ERRORS
NUMBER
Number of link errors reported on the path. Range: [0..232-1]
PATH_LUN_IN_USE_CNT
NUMBER
Number of LUNs in the in-use state on this path. Range: [0..264-1]
PATH_QUALITY_PCT
NUMBER
The percentage of the error threshold.
PDEV_ID
NUMBER
The name of the disk associated with this path.
PDEV_NAME
STRING
Pdev name
TARGET_IO_KBPS
NUMBER
Rolling average of kilobytes per second, read and written to this target port. Range: [0..264-1]
TARGET_IO_OPS
NUMBER
Rolling average of I/O operations per second, read and written to this target port. Range: [0..264-1]
TARGET_LUN_IN_USE_CNT
NUMBER
Number of LUNs in the in-use state on this target port. Range: [0..264-1]
TARGET_PORT_ACCESS_STATE
STRING
Failover optimization type.
TARGET_PORT_GROUP_NBR
NUMBER
Target port group number of the array's target port. Range: [0..264-1]
TARGET_PORT_WWN
STRING
Target port wwn
TARGET_PORT_WWN_ID
NUMBER
ID of the world wide port name for the array's target port.
TARGET_SWITCH_PORT_NAME
STRING
Name of the switch port connected to the target array, or UNKNOWN if direct-attached.
TARGET_WWPN
STRING
World Wide Port Name of target port providing the disk.
aps_v_ntc_disk_path_mapping
The aps_v_ntc_disk_path_path_mapping view contains a single row for each NetApp Cluster-Mode Disk Path Mapping.
Table 4.282 aps_v_ntc_disk_path_mapping
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
backend_array_port_id
NUMBER
Foreign key to backend array port details.
backend_array_port_wwn_name
STRING
World Wide Port Name of backend array port.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode disk path mapping data was created in the StorageConsole database.
fc_port_wwn_id
NUMBER
ID of the world wide port name for the array’s FC port.
fc_port_wwn_name
STRING
World Wide Port Name of FC port.
LAST_UPDATED
DATE
The date and time the NetApp Disk Path mapping data was last updated in the StorageConsole database.
lun_nbr
NUMBER
Logical unit number. Range: [0..65535]
ntc_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
pdev_id
NUMBER
The name of the disk associated with this path.
pdev_name
STRING
Pdev name.
aps_v_ntc_disk_perform_log
The aps_v_ntc_disk_perform_log view contains a single row for each NetApp Cluster Disk Performance Log.
Table 4.283 aps_v_ntc_disk_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
BLKS_SKIPPED_OPS
NUMBER
Number of blocks skipped in skip-mask write operations per second.
CP_READ_BLKS_AVG
NUMBER
Average number of blocks transferred in each consistency point (CP) read operation during a CP check.
CP_READ_BLKS_PS
NUMBER
Number of blocks transferred for consistency point read operations per second.
CP_READ_LATENCY_MS
NUMBER
Average latency per block in microseconds for consistency point read operations.
CP_READ_PS
NUMBER
Number of disk read operations initiated each second for consistency point processing.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode disk performance history data was collected.
DISK_BUSY_PCT
NUMBER
Percentage of time there was at least one outstanding request to the disk.
DISK_BUSY_SEC
NUMBER
Time base for the disk-busy calculation.
DISK_CAPACITY_GB
NUMBER
Disk capacity. Values are stored as KiB in the database and rendered according to your user profile preferences.
DISK_CAPACITY_KB
NUMBER
Disk capacity. Values are stored as KiB in the database and rendered according to your user profile preferences.
GUAR_READ_BLKS_AVG
NUMBER
Average number of blocks transferred in each guaranteed read operation.
GUAR_READ_BLKS_PS
NUMBER
Number of blocks transferred for guaranteed read operations per second.
GUAR_READ_LATENCY_MS
NUMBER
Average latency per block in microseconds for guaranteed read operations.
GUAR_READ_PS
NUMBER
Number of disk read operations initiated each second for RAID reconstruct or scrubbing activities.
GUAR_WRITE_BLKS_AVG
NUMBER
Average number of blocks transferred in each guaranteed write operation.
GUAR_WRITE_BLKS_PS
NUMBER
Number of blocks transferred for guaranteed write operations per second.
GUAR_WRITE_LATENCY_MS
NUMBER
Average latency per block in microseconds for guaranteed write operations.
GUAR_WRITE_PS
NUMBER
Number of write read operations initiated each second for RAID reconstruct or scrubbing activities.
INTERVAL_TYPE
STRING
Interval type of the disk performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NBR_OF_DISK_IO_PS
NUMBER
Total number of disk operations per second involving initiated data transfer.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PDEV_ID
NUMBER
On Data ONTAP cluster-mode systems, this is the display name of the disk. On Data ONTAP 7-mode systems, this is the universally unique identifier (UUID) of the disk.
PDEV_NAME
STRING
Pdev name
USER_READ_BLKS_AVG
NUMBER
Average number of blocks transferred in each user read operation.
USER_READ_BLKS_PS
NUMBER
Number of blocks transferred per second for user read operations.
USER_READ_LATENCY_MS
NUMBER
Average latency per block in microseconds for user read operations.
USER_READ_PS
NUMBER
Number of disk read operations initiated each second for retrieving data or metadata associated with user requests.
USER_SKIP_MASK_WRITE_PS
NUMBER
Number of disk write IOs that were executed as part of a skip-mask write.
USER_SKIP_WRITES_PS
NUMBER
Number of disk skip-write operations initiated each second for storing data or metadata associated with user requests.
USER_WRITE_BLKS_AVG
NUMBER
Average number of blocks transferred in each user write operation.
USER_WRITE_BLKS_PS
NUMBER
Number of blocks transferred per second for user write operations.
USER_WRITE_LATENCY_MS
NUMBER
Average latency per block in microseconds for user write operations.
USER_WRITE_PS
NUMBER
Number of disk write operations initiated each second for storing data or metadata associated with user requests.
aps_v_ntc_export_policy
The aps_v_ntc_export_policy view contains a single row for each NetApp Cluster Export Policy.
Table 4.284 aps_v_ntc_export_policy
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode export policy data was created in the StorageConsole database.
EXPORT_POLICY_NAME
STRING
Export policy name
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode export policy data was last updated in the StorageConsole database.
NTC_EXPORT_POLICY_ID
NUMBER
Export policy ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver name.
POLICY_ID
NUMBER
Export policy ID.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_export_rule
The aps_v_ntc_export_rule view contains a single row for each NetApp Cluster Export Rule.
Table 4.285 aps_v_ntc_export_rule
Column Name
Data Type
Description
ANONYMOUS_USER_ID
STRING
User name or ID to which anonymous users are mapped. Default value is 65534.
ARRAY_NAME
STRING
Array name
CLIENT_MATCH
STRING
The clients specified are enforced with this export rule.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode export rule data was created in the StorageConsole database.
EXPORT_CHOWN_MODE
STRING
Change ownership mode.
EXPORT_NTFS_UNIX_SECURITY_OPS
STRING
Ignore/Fail Unix security operations on NTFS (new technology file system) volumes.
EXPORT_POLICY_NAME
STRING
Export policy name
IS_ALLOW_DEVICE_ENABLED
STRING
Indicates if the NFS server will allow creation of devices.
IS_ALLOW_SET_UID_ENABLED
STRING
Indicates if the NFS server will honor SetUID bits in the SETATTR operation.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode export rule was last updated in the StorageConsole database.
NTC_EXPORT_POLICY_ID
NUMBER
Export policy name.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver name for the export rule.
PROTOCOL
STRING
Client access protocol.
RO_RULE
STRING
Rule for read-only access.
RULE_INDEX
NUMBER
Export rule index.
RW_RULE
STRING
Rule for read-write access.
SUPER_USER_SECURITY
STRING
Security properties for the super user.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_extn_array_err
The aps_v_ntc_extn_array_err view contains a single row for each NetApp Cluster External Array Errors.
Table 4.286 aps_v_ntc_extn_array_err
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
ARRAY_PROFILE_NAME
STRING
Array profile Name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode external array error data was created in the StorageConsole database.
ERROR_ID
NUMBER
A unique ID for each error returned. ID is unique on a per API call basis only.
ERROR_TEXT
STRING
A description of the error being reported.
ERROR_TYPE
STRING
Enum describing type of error.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode external array error data was last updated in the StorageConsole database.
NTC_EXTN_ARRAY_PROFILE_ID
NUMBER
ID of the external array name in the array record.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
aps_v_ntc_extn_array_port
The aps_v_ntc_extn_array_port view contains a single row for each NetApp Cluster External Array Ports.
Table 4.287 aps_v_ntc_extn_array_port
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
ARRAY_PROFILE_NAME
STRING
Array profile Name
CONNECTION_TYPE
STRING
Type of connection between the controller and the back-end storage.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode external array port statistics data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode external array port statistics data was last updated in the StorageConsole database.
MAX_QUEUE_DEPTH
NUMBER
Target port queue depth for this target port.
NTC_EXTN_ARRAY_PROFILE_ID
NUMBER
ID of the external array name in the array record.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
SWITCH_PORT
STRING
For fabric-attached connections, the switch port to which the array target port is connected. N/A for a direct-attached connection.
TARGET_NODE_WWN_ID
NUMBER
ID of the world wide node name for the array's target port.
TARGET_NODE_WWN_NAME
STRING
Target node WWN name
TARGET_PORT_SPEED
STRING
Speed that the target port has negotiated with its connected switch port or initiator port, if direct-attached.
TARGET_PORT_WWN_ID
NUMBER
ID of the world wide port name for the array's target port.
TARGET_PORT_WWN_NAME
STRING
Target port wwn name
aps_v_ntc_extn_array_port_cn
The aps_v_ntc_extn_array_port_cn view contains a single row for each NetApp Cluster External Array Port Config.
Table 4.288 aps_v_ntc_extn_array_port_cn
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode external array port Connectivity data was created in the StorageConsole database.
DEVICE_TYPE
STRING
Type of LUN device. Describes the type of LUN device or tape library.
EXTN_ARRAY_PROFILE_NAME
STRING
External array profile name
GROUP_NBR
NUMBER
A unique number associated with a set of array LUNs that share the exact same pathing/connectivity information.
INITIATOR_PORT
STRING
Initiator port name.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode external array port Connectivity data was last updated in the StorageConsole database.
NBR_OF_LUNS
NUMBER
The number of array LUNs assigned to this group.
NTC_EXTN_ARRAY_PROFILE_ID
NUMBER
ID of the external array name in the array record.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
SWITCH_PORT_TO_HBA
STRING
Name of the switch port connected to the HBA (controller's initiator port), or UNKNOWN if direct-attached.
SWITCH_PORT_TO_TARGET_ARRAY
STRING
Name of the switch port connected to target array, or UNKNOWN if direct attached.
TARGET_PORT_WWN_ID
NUMBER
ID of the world wide port name for the array's target port.
TARGET_PROT_WWN_NAME
STRING
Target port WWN name
aps_v_ntc_extn_array_port_st
The aps_v_ntc_extn_array_port_st view contains a single row for each NetApp Cluster External Array Port Statistics.
Table 4.289 aps_v_ntc_extn_array_port_st
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_LATENCY_MS
NUMBER
The average latency for I/O operations performed by this controller on this target port.
AVG_PENDING
NUMBER
An average over time of how many commands are in the outstanding queue.
AVG_WAITING
NUMBER
An average over time of how many commands are in the waiting queue.
BUSY_PCT
NUMBER
The percentage of time I/Os are outstanding on the port.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode external array port data was created in the StorageConsole database.
EXTN_ARRAY_PROFILE_NAME
STRING
External array profile name
INITIATOR_PORT_NAME
STRING
Initiator port name, for example, 0a.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode external array port data was last updated in the StorageConsole database.
MAX_PENDING
NUMBER
The largest number of commands observed in the outstanding queue.
MAX_WAITING
NUMBER
The largest number of commands observed in the waiting queue.
NBR_OF_LUN_IN_USE
NUMBER
Number of disks in the IN-USE state on this target port.
NODE_NAME
STRING
Node name
NTC_EXTN_ARRAY_PROFILE_ID
NUMBER
ID of the external array name in the array record.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PATH_LINK_ERRORS
NUMBER
Number of link errors reported on the path.
TARGET_PORT_WWN_ID
NUMBER
ID of the world wide port name for the array's target port.
TARGET_PROT_WWN_NAME
STRING
Target port WWN name
TOTAL_IO_KBPS
NUMBER
Rolling average of kilobits per second read and written to this target port.
TOTAL_IO_OPS
NUMBER
Rolling average of I/O operations per second read and written to this target port.
WAITING_PCT
NUMBER
The percentage of time there are I/Os waiting on the waiting queue on the target port.
aps_v_ntc_extn_array_profile
The aps_v_ntc_extn_array_profile view contains a single row for each NetApp Cluster External Array Profile.
Table 4.290 aps_v_ntc_extn_array_profile
Column Name
Data Type
Description
AFFINITY
STRING
Describes the affinity model supported by the array.
ARRAY_ID
NUMBER
Primary key (system defined) for the array record.
ARRAY_MODEL
STRING
The model name of the array.
ARRAY_NAME
STRING
Array name
ARRAY_PROFILE_NAME
STRING
Array profile Name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode external array profile data was created in the StorageConsole database.
FIRMWARE_REVISION
STRING
The firmware revision of the array.
IP_ADDRESS
STRING
IP address/node name of the array's SNMP management port.
IS_UPGRADE_PENDING
STRING
The is-upgrade-pending status for the array.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode external array profile data was last updated in the StorageConsole database.
LUN_QUEUE_DEPTH
NUMBER
The default queue depths assigned to array LUNs from this array.
MAX_QUEUE_DEPTH
NUMBER
The target port queue depth for all target ports on this array.
NTC_EXTN_ARRAY_PROFILE_ID
NUMBER
ID of the external array name in the array record.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
OPTIMIZATION_POLICY
STRING
Describes the I/O optimization policy used by this array.
OPTIONS
STRING
A comma-separated list of name-value pairs of array-specific settings.
PORT_FAILOVER_TYPE
STRING
The pathing failover supported by the array, either ACTIVE-ACTIVE or ACTIVE-PASSIVE.
PREFIX
STRING
A unique user-supplied 5-character code used to refer to this array and used in naming the array's LUNs.
SERIAL_NBR
STRING
The serial number of the array.
VENDOR_NAME
STRING
The name of the array's vendor.
aps_v_ntc_fc_adapter
The aps_v_ntc_fc_adapter view contains a single row for each NetApp Cluster FC Adapter.
Table 4.291 aps_v_ntc_fc_adapter
Column Name
Data Type
Description
ADAPTER_NAME
STRING
The slot name of the fibre channel (FC) adapter.
ARRAY_NAME
STRING
Array name
CACHE_LINE_SIZE
NUMBER
Cache line size of adapter. verbose only.
CONNECTION_ESTABLISHED
STRING
Type of connection established: ptp or loop.
CREATION_DATE
DATE
The date and time the NetApp Cluster adapter data was created in the StorageConsole database.
DATA_LINK_RATE_GBIT
NUMBER
Data link rate in Gbits/sec.
FABRIC_NAME
STRING
The name of the fibre channel (FC) fabric to which this adapter is connected. Only returned if the adapter is logged in to the fabric.
FC_ADAPTER_STATE
STRING
Status of the adapter.
FIRMWARE_REVISION
STRING
Firmware revision of the fibre channel (FC) adapter.
FLASH_PRELOAD_REVISION
STRING
Flash preload revision for fibre channel (FC) adapter.
HARDWARE_REVISION
STRING
Hardware revision of the fibre channel (FC) adapter.
INFO_NAME
STRING
Informational name given to the adapter.
IS_EXTERNAL_GBIC_ENABLED
STRING
true = gigabit interface converter (GBIC) enabled.
IS_FABRIC_ESTABLISHED
STRING
true = fabric is established to this adapter.
IS_SRAM_PARITY_ENABLED
STRING
true = Static random-access memory (SRAM) parity is enabled.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode adapter data was last updated in the StorageConsole database.
MAX_SPEED_GBPS
NUMBER
The maximum speed of the adapter, in Gbits/sec.
MEDIA_TYPE
STRING
Media configured for this adapter: ptp, loop, or auto.
MPI_FIRMWARE_REVISION
STRING
Message passing interface (MPI) firmware revision for the adapter.
NODE_NAME
STRING
Node name
NODE_WWN_ID
NUMBER
Fibre channel protocol (FCP) World Wide Node Name (WWNN) of the adapter.
NODE_WWN_NAME
STRING
Node wwn name
NTC_FC_ADAPTER_ID
NUMBER
Adapter ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
The name of the node where the adapter is installed.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PACKET_SIZE
NUMBER
Fibre channel (FC) packet size of adapter.
PCI_BUS_WIDTH_BIT
NUMBER
Peripheral component interconnect (PCI) bus width in bits.
PCI_CLOCK_SPEED_MHZ
NUMBER
Peripheral component interconnect (PCI) clock speed in MHz..
PHYSICAL_DATA_LINK_RATE_GBIT
NUMBER
Physical Data Link Rate in Gbits/sec.
PHYSICAL_FIRMWARE_REVISION
STRING
Physical (PHY) firmware revision of adapter.
PHYSICAL_LINK_STATE
STRING
Physical Status of the adapter.
PHYSICAL_PROTOCOL
STRING
The physical protocol of the adapter.
PORT_ADDRESS
NUMBER
Host port address of adapter.
PORT_NAME
STRING
Port name
SPEED
STRING
Speed configured for this adapter.
SWITCH_PORT
STRING
Switch and port to which this adapter is connected.
VLAN_ID
NUMBER
Assigned fibre channel (FC) virtual LAN ID.
aps_v_ntc_fc_alias
The aps_v_ntc_fc_alias view contains a single row for each NetApp Cluster FC Alias.
Table 4.292 aps_v_ntc_fc_alias
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode Vserver data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode volume move data was last updated in the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver containing the alias.
PORT_ALIAS_NAME
STRING
The 32-character alias for a given fibre channel protocol (FCP) world wide port name (WWPN).
PORT_WWN_ID
NUMBER
The fibre channel protocol (FCP) world wide port name (WWPN) for which the alias is given.
PORT_WWN_NAME
STRING
Port WWN name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_fc_interface
The aps_v_ntc_fc_interface view contains a single row for each NetApp Cluster FC interface.
Table 4.293 aps_v_ntc_fc_interface
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
ARRAY_PORT_ID
NUMBER
Name of the port.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode interface data was created in the StorageConsole database.
CURRENT_PORT
STRING
Fibre channel (FC) adapter currently hosting the logical interface (LIF) .
INTERFACE_NAME
STRING
Interface name
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode interface data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
NODE_WWN_ID
NUMBER
World Wide Node Name (WWNN) of the logical interface (LIF) .
NODE_WWN_NAME
STRING
Node wwn name
NTC_NET_INTERFACE_ID
NUMBER
Name of the logical interface (LIF) .
NTC_NODE_ID
NUMBER
Node currently hosting the logical interface (LIF) .
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver hosting the logical interface (LIF) .
PORT_ADDRESS
STRING
Host port address of the logical interface (LIF) .
PORT_NAME
STRING
Port name
PORT_WWN_ID
NUMBER
World Wide Port Name (WWPN) of the logical interface (LIF) .
PORT_WWN_NAME
STRING
Port WWN name
RELATIVE_PORT_ID
NUMBER
The SCSI relative target port identifier of the logical interface (LIF) .
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_flexcache
The aps_v_ntc_flexcache view contains a single row for each NetApp Cluster Flexcache.
Table 4.294 aps_v_ntc_flexcache
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CACHE_AGGREGATE_ID
NUMBER
Cache aggregate name.
CACHE_AGGREGATE_NAME
STRING
Cache aggregate name
CACHE_AVAILABLE_GB
NUMBER
Cache available size.
CACHE_AVAILABLE_KB
NUMBER
Cache available size.
CACHE_STATE
STRING
Cache volume state.
CACHE_TOTAL_GB
NUMBER
Cache volume size.
CACHE_TOTAL_KB
NUMBER
Cache volume size.
CACHE_USED_PCT
NUMBER
Cache used percentage.
CACHE_VOLUME_ID
NUMBER
Cache volume name.
CACHE_VOLUME_NAME
STRING
Cache volume name
CONNECTION_STATUS
STRING
Status of the connection between the cache and the origin volumes.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode FlexCache data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode FlexCache data was last updated in the StorageConsole database.
NTC_FLEXCACHE_ID
NUMBER
FlexCache ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
The name of the Vserver where the created FlexCache is located.
ORIGIN_AGGREGATE_ID
NUMBER
Origin aggregate name.
ORIGIN_AGGREGATE_NAME
STRING
Origin aggregate name
ORIGIN_STATE
STRING
Origin volume state.
ORIGIN_VOLUME_ID
NUMBER
Origin volume name that contains the authoritative data.
ORIGIN_VOLUME_NAME
STRING
Origin volume name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_host_info
The aps_v_ntc_host_info view contains a single row for each NetApp Cluster Host Info.
Table 4.295 aps_v_ntc_host_info
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode host info data was created in the StorageConsole database.
HOST_ID
NUMBER
Canonical hostname in a simple string or in a fully qualified domain name (FQDN).
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode host info was last updated in the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Identifier of the Vserver.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_iscsi_interface
The aps_v_ntc_iscsi_interface view contains a single row for each NetApp Cluster ISCSI Interface.
Table 4.296 aps_v_ntc_iscsi_interface
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode iSCSI interface data was created in the StorageConsole database.
CURRENT_PORT
STRING
Name of the physical ethernet interface currently hosting the logical interface (LIF) .
INTERFACE_NAME
STRING
Interface name
IP_ADDRESS
STRING
iSCSI target portal IP address.
IP_PORT
NUMBER
iSCSI target portal TCP port.
IS_INTERFACE_ENABLED
STRING
Indicates if the interface is enabled for iSCSI.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode iSCSI interface data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
NTC_NET_INTERFACE_ID
NUMBER
Net Interface ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
Name of the node currently hosting the logical interface (LIF) .
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_TP_GROUP_ID
NUMBER
Name of target portal group associate with the interface.
NTC_VSERVER_ID
NUMBER
The name of the vserver containing this iSCSI data logical interface (LIF) .
RELATIVE_PORT_ID
NUMBER
The SCSI relative target port identifier of the logical interface (LIF) .
TP_GROUP_NAME
STRING
TP group name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_license
The aps_v_ntc_license view contains a single row for each NetApp Cluster License.
Table 4.297 aps_v_ntc_license
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode license data was created in the StorageConsole database.
CUSTOMER_ID
STRING
Customer Identification, used to track site licenses issued to enterprise-level agreement customers.
DESCRIPTION
STRING
Description of the licensed package.
EXPIRATION_TIME
DATE
License expiration time.
IS_LEGACY
STRING
A legacy license indicates that the license was installed prior to this release.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode license data was last updated in the StorageConsole database.
LICENSED_PACKAGE
STRING
Name of the licensed package.
LICENSE_TYPE
STRING
License type: license, site, or demo.
NODE_NAME
STRING
Node name
NTC_LICENSE_ID
NUMBER
License ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
OWNER
STRING
Controller or cluster that owns the serial number for the license.
SERIAL_NBR
STRING
Serial number of the controller or cluster.
aps_v_ntc_login_account
The aps_v_ntc_login_account view contains a single row for each NetApp Cluster Login Account.
Table 4.298 aps_v_ntc_login_account
Column Name
Data Type
Description
ACCOUNT_COMMENT
STRING
Comments for the user account.
APPLICATION
STRING
Name of the application.
ARRAY_NAME
STRING
Array name
AUTHENTICATION_METHOD
STRING
Authentication method for the application.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode login account data was created in the StorageConsole database.
IS_ACCOUNT_LOCKED
STRING
Account locked.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode login account data was last updated in the StorageConsole database.
NTC_LOGIN_ACCOUNT_ID
NUMBER
Login account ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Name of the Vserver.
ROLE_NAME
STRING
Name of the role.
USER_NAME
STRING
Name of the user.
VSERVER_NAME
STRING
Vserver name
 
aps_v_ntc_login_role
The aps_v_ntc_login_role view contains a single row for each NetApp Cluster Login Role.
Table 4.299 aps_v_ntc_login_role
Column Name
Data Type
Description
ACCESS_LEVEL
STRING
Access level for the role.
ARRAY_NAME
STRING
Array name
COMMAND_DIRECTORY_NAME
STRING
The command or command directory to which the role has access.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode login rule data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode login role data was last updated in the StorageConsole database.
NTC_LOGIN_ROLE_ID
NUMBER
Login role ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Name of the Vserver.
ROLE_NAME
STRING
Name of the role.
ROLE_QUERY
STRING
A query for the role.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_lun
The aps_v_ntc_lun view contains a single row for each NetApp Cluster LUN.
Table 4.300 aps_v_ntc_lun
Column Name
Data Type
Description
ALIGNMENT
STRING
Alignment of the LUN.
ARRAY_NAME
STRING
Array name
BACKING_SNAPSHOT
STRING
Path to the backing snapshot file for a LUN.
BLOCK_SIZE_BYTE
NUMBER
Disk block size of the LUN in bytes.
CLONE_BACKING_SNAPSHOT
STRING
The clone operation creates a temporary snapshot that allows updates to continue while the clone operation progresses.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode logical unit data was created in the StorageConsole database.
DEVICE_BINARY_ID
STRING
SCSI peripheral device identifying Information.
DEVICE_TEXT_ID
STRING
SCSI peripheral device text ID.
IS_CLONE
STRING
Indicates if the LUN is a clone.
IS_CLONE_AUTO_DELETE_ENABLED
STRING
Indicates if the LUN clone is allowed to be deleted by autodelete in try/disrupt mode.
IS_MAPPED
STRING
Indicates if the LUN is mapped to any initiators.
IS_ONLINE
STRING
State of the LUN.
IS_READONLY
STRING
Indicates if the LUN is read-only or read/write.
IS_RESTORE_INACCESSIBLE
STRING
Indicates if the LUN is fenced for I/O and management operations due to an ongoing restore operation.
IS_SPACE_ALLOC_ENABLED
STRING
Indicates if the LUN has space allocation enabled.
IS_SPACE_RESERVATION_ENABLED
STRING
Indicates if the LUN has space reservation enabled.
IS_STAGING
STRING
Indicates if the LUN is a temporary staging LUN.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode logical unit data was last updated in the StorageConsole database.
LOGICAL_UNIT_ID
NUMBER
Logical Unit ID, for internal use by the StorageConsole database.
LOGICAL_UNIT_NAME
STRING
Logical unit name
LUN_CLASS
STRING
The class of the LUN.
LUN_COMMENT
STRING
User-specified comment for the LUN.
LUN_CREATION_TIMESTAMP
DATE
The time this LUN was created, in seconds since January 1, 1970.
LUN_PATH
STRING
Path of the LUN.
MULTI_PROTOCOL_TYPE
STRING
OS type of the LUN.
NTC_Qtree_ID
NUMBER
Name of the Qtree containing the LUN.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume containing the LUN.
NTC_VSERVER_ID
NUMBER
Vserver containing the LUN.
PREFIX_SIZE_GB
NUMBER
Size of the prefix stream for this LUN in bytes.
PREFIX_SIZE_KB
NUMBER
Size of the prefix stream for this LUN in bytes.
QOS_POLICY_GROUP
STRING
The QoS policy group defines measurable Service Level Objectives (SLOs) that apply to the storage objects associated with the policy group.
Qtree_NAME
STRING
Qtree name
SERIAL_NBR
STRING
Serial number of the LUN.
SHARE_STATE
STRING
Share state of the LUN.
SUFFIX_SIZE_GB
NUMBER
Size of the suffix stream for the LUN in bytes. This value is determined by the OS type of the LUN at creation time.
SUFFIX_SIZE_KB
NUMBER
Size of the suffix stream for the LUN in bytes. This value is determined by the OS type of the LUN at creation time.
USED_GB
NUMBER
Number of bytes used by this LUN.
USED_KB
NUMBER
Number of bytes used by this LUN.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_lun_log
The aps_v_ntc_lun_log view contains a single row for each NetApp Cluster LUN Log.
Table 4.301 aps_v_ntc_lun_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
LOGICAL_UNIT_ID
NUMBER
Universally unique identifier (UUID) of the LUN.
LOGICAL_UNIT_NAME
STRING
Logical unit name
LOG_DATE
DATE
The date and time the LUN history samples were collected. For NetApp Cluster, this is set to the start of the performance collection for all samples.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PREFIX_SIZE_GB
NUMBER
Size of the prefix stream for this LUN in bytes.
PREFIX_SIZE_KB
NUMBER
Size of the prefix stream for this LUN in bytes.
SUFFIX_SIZE_GB
NUMBER
Size of the suffix stream for the LUN in bytes. This value is determined by the OS type of the LUN at creation time.
SUFFIX_SIZE_KB
NUMBER
Size of the suffix stream for the LUN in bytes. This value is determined by the OS type of the LUN at creation time.
USED_GB
NUMBER
Number of bytes used by this LUN.
USED_KB
NUMBER
Number of bytes used by this LUN.
aps_v_ntc_lun_perform_log
The aps_v_ntc_lun_perform_log view contains a single row for each NetApp Cluster LUN Performance Log.
Table 4.302 aps_v_ntc_lun_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_OTHER_LATENCY_MS
NUMBER
Average other operations latency in milliseconds for all operations on the LUN.
AVG_READ_LATENCY_MS
NUMBER
Average read latency in milliseconds for all operations on the LUN.
AVG_TOTAL_LATENCY_MS
NUMBER
Average latency in milliseconds for all operations on the LUN.
AVG_WRITE_LATENCY_MS
NUMBER
Average write latency in milliseconds for all operations on the LUN.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode LUN performance history data was collected.
INTERVAL_TYPE
STRING
Interval type of the LUN performance history collection.
LOGICAL_UNIT_ID
NUMBER
Aggregated logical unit path.
LOGICAL_UNIT_NAME
STRING
Logical unit name
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
OTHER_OPS
NUMBER
Number of other operations.
QUEUE_FULL_RESP_PS
NUMBER
Queue full responses.
READ_BPS
NUMBER
Read rate in bits per second.
READ_OPS
NUMBER
Number of read operations.
TOTAL_OPS
NUMBER
Total number of operations on the LUN.
VSERVER_NAME
STRING
Vserver name
WRITE_BPS
NUMBER
Write rate in bits per second.
WRITE_OPS
NUMBER
Number of write operations.
aps_v_ntc_map_vserver_aggr
The aps_v_ntc_map_vserver_aggr view contains a single row for each NetApp Cluster Map Vserver Aggregate.
Table 4.303 aps_v_ntc_map_vserver_aggr
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
AGGR_AVAILABLE_GB
NUMBER
Assigned aggregate available size.
AGGR_AVAILABLE_KB
NUMBER
Assigned aggregate available size.
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode Vserver aggregate mapping data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode Vserver aggregate mapping data was last updated in the StorageConsole database.
NTC_AGGREGATE_ID
NUMBER
Assigned aggregate name.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_net_interface
The aps_v_ntc_net_interface view contains a single row for each NetApp Cluster Net Interface.
Table 4.304 aps_v_ntc_net_interface
Column Name
Data Type
Description
ADDRESS_FAMILY
STRING
Address family
ADMIN_STATUS
STRING
Administrative status of the logical interface (LIF).
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode network interface data was created in the StorageConsole database.
CURRENT_NODE_ID
NUMBER
The node on which the logical interface (LIF) currently resides.
CURRENT_NODE_NAME
STRING
Current node name
CURRENT_PORT
STRING
The port on which the logical interface (LIF) currently resides.
DATA_PROTOCOL
STRING
List of data protocols configured on the logical interface (LIF) . By default, these are nfs, cifs and fcache.
DNS_DOMAIN_NAME
STRING
Unique fully qualified logical interface (LIF) domain name of the DNS zone of the LIF.
FAILOVER_GROUP_NAME
STRING
Failover group name.
FAILOVER_POLICY
STRING
Failover policy for the logical interface (LIF). For FCP and iSCSI LIFs, the only failover policy is: disabled; for NFS, CIFs and fcache LIFs, the default policy is: nextavail.
FIREWALL_POLICY
STRING
Firewall policy for the logical interface (LIF).
HOME_NODE_ID
NUMBER
Home node of the logical interface (LIF).
HOME_NODE_NAME
STRING
Home node name
HOME_PORT
STRING
Home port of the logical interface (LIF).
INTERFACE_NAME
STRING
Interface name
IS_AUTO_REVERT
STRING
Indicates if the data logical interface (LIF) will revert to its home node under certain circumstances such as startup, and load-balancing migration is disabled automatically.
IS_HOME
STRING
Indicates if the logical interface (LIF) is currently on the home node and home port.
IS_IPV4_LINK_LOCAL
STRING
Indicates if an interface is automatically configured with an IPv4 address.
IS_LISTEN_FOR_DNS_QUERY
STRING
Indicates if the IP address will listen for DNS queries for the specified DNS zone.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode network interface data was last updated in the StorageConsole database.
LIF_IP_ADDRESS
STRING
IP address of the logical interface (LIF).
LIF_ROLE
STRING
Role of the logical interface (LIF).
LIF_UUID
STRING
Logical interface (LIF) universally unique identifier, available in Data ONTAP 8.2 and later.
NBR_OF_NETMASK_BITS
NUMBER
Number of bits in the netmask.
NETMASK
STRING
Netmask for the logical interface (LIF).
NET_INTERFACE_COMMENT
STRING
Comment that descripts the network interface.
NTC_NET_INTERFACE_ID
NUMBER
Name of the network interface hosting the connection.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver name.
OPERATIONAL_STATUS
STRING
Operational status of the logical interface (LIF).
ROUTING_GROUP_NAME
STRING
Routing group that enables multiple logical interfaces to share a set of routing table entries.
USE_FAILOVER_GROUP
STRING
Indicates if failover rules are automatically created, manually created by the administrator, or disabled.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_nfs_perform_log
The aps_v_ntc_nfs_perform_log view contains a single row for each NetApp Cluster NFS performance Log.
Table 4.305 aps_v_ntc_nfs_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_READDIR_LATENCY_MS
NUMBER
Average latency of read directory procedure requests.
AVG_READ_LATENCY_MS
NUMBER
Average latency of read procedure requests.
AVG_READ_SYMLINK_LATENCY_MS
NUMBER
Average latency of Read Sym Link procedure requests.
AVG_WRITE_LATENCY_MS
NUMBER
Average latency of write procedure requests.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode NFS performance history data was collected.
INTERVAL_TYPE
STRING
Interval type of the NFS performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NBR_OF_READDIR_ERR
NUMBER
Number of erroneous read directory procedure requests.
NBR_OF_READDIR_SUCCESS
NUMBER
Number of successful read directory plus procedure requests.
NBR_OF_READDIR_TOTAL
NUMBER
Total number of read directory plus procedure requests. Counter for NFSv3.
NBR_OF_READ_ERR
NUMBER
Number of erroneous read procedure requests.
NBR_OF_READ_SUCCESS
NUMBER
Number of successful read procedure requests.
NBR_OF_READ_SYMLINK_ERR
NUMBER
Number of erroneous Read Sym Link procedure requests.
NBR_OF_READ_TOTAL
NUMBER
Total number read of procedure requests.
NBR_OF_SYMLINK_SUCCESS
NUMBER
Number of successful Read Sym Link procedure requests.
NBR_OF_SYMLINK_TOTAL
NUMBER
Total number of Read Sym Link procedure requests.
NBR_OF_WRITE_ERR
NUMBER
Number of erroneous write procedure requests.
NBR_OF_WRITE_SUCCESS
NUMBER
Number of successful write procedure requests.
NBR_OF_WRITE_TOTAL
NUMBER
Total number of write procedure requests.
NFSV3_OPS
NUMBER
Total number of NFSv3 procedure requests per second.
NFSV41_OPS
NUMBER
Total number of NFSv4.1 operations per second.
NFSV4_OPS
NUMBER
Total number of NFSv4 procedures per second.
NFS_TYPE
STRING
Possible values: NFSv3, NFSv4, NFSv41.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
READDIR_PCT
NUMBER
Percentage of read directory procedure requests.
READ_PCT
NUMBER
Percentage of read procedure requests.
READ_SYMLINK_PCT
NUMBER
Percentage of Read Sym Link procedure requests for NFSv3.
V3_AVG_READDIRPLUS_LATENCY_MS
NUMBER
Average latency of read directory plus procedure requests.
V3_NBR_OF_READDIRPLUS_ERR
NUMBER
Number of erroneous read directory plus procedure requests.
V3_NBR_OF_READDIRPLUS_SUCCESS
NUMBER
Number of successful read directory plus procedure requests.
V3_NBR_OF_READDIRPLUS_TOTAL
NUMBER
Total number of read directory plus procedure requests.
V3_NBR_OF_READDIRPL_POSTOP_ERR
NUMBER
Number of failed post-op read directory plus procedures.
V3_NBR_OF_READDIR_POSTOP_ERR
NUMBER
Number of failed post-op read directory procedures.
V3_READDIRPLUS_PCT
NUMBER
Percentage of read directory plus procedure requests.
V4X_AVG_READLINK_LATENCY_MS
NUMBER
Average latency of NFSv4.1 Read Link operations.
V4X_NBR_OF_READLINK_ERR
NUMBER
The number of failed NFSv4.1 Read Link operations.
V4X_NBR_OF_READLINK_SUCCESS
NUMBER
The number of successful NFSv4.1 Read Link operations.
V4X_NBR_OF_READLINK_TOTAL
NUMBER
Total number of NFSv4.1 Read Link operations.
V4X_READLINK_PCT
NUMBER
Percentage of NFSv4.1 Read Link operations.
VSERVER_NAME
STRING
Vserver name
WRITE_PCT
NUMBER
Percentage of write procedure requests.
aps_v_ntc_nfs_server
The aps_v_ntc_nfs_server view contains a single row for each NetApp Cluster NFS Server.
Table 4.306 aps_v_ntc_nfs_server
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CHOWN_MODE
STRING
Vserver change ownership mode.
CREATION_DATE
DATE
The date and time the NetApp Cluster NFS server data was created in the StorageConsole database.
DEFAULT_WINDOWS_GROUP
STRING
The default windows group for CIFS access.
DEFAULT_WINDOWS_USER
STRING
The default windows user for CIFS access.
IS_EJUKEBOX_ENABLED
STRING
Indicates if the NFS server will send the EJUKEBOX error on server delays.
IS_MOUNT_ROOT_ONLY_ENABLED
STRING
Indicates if the Vserver allows MOUNT protocol calls only from privileged ports (port numbers less than 1024).
IS_NFS_ACCESS_ENABLED
STRING
Indicates if NFS server access is enabled.
IS_NFS_ROOT_ONLY_ENABLED
STRING
Indicates if the Vserver allows NFS protocol calls only from privileged ports (port numbers less than 1024).
IS_NFS_V2_ENABLED
STRING
Indicates if NFSv2 is enabled. Starting with Data ONTAP 8.2, NFSv2 is no longer supported.
IS_NFS_V3_CONNECT_DROP_ENABLED
STRING
Indicates if the connection is dropped when an NFSv3 request is dropped.
IS_NFS_V3_ENABLED
STRING
Indicates if NFSv3 is enabled.
IS_NFS_V3_FSID_CHANGE_ENABLED
STRING
Indicates if NFSv3 clients see a change in the file system ID (FSID) as they traverse file systems.
IS_NFS_V40_ACL_ENABLED
STRING
Indicates if the NFSv4.0 access control list (ACL) feature is enabled.
IS_NFS_V40_ENABLED
STRING
Indicates if NFS version 4.0 is enabled.
IS_NFS_V40_MIGRATION_ENABLED
STRING
Indicates if the NFSv4.0 migration feature is enabled.
IS_NFS_V40_READ_DELEG_ENABLED
STRING
Indicates if the NFSv4.0 read delegation feature is enabled.
IS_NFS_V40_REFERRALS_ENABLED
STRING
Indicates if the NFSv4.0 referrals feature is enabled.
IS_NFS_V40_REQ_OPEN_CONFIRM
STRING
Indicates if the server will require an OPEN_CONFIRM operation for all NFSv4.0 clients.
IS_NFS_V40_WRITE_DELEG_ENABLED
STRING
Indicates if the NFSv4.0 write delegation feature is enabled.
IS_NFS_V41_ACL_ENABLED
STRING
Indicates if the NFSv4.0 access control list (ACL) feature is enabled.
IS_NFS_V41_ACL_PRESERV_ENABLED
STRING
Indicates if the NFSv4 server will preserve and modify the access control list (ACL) when chmod is done.
IS_NFS_V41_ENABLED
STRING
Indicates if NFSv4.1 is enabled.
IS_NFS_V41_MIGRATION_ENABLED
STRING
Indicates if the NFSv4.1 migration feature is enabled.
IS_NFS_V41_PNFS_ENABLED
STRING
Indicates if Parallel NFS support for NFS version 4.1 is enabled.
IS_NFS_V41_PNFS_SVOL_ENABLED
STRING
Indicates if striped volume support for Parallel NFS is enabled.
IS_NFS_V41_READ_DELEG_ENABLED
STRING
Indicates if the NFSv4.1 read delegation feature is enabled.
IS_NFS_V41_REFERRALS_ENABLED
STRING
Indicates if the NFSv4.1 referrals feature is enabled.
IS_NFS_V41_STATE_PROT_ENABLED
STRING
Indicates if the NFSv4.1 state protection feature is enabled.
IS_NFS_V41_WRITE_DELEG_ENABLED
STRING
Indicates if the NFSv4.1 write delegation feature is enabled.
IS_NFS_V4_FSID_CHANGE_ENABLED
STRING
Indicates if clients see a change in the file system ID (FSID) as NFSv4 clients traverse file systems.
IS_NFS_V4_NUMERIC_ID_ENABLED
STRING
Indicates if NFSv4 support for numeric owner IDs is enabled.
IS_Qtree_EXPORT_ENABLED
STRING
Indicates if the Vserver allows read-only Qtree exports.
IS_VALIDATE_Qtree_ENABLED
STRING
Indicates if the Vserver performs additional validation for Qtrees.
IS_VSTORAGE_ENABLED
STRING
Indicates if the usage of vStorage protocol for server-side copies is enabled (primarily used in hypervisors).
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode NFS server data was last updated in the StorageConsole database.
MAX_NBR_OF_ACES
NUMBER
Maximum number of access control entries (ACE) allowed in an access control list (ACL).
NBR_OF_SLOTS_NFS_V4X_SESSION
NUMBER
Number of slots in the NFSv4.x session slot tables.
NFS_UNIX_SECURITY_OPS
STRING
Ignore/fail UNIX security operations on new technology file system (NTFS) volumes.
NFS_V41_IMPL_ID_DOMAIN
STRING
NFSv4.1 implementation ID domain.
NFS_V41_IMPL_ID_NAME
STRING
NFSv4.1 implementation ID name.
NFS_V41_IMPL_ID_TIME
DATE
NFSv4.1 implementation ID time.The number of seconds since January 1, 1970.
NFS_V4X_SLOT_REPLY_CACHE_BYTE
NUMBER
Size (in bytes) of the reply that will be cached in each NFSv4.x session slot.
NFS_V4_GRACE_TIMEOUT_SEC
NUMBER
NFSv4 grace timeout value in seconds.
NFS_V4_ID_DOMAIN
STRING
NFSv4 ID mapping domain.
NFS_V4_LEASE_TIMEOUT_SEC
NUMBER
NFSv4 lease timeout value in seconds.
NTC_NFS_SERVER_ID
NUMBER
NFS Server ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver name.
RPCSEC_CTX_HIGH_WATER_MARK
NUMBER
High-water mark for the RPCSEC_GSS Context Cache.
RPCSEC_CTX_IDLE_TIME_SEC
NUMBER
Time in seconds before an idle entry in the RPCSEC_GSS context cache is deleted.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_node
The aps_v_ntc_node view contains a single row for each NetApp Cluster Node.
Table 4.307 aps_v_ntc_node
Column Name
Data Type
Description
AGGREGATE_EXTERNAL_CAPACITY_GB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type is not LUN.
AGGREGATE_EXTERNAL_CAPACITY_KB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type is not LUN.
AGGREGATE_FREE_CAPACITY_GB
NUMBER
Sum of the file system available capacity of all the aggregates.
AGGREGATE_FREE_CAPACITY_KB
NUMBER
Sum of the file system available capacity of all the aggregates.
AGGREGATE_INTERNAL_CAPACITY_GB
NUMBER
Sum of the file system total capacity of all the aggregates when the disk type value is LUN.
AGGREGATE_INTERNAL_CAPACITY_KB
NUMBER
Sum of the file system total capacity of all the aggregates when the disk type value is LUN.
AGGREGATE_USED_CAPACITY_GB
NUMBER
Sum of the file system used capacity of all the aggregates.
AGGREGATE_USED_CAPACITY_KB
NUMBER
Sum of the file system used capacity of all the aggregates.
ARRAY_NAME
STRING
Array name
BACKPLANE_PART_NBR
STRING
Part number of the backplane.
BACKPLANE_REVISION
STRING
Revision of the backplane part number.
BACKPLANE_SERIAL_NBR
STRING
Backplane serial number.
BOARD_SPEED_MHZ
NUMBER
Speed of the system board in megahertz.
BOARD_TYPE
STRING
Type of system board, as defined by the vendor.
BUILD_TIMESTAMP
DATE
Time of the software build creation, in seconds since January 1, 1970, for the software image running on the node. This field is available in Data ONTAP 8.1 or later.
CONTROLLER_ADDRESS
STRING
Location of the controller in a multi-controller platform.
CPU_BUSY_TIME_SEC
NUMBER
The time (in hundredths of a second) that the CPU has been performing work since the last boot.
CPU_CIOB_REVISION_ID
STRING
Processor's CIOB (Champion I/O Bus) revision ID.
CPU_FIRMWARE_RELEASE
STRING
Firmware release number.
CPU_MICROCODE_VERSION
NUMBER
CPU's microcode version. Range: [0..231-1]
CPU_PART_NBR
STRING
CPU's part number.
CPU_PROCESSOR_ID
STRING
Processor's ID.
CPU_PROCESSOR_TYPE
STRING
Processor's Type.
CPU_REVISION
STRING
CPU's part number revision.
CPU_SERIAL_NBR
STRING
CPU's serial number.
CREATION_DATE
DATE
The date and time the NetApp Cluster node data was created in the StorageConsole database.
FAILED_FAN_MESSAGE
STRING
Text error message describing the current condition of the chassis fans.
FAILED_POWER_SUPPLY_MESSAGE
STRING
Text error message describing the state of any power supplies thare are degraded.
IS_EPSILON_NODE
STRING
A node can be designated as epsilon to add weight to its voting in a cluster with an even number of nodes.
IS_NODE_CLUSTER_ELIGIBLE
STRING
Indicates nodes that are eligible to participate in a cluster.
IS_NODE_HEALTHY
STRING
Indicates the health of a node in a cluster.
IS_OVER_TEMPERATURE
STRING
Indicates that the hardware is currently operating outside of the recommended temperature range. Hardware will shutdown if the temperature exceeds critical thresholds.
IS_SUPPORT_RAID_ARRAY
STRING
Indicates if the system supports RAID arrays back-end connectivity.
LAST_UPDATED
DATE
The date and time the NetApp Cluster node data was last updated in the StorageConsole database.
LUN_ALLOCATED_CAPACITY_GB
NUMBER
Sum of the total capacity of the logical units.
LUN_ALLOCATED_CAPACITY_KB
NUMBER
Sum of the total capacity of the logical units.
LUN_TOTAL_CAPACITY_GB
NUMBER
Sum of the allocated capacity of the logical units.
LUN_TOTAL_CAPACITY_KB
NUMBER
Sum of the allocated capacity of the logical units.
MAX_AGGREGATE_SIZE_GB
NUMBER
Maximum supported aggregate size.
MAX_AGGREGATE_SIZE_KB
NUMBER
Maximum supported aggregate size.
MAX_NBR_OF_VOLUMES
NUMBER
Maximum number of flexible volumes supported on this node.
MAX_VOLUME_SIZE_GB
NUMBER
The maximum supported volume size.
MAX_VOLUME_SIZE_KB
NUMBER
The maximum supported volume size.
MEMORY_SIZE_MB
NUMBER
Memory size in MiB. (1024*1024).
NBR_OF_AGGREGATES
NUMBER
Number of aggregates in the node.
NBR_OF_ALLOCATED_LUNS
NUMBER
Number of allocated LUNs in the node.
NBR_OF_DISKS
NUMBER
Number of disks in the node.
NBR_OF_FAILED_FAN
NUMBER
Count of the number of chassis fans that are not operating within the recommended revolutions-per-minute (RPM) range.
NBR_OF_FAILED_POWER_SUPPLY
NUMBER
Number of failed power supply units.
NBR_OF_FLEX_VOLUMES
NUMBER
Sum of all member nodes' thinly provisioned volumes (FlexVols).
NBR_OF_INF_VOLUMES
NUMBER
Sum of all member infinite volumes in the node.
NBR_OF_LUNS
NUMBER
Number of LUNs in the node.
NBR_OF_PROCESSORS
NUMBER
Number of processors in the NetApp appliance.
NBR_OF_VOLUMES
NUMBER
Number of volumes in the node.
NODE_ASSET_TAG
STRING
The asset tag of the node.
NODE_LOCATION
STRING
The physical location of the node.
NODE_MODEL
STRING
The model of the node.
NODE_NAME
STRING
Node name
NODE_NVRAM_ID
NUMBER
Vendor specific non-volatile random-access memory (NVRAM) ID of the node.
NODE_OWNER
STRING
The owner of the node.
NODE_SERIAL_NBR
STRING
The serial number of the node.
NODE_SYSTEM_ID
STRING
The system ID of the node.
NODE_UPTIME_SEC
NUMBER
Total time, in seconds, that the node has been up.
NODE_UUID
STRING
The universally unique identifier for the node. It is a 36-character string composed of 32 hexadecimal characters.
NODE_VENDOR
STRING
The hardware vendor of the node.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NVRAM_BATTERY_STATUS
STRING
Status of the non-volatile random-access memory (NVRAM) battery.
ONTAP_VERSION
STRING
Data ONTAP version running on the node.
PARTNER_SYSTEM_ID
STRING
Partner's system ID. Displayed in a cluster environment.
PARTNER_SYSTEM_NAME
STRING
Partner's system name. Displayed in a cluster environment.
PARTNER_SYSTEM_SERIAL_NBR
STRING
Partner System serial number. Currently a string of numbers.
PROD_TYPE
STRING
Values are based on the vendor providing the raw storage: V-Series, gfiler, or gateway.
SYSTEM_MACHINE_TYPE
STRING
Machine type of the system. For example, FAS3050.
SYSTEM_REVISION
STRING
Revision ID of the system board.
VOLUME_AVAILABLE_CAPACITY_GB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_AVAILABLE_CAPACITY_KB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_GB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_KB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_USED_CAPACITY_GB
NUMBER
Sum of the used capacity of all the volumes.
VOLUME_USED_CAPACITY_KB
NUMBER
Sum of the used capacity of all the volumes.
aps_v_ntc_node_log
The aps_v_ntc_node_log view contains a single row for each NetApp Cluster Node Log.
Table 4.308 aps_v_ntc_node_log
Column Name
Data Type
Description
AGGREGATE_EXTERNAL_CAPACITY_GB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type is not LUN.
AGGREGATE_EXTERNAL_CAPACITY_KB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type is not LUN.
AGGREGATE_FREE_CAPACITY_GB
NUMBER
Sum of the file system available capacity of all the aggregates.
AGGREGATE_FREE_CAPACITY_KB
NUMBER
Sum of the file system available capacity of all the aggregates.
AGGREGATE_INTERNAL_CAPACITY_GB
NUMBER
Sum of the file system total capacity of all the aggregates when the disk type value is LUN.
AGGREGATE_INTERNAL_CAPACITY_KB
NUMBER
Sum of the file system total capacity of all the aggregates when the disk type value is LUN.
AGGREGATE_USED_CAPACITY_GB
NUMBER
Sum of the file system used capacity of all the aggregates.
AGGREGATE_USED_CAPACITY_KB
NUMBER
Sum of the file system used capacity of all the aggregates.
ARRAY_NAME
STRING
Array name
LOG_DATE
DATE
The date and time the node history samples were collected. For NetApp Cluster-Mode, this is set to the start of the performance collection for all samples.
LUN_ALLOCATED_CAPACITY_GB
NUMBER
Sum of the total capacity of the logical units.
LUN_ALLOCATED_CAPACITY_KB
NUMBER
Sum of the total capacity of the logical units.
LUN_TOTAL_CAPACITY_GB
NUMBER
Sum of the allocated capacity of the logical units.
LUN_TOTAL_CAPACITY_KB
NUMBER
Sum of the allocated capacity of the logical units.
MAX_AGGREGATE_SIZE_GB
NUMBER
Maximum supported aggregate size.
MAX_AGGREGATE_SIZE_KB
NUMBER
Maximum supported aggregate size.
MAX_VOLUME_SIZE_GB
NUMBER
Maximum supported volume size.
MAX_VOLUME_SIZE_KB
NUMBER
Maximum supported volume size.
NBR_OF_AGGREGATES
NUMBER
Number of aggregates in the node.
NBR_OF_ALLOCATED_LUNS
NUMBER
Number of allocated LUNs in the node.
NBR_OF_DISKS
NUMBER
Number of disks in the node.
NBR_OF_FLEX_VOLUMES
NUMBER
Sum of all member nodes' thinly provisioned volumes (FlexVols).
NBR_OF_INF_VOLUMES
NUMBER
Sum of all member infinite volumes in the node.
NBR_OF_LUNS
NUMBER
Number of LUNs in the node.
NBR_OF_VOLUMES
NUMBER
Number of volumes in the node.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
List of node names.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
VOLUME_AVAILABLE_CAPACITY_GB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_AVAILABLE_CAPACITY_KB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_GB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_KB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_USED_CAPACITY_GB
NUMBER
Sum of the used capacity of all the volumes.
VOLUME_USED_CAPACITY_KB
NUMBER
Sum of the used capacity of all the volumes.
aps_v_ntc_option
The aps_v_ntc_option view contains a single row for each NetApp Cluster Option.
Table 4.309 aps_v_ntc_option
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CLUSTER_CONSTRAINT
STRING
Indicates the cluster-specific constraints of option.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode option data was created in the StorageConsole database.
DATA_TYPE
STRING
Data type of the cluster option.
DEFAULT_VALUE
STRING
Default initial value of the cluster option.
DESCRIPTION
STRING
Brief description of the cluster option.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode option data was last updated in the StorageConsole database.
NTC_OPTION_ID
NUMBER
Option ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
The name of the Vserver to which this option belongs.
OPTION_NAME
STRING
Name of the cluster option.
OPTION_VALUE
STRING
Value of the cluster option.
PRIVILEGE_LEVEL
STRING
The privilege level of this option.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_plex
The aps_v_ntc_plex view contains a single row for each NetApp Cluster Plex.
Table 4.310 aps_v_ntc_plex
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode plex data was created in the StorageConsole database.
IS_ONLINE
STRING
Indicates if the plex is online,
IS_RESYNCING
STRING
Indicates if the plex is currently resyncing.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode plex data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
NTC_AGGREGATE_ID
NUMBER
Aggregate ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_PLEX_ID
NUMBER
Plex ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PLEX_NAME
STRING
Plex name
PLEX_STATUS
STRING
Plex status in a comma-separated list.
POOL
NUMBER
The pool to which the majority of disks in the plex belong.
RESYNCING_PCT
NUMBER
If the plex is currently being resynced, this is the completion percentage.
RESYNC_LEVEL
NUMBER
If the plex is currently being resynced, this is the resync level.
aps_v_ntc_prc_node_perf_log
The aps_v_ntc_prc_node_perf_log view contains a single row for each NetApp Cluster Processor Node Performance Log.
Table 4.311 aps_v_ntc_prc_node_perf_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode processor node performance history data was collected.
INTERVAL_TYPE
STRING
Interval type of the processor node performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PROCESSOR_BUSY_PCT
NUMBER
Percentage of elapsed time that the processor is executing non-idle processes.
PROCESSOR_ELAPSED_TIME_SEC
NUMBER
Wall-clock time since boot used for calculating processor utilization.
SKSWITCHES_PS
NUMBER
Number of sk switches per second.
aps_v_ntc_processor_perf_log
The aps_v_ntc_processor_perf_log view contains a single row for each NetApp Cluster Processor Performance Log.
Table 4.312 aps_v_ntc_processor_perf_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode aggregate performance history data was collected.
INSTANCE_NAME
STRING
Instance name.
INTERVAL_TYPE
STRING
Interval type of the processor performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PROCESSOR_BUSY_PCT
NUMBER
Percentage of elapsed time that the processor is executing non-idle processes.
PROCESSOR_ELAPSED_TIME_SEC
NUMBER
Wall-clock time since boot used for calculating processor utilization.
SKSWITCHES_PS
NUMBER
Number of sk switches per second.
aps_v_ntc_qtree
The aps_v_ntc_qtree view contains a single row for each NetApp Cluster Qtree.
Table 4.313 aps_v_ntc_Qtree
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster Qtree data was created in the StorageConsole database.
EXPORT_POLICY_NAME
STRING
Export policy name
IS_EXPORT_POLICY_INHERITED
STRING
Indicates if the Qtree inherits the export policy of the parent volume.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode Qtree data was last updated in the StorageConsole database.
NBR_OF_CIFS_SHARES
NUMBER
Number of CIFS Shares in the Qtree.
NBR_OF_LUNS
NUMBER
Number of LUNs in the Qtree.
NBR_OF_NFS_EXPORTS
NUMBER
Number of NFS Exports in the Qtree.
NTC_EXPORT_POLICY_ID
NUMBER
Export policy of the Qtree. By default, Qtrees use the parent export policy of the containing volume if not otherwise specified at the time of creation
NTC_Qtree_ID
NUMBER
Qtree ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume containing the Qtree.
NTC_VSERVER_ID
NUMBER
The Vserver in which the volume belongs.
OPLOCKS
STRING
Indicates whether opportunistic locks are enabled on the Qtree.
Qtree_ID
NUMBER
ID of the Qtree (unique within the volume). This ID is 0 if the Qtree is the volume itself.
Qtree_NAME
STRING
Qtree name
Qtree_STATUS
STRING
Status of the Qtree.
SECURITY_STYLE
STRING
Security style of the Qtree.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_quota
The aps_v_ntc_quota view contains a single row for each NetApp Cluster Quota.
Table 4.314 aps_v_ntc_quota
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode aggregate quota was created in the StorageConsole database.
DISK_LIMIT
STRING
Maximum amount of disk space, in KiB, allowed for the quota target (hard disk space limit).
DISK_USED
STRING
Current amount of disk space, in KiB, used by the quota target.
FILE_LIMIT
STRING
Maximum number of files allowed for the quota target (hard files limit). A hyphen (-) indicates unlimited.
FILE_USED
STRING
Current number of files used by the quota target.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode quota data was last updated in the StorageConsole database.
NTC_Qtree_ID
NUMBER
Name of the Qtree to which the quota is applied.
NTC_QUOTA_ID
NUMBER
Quota ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume to which the quota is applied.
NTC_VSERVER_ID
NUMBER
The Vserver name in which the volume belongs, for which the quota is applicable.
Qtree_NAME
STRING
Qtree name
QUOTA_TARGET
STRING
For an explicit quota, this value is a fully qualified quota target.
QUOTA_TYPE
STRING
Quota Type
SOFT_DISK_LIMIT
STRING
Soft disk space limit, in KiB, for the quota target.
SOFT_FILE_LIMIT
STRING
Soft file limit (number of files) for the quota target.
THRESHOLD
STRING
Disk space threshold, in KiB, for the quota target.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_quota_error
The aps_v_ntc_quota_error view contains a single row for each NetApp Cluster Quota Error.
Table 4.315 aps_v_ntc_quota_error
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode quota error data was created in the StorageConsole database.
ERROR_MSG
STRING
Error message
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode quota error data was last updated in the StorageConsole database.
NTC_QUOTA_STATUS_ID
NUMBER
Quota status ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
QUOTA_STATUS
STRING
Quota status
aps_v_ntc_quota_log
The aps_v_ntc_quota_log view contains a single row for each NetApp Cluster Quota Log.
Table 4.316 aps_v_ntc_quota_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
DISK_LIMIT
STRING
Maximum amount of disk space, in KiB, allowed for the quota target (hard disk space limit).
DISK_USED
STRING
Current amount of disk space, in KiB, used by the quota target.
FILE_LIMIT
STRING
Maximum number of files allowed for the quota target (hard files limit). A hyphen (-) indicates unlimited.
FILE_USED
STRING
Current number of files used by the quota target.
LOG_DATE
DATE
The date and time the quota history samples were collected. For NetApp Cluster-Mode, this is set to the start of the performance collection for all samples.
NTC_QUOTA_ID
NUMBER
Quota ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
SOFT_DISK_LIMIT
STRING
A hyphen (-) indicates unlimited.
SOFT_FILE_LIMIT
STRING
A hyphen (-) indicates unlimited.
THRESHOLD
STRING
A hyphen (-) indicates unlimited.
aps_v_ntc_quota_status
The aps_v_ntc_quota_status view contains a single row for each NetApp Cluster Quota Status.
Table 4.317 aps_v_ntc_quota_status
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
COMPLETE_PCT
NUMBER
When the status is upgrading, resizing, or initializing, this field represents the percentage complete for an on or resize operation.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode quota status data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode quota status data was last updated in the StorageConsole database.
NTC_QUOTA_STATUS_ID
NUMBER
Quota status ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume to which the quota is applied.
NTC_VSERVER_ID
NUMBER
Vserver name in which the volume belongs, for which the quota is applicable.
QUOTA_STATUS
STRING
Quota status
REASON
STRING
A human-readable concise reason for the error.
SUB_STATUS
STRING
Minor quota status on the indicated volume. This status is only valid when primary the status is resizing or initializing.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_quota_user
The aps_v_ntc_quota_user view contains a single row for each NetApp Cluster Quota User.
Table 4.318 aps_v_ntc_quota_user
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode quota user data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode quota user data was last updated in the StorageConsole database.
NTC_QUOTA_ID
NUMBER
Quota ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
QUOTA_TYPE
STRING
Quota Type
QUOTA_USER_ID
STRING
ID of the user.
QUOTA_USER_NAME
STRING
Name of the user, group, or sid.
QUOTA_USER_TYPE
STRING
The type of quota user.
aps_v_ntc_raid_group
The aps_v_ntc_raid_group view contains a single row for each NetApp Cluster RAID Group.
Table 4.319 aps_v_ntc_raid_group
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
CHECKSUM_STYLE
STRING
Checksum style for the RAID group.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode RAID group data was created in the StorageConsole database.
IS_CACHE_TIER
STRING
Indicates if the RAID group is composed of solid state drives (SSDs) and the owning aggregate is a hybrid (the group is not part of usable space).
IS_RECOMPUTING_PARITY
STRING
Indicates if the RAID group is recomputing parity.
IS_RECONSTRUCTING
STRING
Indicates if the RAID group is reconstructing.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode RAID group data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
NTC_AGGREGATE_ID
NUMBER
Aggregate ID, for internal use by the StorageConsole database.
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_PLEX_ID
NUMBER
Plex ID, for internal use by the StorageConsole database.
NTC_RAID_GROUP_ID
NUMBER
RAID Group ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PLEX_NAME
STRING
Plex name
RAID_GROUP_NAME
STRING
Raid group name
RECOMPUTING_PARITY_PCT
NUMBER
The percentage of parity recomputation completed, if the RAID group is recomputing parity.
RECONSTRUCTION_PCT
NUMBER
Completion percentage, if reconstruction is in progress.
aps_v_ntc_raid_perf_log
The aps_v_ntc_raid_perf_log view contains a single row for each NetApp Cluster RAID Performance Log.
Table 4.320 aps_v_ntc_raid_perf_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_RAID_LATENCY_MS
NUMBER
Average latency for all reads operations sent by Write Anywhere File Layout (WAFL) to RAID in microseconds.
AVG_TETRIS_LATENCY_MS
NUMBER
Average latency for tetris as seen by Write Anywhere File Layout (WAFL) in microseconds.
BLKS_READ_PS
NUMBER
Blocks read per second.
BLKS_WRITE_PS
NUMBER
Blocks written per second.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode CIFS performance history data was collected.
FULL_STRIPES_WRITE_PS
NUMBER
Full stripes written per second.
INTERVAL_TYPE
STRING
Interval type of the collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PARTIAL_STRIPES_WRITE_PS
NUMBER
Partial stripes written per second.
RAID_READ_OPS
NUMBER
Read operations per second issued by Write Anywhere File Layout (WAFL) to RAID.
RAID_TETRIS_COUNT_PS
NUMBER
Number of tetrises sent to RAID per second.
STRIPES_WRITE_PS
NUMBER
Stripes written per second.
TETRIS_WRITE_PS
NUMBER
Tetrises written per second.
aps_v_ntc_smb_perform_log
The aps_v_ntc_smb_perform_log view contains a single row for each NetApp Cluster SMB Performance Log.
Table 4.321 aps_v_ntc_smb_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_READ_CLASS_LATENCY_MS
NUMBER
Average latency for SMB1/SMB2 read class operations.
AVG_READ_LATENCY_MS
NUMBER
Average latency for SMB1_COM_READ/SMB2_COM_READ operations.
AVG_SMB_LATENCY_MS
NUMBER
Average latency for SMB1/SMB2 operations.
AVG_WRITE_LATENCY_MS
NUMBER
Average latency for SMB1_COM_WRITE /SMB2_COM_WRITE operations.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster SMB history data was collected.
INTERVAL_TYPE
STRING
Interval type of the SMB performance history collection.
LOG_DATE
DATE
Possible values: SMB1 or SMB2.
MAX_NBR_OF_OPEN_FILES
NUMBER
Maximum number of open files over SMB2 achieved.
NBR_OF_ACTIVE_SEARCHES
NUMBER
Number of active searches over SMB1/SMB2.
NBR_OF_OBSERVED_SMB_TOTAL
NUMBER
Total observed SMB1/SMB2 operations to be used as a base counter for SMB average latency calculation.
NBR_OF_READ_LATENCY
NUMBER
Number of SMB1_COM_READ/SMB2_COM_READ operations used as a base for latency calculations.
NBR_OF_SMB_CMDS_OUTSTANDING
NUMBER
Number of SMB1/SMB2 commands in process.
NBR_OF_SMB_CONNECT_ESTD
NUMBER
Number of established SMB1/SMB3 sessions.
NBR_OF_SMB_CONNECT_SHARES
NUMBER
Number of SMB1/SMB2 share connections.
NBR_OF_SMB_READ_CLASS
NUMBER
Total number of SMB1/SMB2 read class operations.
NBR_OF_SMB_TOTAL
NUMBER
Number of SMB1/SMB2 operations.
NBR_OF_SMB_WRITE_CLASS
NUMBER
Total number of SMB1/SMB2 write class operations.
NBR_OF_WRITE_LATENCY
NUMBER
Number of SMB1_COM_WRITE/SMB2_COM_WRITE operations used as a base for latency calculations.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
SMB1_NBR_OF_READ_ANDX
NUMBER
Number of SMB1_COM_READ_ANDX operations used as a base for latency calculations.
SMB1_NBR_OF_WRITE_ANDX
NUMBER
Number of SMB1_COM_WRITE_ANDX operations used as a base for latency calculations.
SMB1_READ_ANDX_LATENCY_MS
NUMBER
Average latency for SMB1_COM_READ_ANDX operations.
SMB1_WRITE_ANDX_LATENCY_MS
NUMBER
Average latency for SMB1_COM_WRITE_ANDX operations.
SMB_TYPE
STRING
Timestamp at which the performance data was collected.
VSERVER_NAME
STRING
Vserver name
aps_v_ntc_snapshot
The aps_v_ntc_snapshot view contains a single row for each NetApp Cluster Snapshot.
Table 4.322 aps_v_ntc_snapshot
Column Name
Data Type
Description
ACCESS_TIME
DATE
The volume access time when the snapshot was created, in seconds since Jan 1, 1970.
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster snapshot data was created in the StorageConsole database.
CUM_TOTAL_BLOCKS
NUMBER
Cumulative total of 1024-byte blocks of this snapshot and previous snapshots.
DEPENDENCY
STRING
Comma-separated list of pplications dependent on this snapshot.
IS_7MODE_SNAPSHOT
STRING
Indicates if the snapshot is a 7-mode snapshot.
IS_BUSY
STRING
Indicates if the snapshot is being used by an application.
IS_CONSTITUENT_SNAPSHOT
STRING
Indicates if the snapshot is a constituent snapshot.
IS_CONTAIN_LUN_CLONES
STRING
Indicates if the snapshot contains LUN clones.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode snapshot data was last updated in the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Volume name.
NTC_VSERVER_ID
NUMBER
Name of the Vserver to which this volume belongs.
SNAPMIRROR_LABEL
STRING
SnapMirror label associated with the snapshot.
SNAPSHOT_INSTANCE_UUID
STRING
The 128-bit unique snapshot identifier expressed in the form of a universally unique identifier (UUID).
SNAPSHOT_NAME
STRING
Name of the snapshot.
SNAPSHOT_STATE
STRING
The state of the snapshot.
SNAPSHOT_VERSION_UUID
STRING
The 128 bit unique snapshot identifier expressed in the form of UUID. This field uniquely identifies the snapshot's logical data layout.
TOTAL_BLOCKS
NUMBER
Number of 1024-byte blocks in the snapshot.
TOTAL_BLOCKS_CUM_PCT
NUMBER
Percentage of blocks owned by this snapshot and all of the more recent snapshots.
TOTAL_BLOCKS_PCT
NUMBER
Percentage of blocks owned by this snapshot.
USED_BLOCKS_CUM_PCT
NUMBER
Percentage of blocks owned by this snapshot and all of the more recent snapshots.
USED_BLOCKS_PCT
NUMBER
Percentage of blocks owned by this snapshot.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
APS_V_NTC_snapshot_log
The aps_v_ntc_snapshot_log view contains a single row for each NetApp Cluster Snapshot Log.
Table 4.323 aps_v_ntc_snapshot_log
Column Name
Data Type
Description
ALLOCATED_GB
NUMBER
Number of 1024-byte blocks in the snapshot * Total usable size (in bytes) of the volume /100
ALLOCATED_KB
NUMBER
Number of 1024-byte blocks in the snapshot * Total usable size (in bytes) of the volume /100
ARRAY_NAME
STRING
Array name
CUM_TOTAL_BLOCKS
NUMBER
Cumulative total of 1024-byte blocks of this snapshot and previous snapshots.
LOG_DATE
DATE
The date and time the samples were collected. For NetApp Cluster, this is set to the start of the performance collection for all samples.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Volume name.
TOTAL_BLOCKS
NUMBER
Number of 1024-byte blocks in the snapshot.
USED_GB
NUMBER
Used blocks owned by this snapshot * Total usable size (in bytes) of the volume /100
USED_KB
NUMBER
Used blocks owned by this snapshot * Total usable size (in bytes) of the volume /100
VOLUME_NAME
STRING
Volume name
APS_V_NTC_snapshot_policy
The aps_v_ntc_snapshot_policy view contains a single row for each NetApp Cluster Snapshot Policy.
Table 4.324 aps_v_ntc_snapshot_policy
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode snapshot policy data was created in the StorageConsole database.
IS_ENABLED
STRING
Indicates if the snapshot policy is enabled and scheduled snapshots will be created on the volume associated with this policy.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode snapshot policy data was last updated in the StorageConsole database.
L_COMMENT
STRING
Description associated with the snapshot policy.
NBR_OF_SCHEDULES
NUMBER
Total number of schedules in the policy attributes.
NTC_SNAPSHOT_POLICY_ID
NUMBER
Snapshot Policy ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver name associated with the snapshot policy.
POLICY_OWNER
STRING
Owner of the policy attributes.
SNAPSHOT_POLICY_NAME
STRING
Snapshot policy name
VSERVER_NAME
STRING
Vserver name
APS_V_NTC_snapshot_schdcron
The aps_v_ntc_snapshot_schdcron view contains a single row for each NetApp Cluster Snapshot Schedule Cron.
Table 4.325 aps_v_ntc_schdcron
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode Schedule Cron data was created in the StorageConsole database.
CRON_DAY_OF_MONTH
STRING
The day(s) of the month when the job should be run.
CRON_DAY_OF_WEEK
STRING
The day(s) in the week when the job should be run.
CRON_DAY_OF_WEEK_RAW
STRING
The day(s) in the week when the job should be run.
CRON_HOUR
STRING
The hour(s) of the day when the job should be run.
CRON_MINUTE
STRING
The minute(s) of each hour when the job should be run.
CRON_MONTH
STRING
The month(s) when the job should be run.
CRON_MONTH_RAW
STRING
The month(s) when the job should be run.
LAST_UPDATED
DATE
The date and time the NetApp Cluster Schedule Cron data was last updated in the StorageConsole database.
NTC_SCHEDULE_CRON_ID
NUMBER
Snapshot Schedule Cron ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
SNAPSHOT_JOB_SCHD_DESCRIPTION
STRING
The description of the job schedule.
SNAPSHOT_SCHEDULE_NAME
STRING
The name of the job schedule.
APS_V_ntc_snapshot_schdintvl
The aps_v_ntc_snapshot_schdintvl view contains a single row for each NetApp Cluster Snapshot Schedule Interval.
Table 4.326 aps_v_ntc_snapshot_schdintv
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode Scheduled Interval data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster Scheduled Interval data was last updated in the StorageConsole database.
NTC_SCHEDULE_INTERVAL_ID
NUMBER
Schedule Interval ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
SNAPSHOT_JOB_SCHD_DESCRIPTION
STRING
The description of the job schedule.
SNAPSHOT_JOB_SCHD_INT_DAYS
NUMBER
The number of days between jobs.
SNAPSHOT_JOB_SCHD_INT_HRS
NUMBER
The number of hours between jobs.
SNAPSHOT_JOB_SCHD_INT_MINS
NUMBER
The number of minutes between jobs.
SNAPSHOT_JOB_SCHD_INT_SECS
NUMBER
The number of seconds between jobs.
SNAPSHOT_SCHEDULE_NAME
STRING
The name of the job schedule.
APS_V_NTC_snapshot_schedule
The aps_v_ntc_snapshot_schedule view contains a single row for each NetApp Cluster Snapshot Schedule.
Table 4.327 aps_v_ntc_snapshot_schedule
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode snapshot schedule data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode schedule data was last updated in the StorageConsole database.
NBR_OF_SNAPSHOTS
NUMBER
Maximum number of snapshots that will be retained for the schedule in the snapshot policy.
NTC_SNAPSHOT_POLICY_ID
NUMBER
Snapshot Policy ID, for internal use by the StorageConsole database.
NTC_SNAPSHOT_SCHEDULE_ID
NUMBER
Snapshot Schedule ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
PREFIX
STRING
Snapshot name prefix for the schedule in the snapshot policy.
SNAPMIRROR_LABEL
STRING
Snapshot SnapMirror label for the schedule present in the snapshot policy.
SNAPSHOT_POLICY_NAME
STRING
Snapshot policy name
APS_V_NTC_storage_system
The aps_v_ntc_storage_system view contains a single row for each NetApp Cluster Storage System.
Table 4.328 aps_v_ntc_storage_system
Column Name
Data Type
Description
AGGREGATE_EXTERNAL_CAPACITY_GB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type value is not LUN.
AGGREGATE_EXTERNAL_CAPACITY_KB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type value is not LUN.
AGGREGATE_FREE_CAPACITY_GB
NUMBER
Sum of the file system available capacity of all the aggregates.
AGGREGATE_FREE_CAPACITY_KB
NUMBER
Sum of the file system available capacity of all the aggregates.
AGGREGATE_INTERNAL_CAPACITY_GB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type value is LUN.
AGGREGATE_INTERNAL_CAPACITY_KB
NUMBER
Sum of the file system total capacity of all the aggregates, when the disk type value is LUN.
AGGREGATE_USED_CAPACITY_GB
NUMBER
Sum of the file system used capacity of all the aggregates.
AGGREGATE_USED_CAPACITY_KB
NUMBER
Sum of the file system used capacity of all the aggregates.
ARRAY_NAME
STRING
Array name
BUILD_TIMESTAMP
DATE
Build creation time of the image running on the NetApp appliance; or the time of the build that has an ONTAP version that is the lowest across the cluster.
CLUSTER_CONTACT
STRING
Primary contact information for the cluster.
CLUSTER_LOCATION
STRING
User designated. Free-form field describing the releative location of the cluster in the user's environment.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode storage system data was created in the StorageConsole database.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode storage system data was last updated in the StorageConsole database.
NBR_OF_AGGREGATES
NUMBER
Number of aggregates in the cluster,
NBR_OF_CIFS_SHARES
NUMBER
Number of CIFS in the cluster.
NBR_OF_FLEX_VOLUMES
NUMBER
Number of flex volumes in the storage system.
NBR_OF_INF_VOLUMES
NUMBER
Number of infinite volumes in the storage system.
NBR_OF_NFS_EXPORTS
NUMBER
Number of NFS in the cluster.
NBR_OF_NODES
NUMBER
Number of configured nodes in the cluster.
NBR_OF_THIN_VOLUMES
NUMBER
Number of thin volumes in the storage system.
NBR_OF_VOLUMES
NUMBER
Number of volumes in the storage system.
NBR_OF_VSERVERS
NUMBER
Number of configured Vservers in the cluster.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
ONTAP_GENERATION
NUMBER
First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster.
ONTAP_MAJOR
NUMBER
Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster.
ONTAP_MINOR
NUMBER
Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster.
ONTAP_VERSION
STRING
Version of ONTAP as of the last data collection.
RDB_UUID
STRING
The 128-bit universally unique identifier for the replicated database (RDB).
VOLUME_AVAILABLE_CAPACITY_GB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_AVAILABLE_CAPACITY_KB
NUMBER
Sum of the available capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_GB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_TOTAL_CAPACITY_KB
NUMBER
Sum of the capacity of all the volumes.
VOLUME_USED_CAPACITY_GB
NUMBER
Sum of the used capacity of all the volumes.
VOLUME_USED_CAPACITY_KB
NUMBER
Sum of the used capacity of all the volumes.
APS_V_NTC_storage_adapter
The aps_v_ntc_storage_adapter view contains a single row for each NetApp Cluster Storage Adapter.
Table 4.329 aps_v_ntc_storage_adapter
Column Name
Data Type
Description
adapter_name
STRING
Storage Adapter name
array_name
STRING
Array name
creation_date
DATE
The date and time the NetApp Cluster-Mode storage adapter data was created in the StorageConsole database.
last_updated
DATE
The date and time the NetApp Cluster-Mode storage adapter data was last updated in the StorageConsole database.
node_name
STRING
Node name
node_wwn_id
NUMBER
World Wide Node Name (WWNN) of the storage adapter.
node_wwn_name
STRING
Node WWN name.
ntc_node_id
NUMBER
Node currently hosting the storage adapter.
ntc_storage_adapter_id
NUMBER
Storage adapter ID, for internal use by the StorageConsole database.
ntc_storage_system_id
NUMBER
Storage system ID, for internal use by the StorageConsole database.
port_wwn_id
NUMBER
World Wide Port Name (WWPN) of the storage adapter.
port_wwn_name
STRING
Port WWN name.
APS_V_NTC_system_prf_log
The aps_v_ntc_system_prf_log view contains a single row for each NetApp Cluster System Performance Log.
Table 4.330 aps_v_ntc_system_prf_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_PROCESSOR_BUSY_PCT
NUMBER
Average processor utilization across all processors in the system.
CPU_BUSY_PCT
NUMBER
System CPU resource utilization.
CPU_ELAPSED_TIME1_SEC
NUMBER
Elapsed time since boot.
CPU_ELAPSED_TIME2_SEC
NUMBER
Elapsed time since boot.
CPU_ELAPSED_TIME_SEC
NUMBER
Elapsed time since boot.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode system performance history data was collected.
DISK_READ_KBPS
NUMBER
Disk read rate in Kbps.
DISK_WRITE_KBPS
NUMBER
Disk write rate in Kbps.
FCP_DATA_RECV_KBPS
NUMBER
Fibre Channel Protocol (FCP) data received rate in Kbps.
FCP_DATA_SENT_KBPS
NUMBER
Fibre Channel Protocol (FCP) data sent rate in Kbps.
FCP_OPS
NUMBER
Fibre Channel Protocol (FCP) operations per second.
HDD_DISK_READ_KBPS
NUMBER
Hard disk drive (HDD) read rate in Kbps.
HDD_DISK_WRITE_KBPS
NUMBER
Hard disk drive (HDD) write rate in Kbps.
HTTP_OPS
NUMBER
HTTP operations per second.
INTERVAL_TYPE
STRING
Interval type of the system performance history collection.
ISCSI_OPS
NUMBER
iSCSI operations per second.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NBR_OF_CIFS_TOTAL_OPS
NUMBER
CIFS operations per second.
NBR_OF_PROCESSORS
NUMBER
Number of active processors in the system.
NET_DATA_RECV_KBPS
NUMBER
Network data received rate in Kbps.
NET_DATA_SENT_KBPS
NUMBER
Network data sent rate in Kbps.
NFS_OPS
NUMBER
NFS operations per second.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
Node ID, for internal use by the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
READ_OPS
NUMBER
Read operations per second.
SSD_DISK_READ_KBPS
NUMBER
Solid state drive (SSD) disks read rate in Kbps.
SSD_DISK_WRITE_KBPS
NUMBER
Solid state drive (SSD) disks write rate in Kbps.
SYS_AVG_LATENCY_MS
NUMBER
Average latency for all operations in the system in milliseconds.
SYS_READ_LATENCY_MS
NUMBER
Average latency for all read operations in the system in milliseconds.
SYS_WRITE_LATENCY_MS
NUMBER
Average latency for all write operations in the system in milliseconds.
TOTAL_OPS
NUMBER
Total operations per second.
TOTAL_PROCESSOR_BUSY_PCT
NUMBER
Total processor utilization of all processors in the system.
WRITE_OPS
NUMBER
Write operations per second.
APS_V_NTC_trgt_prt_perform_log
The aps_v_ntc_trgt_prt_perform_log view contains a single row for each NetApp Cluster Target Port Performance Log.
Table 4.331 aps_v_ntc_trgt_prt_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
BUSY_PCT
NUMBER
Percentage of time that there are commands outstanding on the indicated array target port from this controller.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster target port performance history data was collected.
EXTN_ARRAY_PROFILE_NAME
STRING
External array profile name
INTERVAL_TYPE
STRING
Target port performance history collection interval type.
LOG_DATE
DATE
Timestamp at which the performance data was collected. This is not a counter and is returned as an additional element in the output.
NTC_EXTN_ARRAY_PROFILE_ID
NUMBER
ID of the external array name in the array record.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
READ_KBPS
NUMBER
The average read throughput in K bytes per second read by this controller from the indicated array target port.
READ_LATENCY_MS
NUMBER
The average latency for I/O read operations performed by this controller on the indicated array target port.
READ_OPS
NUMBER
The number of I/O read operations per second performed by this controller on the indicated.
TOTAL_KBPS
NUMBER
The average total throughput in K bytes per second read or written by this controller to or from the indicated array target port.
TOTAL_LATENCY_MS
NUMBER
The average latency for I/O operations performed by this controller on the indicated array target port.
TOTAL_OPS
NUMBER
The total number of I/O read and write operations per second performed by this controller on the indicated array target port.
USEC_SINCE_BOOT_SEC
NUMBER
Time base for the disk-busy calculation.
WAITING_PCT
NUMBER
Percentage of time that there are commands queued waiting to be sent to the indicated array target port from this controller.
WRITE_KBPS
NUMBER
The average write throughput in K bytes per second written by this controller to the indicated array target port.
WRITE_LATENCY_MS
NUMBER
The average latency for I/O write operations performed by this controller on the indicated array target port.
WRITE_OPS
NUMBER
The number of I/O write operations per second performed by this controller on the indicated array target port.
WWN_ID
NUMBER
Internally generated sequence that identifies the World Wide Name (WWN).
WWN_NAME
STRING
WWN name
APS_V_NTC_ucm_adapter
The aps_v_ntc_ucm_adapter view contains a single row for each NetApp Cluster UCM Adapter.
Table 4.332 aps_v_ntc_ucm_adapter
Column Name
Data Type
Description
ADAPTER_NAME
STRING
The slot name of the Unified Connect Management (UCM) adapter, for example: 0e.
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode Unified Connect Management (UCM) adapter data was created in the StorageConsole database.
FC4_TYPE
STRING
The current FC-4 type of this Unified Connect Management (UCM) adapter.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode Unified Connect Management (UCM) adapter data was last updated in the StorageConsole database.
NODE_NAME
STRING
Node name
NTC_NODE_ID
NUMBER
The name of the node where the adapter is installed.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_UCM_ADAPTER_ID
NUMBER
Unified Connect Management (UCM) adapter ID, for internal use by the StorageConsole database.
PENDING_FC4_TYPE
STRING
The pending change that has been made to the FC-4 type on this Unified Connect Management (UCM) adapter, but a controller reboot is required for the change to take effect.
PENDING_MODE
STRING
The pending change that has been made to the mode on this Unified Connect Management (UCM) adapter, but a controller reboot is required for the change to take effect.
SUPPORTED_MODE
STRING
The operational mode of the Unified Connect Management (UCM) adapter.
SUPPORTED_TYPES_CNA_MODE
STRING
The FC-4 type of the Unified Connect Management (UCM) adapter for Converged Network Adapter (CNA) mode.
SUPPORTED_TYPES_FC_MODE
STRING
The FC-4 type of the Unified Connect Management (UCM) adapter for Fibre Channel (FC) mode.
UCM_ADAPTER_STATUS
STRING
The status of this Unified Connect Management (UCM) adapter.
UCM_ADAPTOR_MODE
STRING
The current mode of this Unified Connect Management (UCM) adapter.
APS_V_NTC_Vendor
The aps_v_ntc_vendor view contains a single row for each NetApp Cluster Vendor.
Table 4.333 aps_v_ntc_vendor
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AUTO_SUPPORT_EMAIL
STRING
Vendor's Auto Support email target.
AUTO_SUPPORT_URL
STRING
Vendor's Auto Support URL target.
COMPLETE_NAME
STRING
Complete name of the vendor.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode vendor data was created in the StorageConsole database.
CUSTOMER_SUPPORT_CONTACT
STRING
Vendor's technical support contact information.
CUSTOMER_SUPPORT_NAME
STRING
Name of vendor's customer support organization.
INFORMATION_URL
STRING
Vendor's AutoSupport information URL.
LAST_UPDATED
DATE
The date and time the NetApp Cluster vendor data was last updated in the StorageConsole database.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
ONTAP_OID_PREFIX
STRING
Vendor's starting SNMP OID prefix for Data ONTAP. The suffix that follows is the storage system MIB. For example, .1.3.6.1.4.1.789.
PRODUCT_URL
STRING
Vendor's installed product information URL.
SHORT_NAME
STRING
Vendor's short name.
APS_V_NTC_VOLUME
The aps_v_ntc_volume view contains a single row for each NetApp Cluster Volume.
Table 4.334 aps_v_ntc_volume
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
BLOCK_TYPE
STRING
The indirect block format of the volume.
CACHE_POLICY_NAME
STRING
Cache policy name
CLONE_PARENT_VOLUME_ID
NUMBER
User readable name for clone parent volume.
CLONE_PARENT_VOLUME_NAME
STRING
Clone parent volume ID, for internal use by the StorageConsole database.
COMMITMENT
STRING
Indicates snapshots that are allowed to be deleted to regain space.
COMPRESS_SAVED_GB
NUMBER
Total disk space (in bytes) saved by compressing blocks on the referenced file system.
COMPRESS_SAVED_KB
NUMBER
Total disk space (in bytes) saved by compressing blocks on the referenced file system.
COMPRESS_SAVED_PCT
NUMBER
Percentage of total disk space saved by compressing blocks on the referenced file system.
CONSTITUENT_ROLE
STRING
Specifies the role of a constituent within an Infinite Volume. Only supported for Infinite Volume constituents.
CREATION_DATE
DATE
Date and time the NetApp Cluster volume data was created in the StorageConsole database.
CREATION_TIME
DATE
Creation time of the volume in seconds since January 1, 1970.
DEDUP_METAFILES_GB
NUMBER
Represents space used by deduplication metafiles in bytes.
DEDUP_METAFILES_KB
NUMBER
Represents space used by deduplication metafiles in bytes.
DEDUP_METAFILES_PCT
NUMBER
Represents space used by deduplication metafiles as a percentage of volume size.
DEDUP_METAFILES_TEMP_GB
NUMBER
Represents space used by temporary deduplication metafiles in bytes.
DEDUP_METAFILES_TEMP_KB
NUMBER
Represents space used by temporary deduplication metafiles in bytes.
DEDUP_METAFILES_TEMP_PCT
NUMBER
Represents space used by temporary deduplication metafiles as a percentage of volume size.
DEDUP_SAVED_PCT
NUMBER
Percentage of total disk space saved by deduplication and file cloning.
DEDUP_SAVE_GB
NUMBER
Total disk space (in bytes) saved by deduplication and file cloning.
DEDUP_SAVE_KB
NUMBER
Total disk space (in bytes) saved by deduplication and file cloning.
DEDUP_SHARED_GB
NUMBER
Total disk space shared due to deduplication and file cloning.
DEDUP_SHARED_KB
NUMBER
Total disk space shared due to deduplication and file cloning.
DEFER_DELETE
STRING
Determines the type of snapshots to delete.
DELETE_ORDER
STRING
Indicates if the oldest or newest snapshot was deleted first.
DESTROY_LIST
STRING
List of services that can be destroyed if the snapshot is backing that service.
DS_ID
NUMBER
Indicates the Data Set ID for the volume.
ELIGIBILITY
STRING
Flash Pool caching eligibility of a volume
EXPORT_POLICY_NAME
STRING
Export policy name
EXTENT_ENABLED
STRING
Indicates if extents are enabled in the volume.
FILESYSTEM_METADATA_KB
NUMBER
Represents volume file system metadata in bytes.
FILESYSTEM_METADATA_PCT
NUMBER
Represents volume file system metadata as a percentage of volume size attributes.
FILE_SYSTEM_SIZE_GB
NUMBER
File system size (in bytes) of the volume. Total usable size of the volume, not including Write Anywhere File Layout (WAFL) reserve.
FILE_SYSTEM_SIZE_KB
NUMBER
File system size (in bytes) of the volume. Total usable size of the volume, not including Write Anywhere File Layout (WAFL) reserve.
FILL_POLICY
STRING
Fill policy name.
FRACTIONAL_RESERVE_PCT
NUMBER
Indicates the percentage of space reserved for overwrites of reserved objects (for example, files, LUNs) in a volume.
FS_ID
STRING
File System Identifier (FSID) value that serves as an internal index for a volume.
GROW_THRESHOLD_PCT
NUMBER
Used space threshold which triggers autogrow.
INCREMENT_PCT
NUMBER
Increment size computed as a percentage of the volume size at the time autosize was enabled.
INCREMENT_SIZE_GB
NUMBER
Increment size (in bytes) by which the volume is grown.
INCREMENT_SIZE_KB
NUMBER
Increment size (in bytes) by which the volume is grown.
INODES_METADATA_GB
NUMBER
Space used by inode metadata in bytes.
INODES_METADATA_KB
NUMBER
Space used by inode metadata in bytes.
INODES_METADATA_PCT
NUMBER
Space used by inode metadata as a percentage of volume size.
INSTANCE_UUID
STRING
Universally unique identifier (UUID) for the volume that remains unchanged when the volume is moved to a new location.
IS_ACCESS_TIME_UPDATE_ENABLED
STRING
Indicates the update of inode access times when a file read was prevented.
IS_AUTO_DELETE_ENABLED
STRING
Indicates if the snapshot autodelete is currently enabled for the volume. The default value is false.
IS_AUTO_SNAPSHOT_ENABLED
STRING
Indicates if automatic snapshots is enabled on the volume.The default value is true.
IS_CLUSTER_VOLUME
STRING
Indicates whether this volume is a Cluster-Mode volume, namely one that is owned by cluster authorities and agents.
IS_CONVERT_UCODE_ENABLED
STRING
Indicates if all directories in this volume were forcibly converted to Unicode format when accessed from both NFS and CIFS.
IS_CREATE_UCODE_ENABLED
STRING
Indicates if all directories in this volume were forced to use the Unicode format when they werecreated, both from NFS and CIFS.
IS_DATA_PROTECTION_MIRROR
STRING
Indicates if this is a data protection mirror.
IS_ENABLED
STRING
This element is deprecated in Data ONTAP 8.2 and later.
IS_FILE_SYSTEM_SIZE_FIXED
STRING
If true, this field causes the file system to remain the same size (and not grow) when a SnapMirror relationship is broken.
IS_FLEXCACHE_DELEG_ENABLED
STRING
Indicates if FlexCache Read Delegations are turned on for this volume.
IS_I2P_ENABLED
STRING
Indicates if native inode-to-parent information is kept for inodes. By default, this field is true.
IS_IGNORE_INCONSISTENT
STRING
Inidcates if the volume can be brought online when booting even if it is marked as inconsistent.
IS_INVALID
STRING
Indicates if this volume is invalid. Volumes typically become invalid as a result of an aborted vol copy or SnapMirror initial transfer.
IS_JUNCTION_ACTIVE
STRING
Indicates if the mounted volume is accessible. The default is true.
IS_LOAD_SHARING_MIRROR
STRING
Indicates if this is a load sharing mirror.
IS_MANAGED_BY_SERVICE
STRING
Specifies if the volume is managed by GUI services. The deafult value is false.
IS_MIN_READ_AHEAD
STRING
Indicates if the node performs minimal read-ahead for the volume.
IS_MIRROR_TRANSFER_IN_PROGRESS
STRING
Indicates if a SnapMirror transfer is in progress on this mirrored volume.
IS_MOVE_MIRROR
STRING
Indicates if this is a volume move mirror.
IS_MOVING
STRING
Indicates if the given volume is moving from one aggregate to another aggregate in the cluster.
IS_NODE_ROOT
STRING
Indicates if this volume is the root volume of the node in which it resides.
IS_NODE_ROOT_AFTER_REBOOT
STRING
Indicates if this non node-root volume has been marked as the one that will become the node root volume the next time the hosting controller is rebooted.
IS_NVFAILED_STATE
STRING
The file system will set this state on the volume if NVFAIL event occurs.
IS_NVFAIL_ENABLED
STRING
Indicates if the controller performs additional work at boot and takeover times if it finds that there has been any potential data loss in this volume due to an NVRAM failure.
IS_QUIESCED_IN_MEMORY
STRING
Indicates if the given volume is quiesced.
IS_QUIESCED_ON_DISK
STRING
Indicates if this volume is in an (on-disk) quiesced state in which most operations on the volume are blocked except for certain internal operations.
IS_REPLICA_VOLUME
STRING
Indicates if this is a read only replica volume.
IS_RESET_TO_DEFAULTS
STRING
Indicates if the values have been reset to their defaults.
IS_SIS_LOGGING_ENABLED
STRING
Indicates if Single Instance Storage (SIS) is enabled on the volume and fingerprints of newly-written data are being logged.
IS_SIS_VOLUME
STRING
Indicates if the volume contains shared (deduplication, file clones) or compressed data.
IS_SNAPDIFF_ENABLED
STRING
Indicates if SnapDiff is enabled.
IS_SNAP_CLONE_DEPEND_ENABLED
STRING
Indicates if all initial and intermediate backing snapshots are unlocked for all inactive LUN clones.
IS_SNAP_DIR_ACCESS_ENABLED
STRING
Indicates if enable the visible .snapshot directory that is normally present at system internal mount points.
IS_SPACE_GUARANTEE_ENABLED
STRING
Indicates if the storage guarantee associated with the flexible volume is currently in effect.
IS_UNRECOVERABLE
STRING
Indicates if there is known inconsistency in the associated file system and it is not recoverable. This field is valid only for flexible volumes.
IS_VOLUME_IN_CUTOVER
STRING
Indicates if this volume is moving from one aggregate to another aggregate in the cluster and is in cutover phase.
IS_VSERVER_ROOT
STRING
Indicates if this volume is the namespace root volume of the Vserver which owns this volume. The default value is false.
JUNCTION_PARENT_VOLUME_ID
NUMBER
Parent volume name that contains the junction inode of this volume.
JUNCTION_PARENT_VOLUME_NAME
STRING
Parent volume name that contains the junction inode of this volume.
JUNCTION_PATH
STRING
Junction Path at which the cluser-mode volume is mounted.
LANGUAGE
STRING
Volume's fully-qualified language mapping, in the form: LanguageCode (Full Name).
LANGUAGE_CODE
STRING
The volume's language code (e.g. 'en_US').Volume language can be specified using 'language-code' parameter.
LAST_UPDATED
DATE
Date and time the NetApp Cluster volume data was last updated in the StorageConsole database.
L_COMMENT
STRING
A description for the volume.
L_TRIGGER
STRING
Indicates the condition in which snapshots were automatically deleted.
MAX_DATA_CONSTITUENT_SIZE_GB
NUMBER
Maximum size of each data constituent in bytes.
MAX_DATA_CONSTITUENT_SIZE_KB
NUMBER
Maximum size of each data constituent in bytes.
MAX_DIR_SIZE_GB
NUMBER
Maximum size (in bytes) to which any directory in this volume can grow.
MAX_DIR_SIZE_KB
NUMBER
Maximum size (in bytes) to which any directory in this volume can grow.
MAX_NAMESPACE_CONSTITUENT_GB
NUMBER
Maximum size of the namespace constituent. The default value is 10TB.
MAX_NAMESPACE_CONSTITUENT_KB
NUMBER
Maximum size of the namespace constituent. The default value is 10TB.
MAX_SIZE_GB
NUMBER
The maximum size (in bytes) to which the volume would be grown automatically.
MAX_SIZE_KB
NUMBER
The maximum size (in bytes) to which the volume would be grown automatically.
MAX_WRITE_ALLOC_BLOCKS
NUMBER
The maximum number of blocks used for write allocation.
MIN_RESERVE_GB
NUMBER
Amount of space requested to be preallocated in the aggregate hosting the FlexCache volume.
MIN_RESERVE_KB
NUMBER
Amount of space requested to be preallocated in the aggregate hosting the FlexCache volume.
MIN_SIZE_GB
NUMBER
Minimum size (in bytes) below which the volume would not be shrunk automatically.
MIN_SIZE_KB
NUMBER
Minimum size (in bytes) below which the volume would not be shrunk automatically.
MS_ID
NUMBER
Mirror Set ID for the Cluster-Mode volume.
NAMESPACE_MIRROR_AGGR_LIST
STRING
Specifies the list of names of aggregates to be used for Infinite Volume Namespace Mirror constituents.
NAME_ORDINAL
STRING
Ordinal assignment used in relation to this volume's name.
NBR_OF_CIFS_SHARES
NUMBER
Number of CIFS shares in the volume.
NBR_OF_CLONE_CHILD
NUMBER
Number of clones for which this volume is the parent.
NBR_OF_INDOES_USER_FILES
NUMBER
Number of inodes that can currently be stored on disk for user-visible files.
NBR_OF_INODES_SYSTEM_FILES
NUMBER
Number of inodes that can currently be stored on disk for system (not user-visible) files.
NBR_OF_LUNS
NUMBER
Number of LUNs in the volume.
NBR_OF_NFS_EXPORTS
NUMBER
Number of NFS exports in the volume.
NBR_OF_QtreeS
NUMBER
Number of Qtrees in the volume.
NBR_OF_SNAPSHOT
NUMBER
Number of Snapshot copies in the volume.
NBR_OF_SNAPSHOTS
NUMBER
Number of snapshots in the volume.
NBR_OF_SYSTEM_FILES_USED
NUMBER
Number of system (not user-visible) files (inodes) used. This field is valid only when the volume is online.
NBR_OF_USER_FILES
NUMBER
Total user-visible file (inode) count.
NBR_OF_USER_FILES_USED
NUMBER
Number of user-visible files (inodes) used.
NFS_CHARACTER_SET
STRING
NFS character set.
NTC_AGGREGATE_ID
NUMBER
Name of the aggregate in which the given flexible volume resides.
NTC_CACHE_POLICY_ID
NUMBER
Name of the cache policy.
NTC_EXPORT_POLICY_ID
NUMBER
Name of export policy to be used by NFS/CIFS protocols.
NTC_SNAPSHOT_POLICY_ID
NUMBER
Name of the snapshot policy.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume for which the space usage is requested
NTC_VSERVER_ID
NUMBER
The name of the Vserver that owns this volume.
OEM_CHARACTER_SET
STRING
The OEM language mapping character set that is currently in effect for the volume.
ORIGIN_VOLUME_ID
NUMBER
Name of the origin volume that contains the authoritative data.
OVERWRITE_RESERVE_GB
NUMBER
Size (in bytes) that is reserved for overwriting snapshotted data in an otherwise full volume.
OVERWRITE_RESERVE_KB
NUMBER
Size (in bytes) that is reserved for overwriting snapshotted data in an otherwise full volume.
OVERWRITE_RESERVE_REQUIRED_GB
NUMBER
Reserved size (in bytes) that is required to ensure that the reserved space is sufficient to allow all space-reserved files and LUNs to be overwritten when the volume is full.
OVERWRITE_RESERVE_REQUIRED_KB
NUMBER
Reserved size (in bytes) that is required to ensure that the reserved space is sufficient to allow all space-reserved files and LUNs to be overwritten when the volume is full.
OVERWRITE_RESERVE_USED_ACT_GB
NUMBER
This value can exceed the value of overwrite reserve required, as the filer maintains a small hidden reserve.
OVERWRITE_RESERVE_USED_ACT_KB
NUMBER
This value can exceed the value of overwrite reserve required, as the filer maintains a small hidden reserve.
OVERWRITE_RESERVE_USED_GB
NUMBER
The reserved size (in bytes) that is not available for new overwrites.
OVERWRITE_RESERVE_USED_KB
NUMBER
The reserved size (in bytes) that is not available for new overwrites.
PREFIX
STRING
Provides the prefix string for the prefix field value of the defer-delete option.
PROVENANCE_UUID
STRING
Universally unique identifier (UUID) for the volume, used to identify the source volume in a mirroring relationship.
QOS_POLICY_GROUP_NAME
STRING
QoS policy group associated with this volume.
QUOTA_METAFILES_PCT
NUMBER
Space used by quota metafiles, as a percentage of the volume size.
READ_REALLOC
STRING
Controls whether application reads optimize the layout of parts of a file or LUN, after the data has been read from disk and is in the controller's memory.
REDIRECT_SNAPSHOT_ID
NUMBER
If the volume is a logical mirror destination or is in the process of being made one, this field indicates the logical-id of the snapshot to which clients are to be redirected.
ROOT_DIR_GEN_NBR
STRING
Generation number of the root directory.
SHRINK_THRESHOLD_PCT
NUMBER
Used space threshold below which autoshrink is triggered.
SIZE_AVAILABLE_GB
NUMBER
Size (in bytes) that is still available in the volume.
SIZE_AVAILABLE_KB
NUMBER
Size (in bytes) that is still available in the volume.
SIZE_AVAILABLE_SNAPSHOTS_GB
NUMBER
Total free space (in bytes) available in the volume and the snapshot reserve.
SIZE_AVAILABLE_SNAPSHOTS_KB
NUMBER
Total free space (in bytes) available in the volume and the snapshot reserve.
SIZE_GB
NUMBER
File system size (in bytes) of the volume.
SIZE_KB
NUMBER
File system size (in bytes) of the volume.
SIZE_TOTAL_GB
NUMBER
Total usable size (in bytes) of the volume, not including Write Anywhere File Layout (WAFL) reserve or volume snapshot reserve.
SIZE_TOTAL_KB
NUMBER
Total usable size (in bytes) of the volume, not including Write Anywhere File Layout (WAFL) reserve or volume snapshot reserve.
SIZE_USED_GB
NUMBER
Size (in bytes) that is used in the volume.
SIZE_USED_KB
NUMBER
Size (in bytes) that is used in the volume.
SIZE_USED_PCT
NUMBER
Percentage of the volume size that is used.
SIZE_USED_SNAPSHOTS_GB
NUMBER
Size (in bytes) that is used by snapshots in the volume.
SIZE_USED_SNAPSHOTS_KB
NUMBER
Size (in bytes) that is used by snapshots in the volume.
SNAPMIRROR_METADATA_GB
NUMBER
Space used by metafiles during SnapMirror operations, in bytes.
SNAPMIRROR_METADATA_KB
NUMBER
Space used by metafiles during SnapMirror operations, in bytes.
SNAPMIRROR_METADATA_PCT
NUMBER
Space used by metafiles during SnapMirror operations, as a percentage of the volume size.
SNAPSHOT_POLICY_NAME
STRING
Snapshot policy name
SNAPSHOT_RESERVE_GB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_KB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_PCT
NUMBER
Snapshot reserve as a percentage of the volume size.
SNAPSHOT_RESERVE_SIZE_GB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_SIZE_KB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_USED_PCT
NUMBER
Percentage of the volume reserved for snapshots that has been used.
SNAPSHOT_SPILL_GB
NUMBER
Space used by Snapshot copies when it exceeds the size of the Snapshot reserve in bytes.
SNAPSHOT_SPILL_KB
NUMBER
Space used by Snapshot copies when it exceeds the size of the Snapshot reserve in bytes.
SNAPSHOT_SPILL_PCT
NUMBER
Snapshot spill as a percentage of the volume size.
SPACE_FULL_THRESHOLD_PCT
NUMBER
Defines the used space threshold percentage at which EMS critical volume fullness errors will be generated. The default value is 98%.
SPACE_GUARANTEE
STRING
Storage guarantee option associated with the flexible volume.
SPACE_NEAR_FULL_THRESHOLD_PCT
NUMBER
Defines the used space threshold percentage at which EMS volume fullness warnings will be generated.
STORAGE_SERVICE_NAME
STRING
Name of the initial storage service for the Infinite Volume.
STYLE
STRING
Security style associated with this volume.
TAPE_BACKUP_METADATA_GB
NUMBER
Tape backup metadata in bytes.
TAPE_BACKUP_METADATA_KB
NUMBER
Tape backup metadata in bytes.
TAPE_BACKUP_METADATA_PCT
NUMBER
Tape backup metadata as a percentage of the volume size.
TARGET_FREE_SPACE_PCT
NUMBER
Indicates when snapshot autodelete should stop deleting snapshots.
TOTAL_SAVED_GB
NUMBER
Total space saved (in bytes) in the volume due to deduplication, compression, and file cloning.
TOTAL_SAVED_KB
NUMBER
Total space saved (in bytes) in the volume due to deduplication, compression, and file cloning.
TOTAL_SAVED_PCT
NUMBER
Percentage of total disk space that is saved by compressing blocks, deduplication and file cloning.
TOTAL_USED_GB
NUMBER
Total used space in the volume including snapshot reserve in bytes.
TOTAL_USED_KB
NUMBER
Total used space in the volume including snapshot reserve in bytes.
TOTAL_USED_PCT
NUMBER
Total used space in the volume including snapshot reserve as a percentage of the volume size.
UNIX_GROUP_ID
NUMBER
The Unix group ID for the volume. The default value is 0 (root).
UNIX_PERMISSIONS
STRING
Unix permission bits in octal string format.
UNIX_USER_ID
NUMBER
The Unix user ID for the volume. The default value is 0 (root).
USER_DATA_GB
NUMBER
This field represents user data in bytes. Alternatively, this is the space reserved to overwrite the data in the volume.
USER_DATA_KB
NUMBER
This field represents user data in bytes. Alternatively, this is the space reserved to overwrite the data in the volume.
USER_DATA_PCT
NUMBER
User data as a percentage of the volume size.
VM_ALIGN_SECTOR
NUMBER
The Virtual Machine alignment 512-byte sector number.
VM_ALIGN_SUFFIX
STRING
The Virtual Machine alignment suffix.
VOLUME_MODE
STRING
Current mode of the operation of volume autosize.
VOLUME_NAME
STRING
Volume name
VOLUME_STATE
STRING
Volume state.
VOLUME_STYLE
STRING
The style of the volume.
VOLUME_TYPE
STRING
The type of the volume.
VOLUME_UUID
STRING
Universally unique identifier (UUID) for this volume.
VSERVER_NAME
STRING
Vserver name
WRITECACHE_INELIGIBLITY_REASON
STRING
If the volume cannot participate in write caching, then this field explains the reason.
APS_V_NTC_VOLUME_clone
The aps_v_ntc_volume_clone view contains a single row for each NetApp Cluster Volume Clone.
aps_v_ntc_volume_clone
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
ARRAY_NAME
STRING
Array name
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode volume clone data was created in the StorageConsole database.
DS_ID
NUMBER
Data set ID of the FlexClone volume.
FLEXCLONE_VOLUME_STATE
STRING
FlexClone volume state.
INODE_COMPLETE_PCT
NUMBER
Percentage of Inode processing complete.
IS_JUNCTION_ACTIVE
STRING
Indicates if the volume's junction path is active.
IS_SPACE_GUARANTEE_ENABLED
STRING
Indicates if a space guarantee is in effect.
JUNCTION_PATH
STRING
The junction path at which the new FlexClone clone volume should be mounted.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode volume clone data was last updated in the StorageConsole database.
MS_ID
NUMBER
Master Data Set ID of FlexClone volume
NBR_OF_PROCESSED_INODES
NUMBER
Total Inodes to be processed during clone splitting.
NBR_OF_TOTAL_INODES
NUMBER
Total Inodes to be processed during clone splitting.
NTC_AGGREGATE_ID
NUMBER
Aggregate containing the FlexClone volume.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_CLONE_ID
NUMBER
Volume Clone ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
The name of the volume.
NTC_VSERVER_ID
NUMBER
The name of the vServer.
PARENT_SNAPSHOT
STRING
The name of the parent snapshot from which the FlexClone clone volume is derived.
PARENT_VOLUME_ID
NUMBER
The name of parent volume from which the FlexClone clone volume is derived.
PARENT_VOLUME_NAME
STRING
Parent volume name.
QOS_POLICY_GROUP_NAME
STRING
QoS policy group assigned to the FlexClone volume.
SCANNED_BLOCKS
NUMBER
Total number of blocks scanned for clone splitting.
SPACE_RESERVE
STRING
Space-reservation policy.
SPLIT_ESTIMATE_GB
NUMBER
Estimate of free disk space required to split a FlexClone volume from a parent volume.
SPLIT_ESTIMATE_KB
NUMBER
Estimate of free disk space required to split a FlexClone volume from a parent volume.
TOTAL_SIZE_GB
NUMBER
Total size of FlexClone volume.
TOTAL_SIZE_KB
NUMBER
Total size of FlexClone volume.
UPDATED_BLOCKS
NUMBER
Total number of blocks updated for clone splitting.
USED_SIZE_GB
NUMBER
Information about the amount of used space.
USED_SIZE_KB
NUMBER
Information about the amount of used space.
VOLUME_NAME
STRING
Volume name
VOLUME_TYPE
STRING
Type of the volume to be created.
VSERVER_NAME
STRING
Vserver name
APS_V_NTC_VOLUME_log
The aps_v_ntc_volume_log view contains a single row for each NetApp Cluster Volume Log.
aps_v_ntc_volume_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
COMPRESS_SAVED_GB
NUMBER
Total disk space (in bytes) saved by compressing blocks on the referenced file system.
COMPRESS_SAVED_KB
NUMBER
Total disk space (in bytes) saved by compressing blocks on the referenced file system.
DEDUP_METAFILES_GB
NUMBER
Represents space used by deduplication metafiles in bytes.
DEDUP_METAFILES_KB
NUMBER
Represents space used by deduplication metafiles in bytes.
DEDUP_METAFILES_TEMP_GB
NUMBER
Represents space used by temporary deduplication metafiles in bytes.
DEDUP_METAFILES_TEMP_KB
NUMBER
Represents space used by temporary deduplication metafiles in bytes.
DEDUP_SAVE_GB
NUMBER
Total disk space (in bytes) saved by deduplication and file cloning.
DEDUP_SAVE_KB
NUMBER
Total disk space (in bytes) saved by deduplication and file cloning.
DEDUP_SHARED_GB
NUMBER
Total disk space shared due to deduplication and file cloning.
DEDUP_SHARED_KB
NUMBER
Total disk space shared due to deduplication and file cloning.
FILESYSTEM_METADATA_GB
NUMBER
Represents volume file system metadata in bytes.
FILESYSTEM_METADATA_KB
NUMBER
Represents volume file system metadata in bytes.
FILE_SYSTEM_SIZE_GB
NUMBER
File system size (in bytes) of the volume. This is the total usable size of the volume, not including WAFL (write anywhere fle layout) reserve.
FILE_SYSTEM_SIZE_KB
NUMBER
File system size (in bytes) of the volume. This is the total usable size of the volume, not including WAFL (write anywhere fle layout) reserve.
INCREMENT_SIZE_GB
NUMBER
Increment size (in bytes) by which the volume is grown.
INCREMENT_SIZE_KB
NUMBER
Increment size (in bytes) by which the volume is grown.
INODES_METADATA_GB
NUMBER
Space used by inode metadata in bytes.
INODES_METADATA_KB
NUMBER
Space used by inode metadata in bytes.
LOG_DATE
DATE
The date and time the volume history samples were collected. For NetApp Cluster, this is set to the start of the performance collection for all samples.
MAX_DATA_CONSTITUENT_SIZE_GB
NUMBER
Maximum size of each data constituent in bytes.
MAX_DATA_CONSTITUENT_SIZE_KB
NUMBER
Maximum size of each data constituent in bytes.
MAX_DIR_SIZE_GB
NUMBER
Maximum size (in bytes) to which any directory in this volume can grow.
MAX_DIR_SIZE_KB
NUMBER
Maximum size (in bytes) to which any directory in this volume can grow.
MAX_NAMESPACE_CONSTITUENT_GB
NUMBER
Maximum size of the namespace constituent. The default value is 10TB.
MAX_NAMESPACE_CONSTITUENT_KB
NUMBER
Maximum size of the namespace constituent. The default value is 10TB.
MAX_SIZE_GB
NUMBER
The maximum size (in bytes) to which the volume would be grown automatically.
MAX_SIZE_KB
NUMBER
The maximum size (in bytes) to which the volume would be grown automatically.
MIN_RESERVE_GB
NUMBER
Amount of space requested to be preallocated in the aggregate hosting the FlexCache volume.
MIN_RESERVE_KB
NUMBER
Amount of space requested to be preallocated in the aggregate hosting the FlexCache volume.
MIN_SIZE_GB
NUMBER
Minimum size (in bytes) below which the volume would not be shrunk automatically.
MIN_SIZE_KB
NUMBER
Minimum size (in bytes) below which the volume would not be shrunk automatically.
NBR_OF_CIFS_SHARES
NUMBER
Number of CIFS shares in the volume.
NBR_OF_CLONE_CHILD
NUMBER
Number of clones for which this volume is the parent.
NBR_OF_INDOES_USER_FILES
NUMBER
Number of inodes that can currently be stored on disk for user-visible files.
NBR_OF_INODES_SYSTEM_FILES
NUMBER
Number of inodes that can currently be stored on disk for system (not user-visible) files.
NBR_OF_LUNS
NUMBER
Number of LUNs in the volume.
NBR_OF_NFS_EXPORTS
NUMBER
Number of NFS exports in the volume.
NBR_OF_QtreeS
NUMBER
Number of Qtrees in the volume.
NBR_OF_SNAPSHOT
NUMBER
Number of Snapshot copies in the volume.
NBR_OF_SNAPSHOTS
NUMBER
Number of snapshots in the volume.
NBR_OF_SYSTEM_FILES_USED
NUMBER
Number of system (not user-visible) files (inodes) used. This field is valid only when the volume is online.
NBR_OF_USER_FILES
NUMBER
Number of user-visible files (inodes) used.
NBR_OF_USER_FILES_USED
NUMBER
Number of user-visible files (inodes) used.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the volume for which the space usage is requested
OVERWRITE_RESERVE_GB
NUMBER
Size (in bytes) that is reserved for overwriting snapshotted data in an otherwise full volume.
OVERWRITE_RESERVE_KB
NUMBER
Size (in bytes) that is reserved for overwriting snapshotted data in an otherwise full volume.
OVERWRITE_RESERVE_REQUIRED_GB
NUMBER
Reserved size (in bytes) that is required to ensure that the reserved space is sufficient to allow all space-reserved files and LUNs to be overwritten when the volume is full.
OVERWRITE_RESERVE_REQUIRED_KB
NUMBER
Reserved size (in bytes) that is required to ensure that the reserved space is sufficient to allow all space-reserved files and LUNs to be overwritten when the volume is full.
OVERWRITE_RESERVE_USED_ACT_GB
NUMBER
This value can exceed the value of overwrite reserve required, as the filer maintains a small hidden reserve.
OVERWRITE_RESERVE_USED_ACT_KB
NUMBER
This value can exceed the value of overwrite reserve required, as the filer maintains a small hidden reserve.
OVERWRITE_RESERVE_USED_GB
NUMBER
The reserved size (in bytes) that is not available for new overwrites.
OVERWRITE_RESERVE_USED_KB
NUMBER
The reserved size (in bytes) that is not available for new overwrites.
SIZE_AVAILABLE_GB
NUMBER
Size (in bytes) that is still available in the volume.
SIZE_AVAILABLE_KB
NUMBER
Size (in bytes) that is still available in the volume.
SIZE_AVAILABLE_SNAPSHOTS_GB
NUMBER
Total free space (in bytes) available in the volume and the snapshot reserve.
SIZE_AVAILABLE_SNAPSHOTS_KB
NUMBER
Total free space (in bytes) available in the volume and the snapshot reserve.
SIZE_GB
NUMBER
File system size (in bytes) of the volume.
SIZE_KB
NUMBER
File system size (in bytes) of the volume.
SIZE_TOTAL_GB
NUMBER
Total usable size (in bytes) of the volume, not including WAFL (write anywhere fle layout) reserve or volume snapshot reserve.
SIZE_TOTAL_KB
NUMBER
Total usable size (in bytes) of the volume, not including WAFL (write anywhere fle layout) reserve or volume snapshot reserve.
SIZE_USED_GB
NUMBER
Size (in bytes) that is used in the volume.
SIZE_USED_KB
NUMBER
Size (in bytes) that is used in the volume.
SIZE_USED_SNAPSHOTS_GB
NUMBER
Size (in bytes) that is used by snapshots in the volume.
SIZE_USED_SNAPSHOTS_KB
NUMBER
Size (in bytes) that is used by snapshots in the volume.
SNAPMIRROR_METADATA_GB
NUMBER
Space used by metafiles during SnapMirror operations, in bytes.
SNAPMIRROR_METADATA_KB
NUMBER
Space used by metafiles during SnapMirror operations, in bytes.
SNAPSHOT_RESERVE_GB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_KB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_SIZE_GB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_RESERVE_SIZE_KB
NUMBER
Size (in bytes) in the volume that has been set aside as reserve for snapshot usage.
SNAPSHOT_SPILL_GB
NUMBER
Space used by Snapshot copies when it exceeds the size of the Snapshot reserve in bytes.
SNAPSHOT_SPILL_KB
NUMBER
Space used by Snapshot copies when it exceeds the size of the Snapshot reserve in bytes.
TAPE_BACKUP_METADATA_GB
NUMBER
Tape backup metadata in bytes.
TAPE_BACKUP_METADATA_KB
NUMBER
Tape backup metadata in bytes.
TOTAL_SAVED_GB
NUMBER
Total space saved (in bytes) in the volume due to deduplication, compression, and file cloning.
TOTAL_SAVED_KB
NUMBER
Total space saved (in bytes) in the volume due to deduplication, compression, and file cloning.
TOTAL_USED_GB
NUMBER
Total used space in the volume including snapshot reserve in bytes.
TOTAL_USED_KB
NUMBER
Total used space in the volume including snapshot reserve in bytes.
USER_DATA_GB
NUMBER
This field represents user data in bytes. Alternatively, this is the space reserved to overwrite the data in the volume.
USER_DATA_KB
NUMBER
This field represents user data in bytes. Alternatively, this is the space reserved to overwrite the data in the volume.
VOLUME_NAME
STRING
Volume name
APS_V_NTC_VOLUME_move
The aps_v_ntc_volume_move view contains a single row for each NetApp Cluster Volume Move.
aps_v_ntc_volume_move
Column Name
Data Type
Description
 
 
 
ACTUAL_COMPLETE_TIMESTAMP
DATE
The date and time in the cluster's time zone when the volume move completed (successfully or otherwise).
ACTUAL_DURATION
DATE
Duration in days, hours, minutes and seconds for which the volume move was or is in progress.
ARRAY_NAME
STRING
Array name
COMPLETE_PCT
NUMBER
Amount of work to move the volume completed thus far in terms of percentage.
COMPLETION_CODE
NUMBER
Status code of the move operation. The status code will be 0 while the job is running or is successful.
COMPLETION_STATUS
STRING
Once a volume move is complete, the final state of the volume move operation. This is available in diag mode only.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode volume move data was created in the StorageConsole database.
CUTOVER_ACTION
STRING
Action to be taken for cutover or during cutover failure.
CUTOVER_TRIGGER_TIMESTAMP
DATE
Time when move operation last accepted a trigger to initiate cutover.
CUTOVER_WINDOW_SEC
NUMBER
Time window, in seconds, given as input for the cutover phase of volume move.
DESTINATION_AGGREGATE_ID
NUMBER
Name of the aggregate where the volume is being moved.
DESTINATION_AGGREGATE_NAME
STRING
Name of the aggregate where the volume is being moved.
DESTINATION_NODE_ID
NUMBER
Name of the node where the destination aggregate is. This will be a diagnostic only field.
DESTINATION_NODE_NAME
STRING
The name of the node where the destination aggregate is located.
ESTIMATED_COMPLETE_TIME
DATE
Approximate date and time in the cluster's time zone when the entire volume move operation is expected to complete.
ESTIMATED_REMAINING_DURATION
DATE
The approximate amount of time remaining to complete the volume move (in days, hours, minutes and seconds).
EXECUTION_PROGRESS
STRING
Progress of the job as reported by the job.
INTERNAL_STATE
STRING
Actual internal state of the move job.
JOB_ID
NUMBER
Job ID of the move job.
JOB_UUID
STRING
Universally unique identifier (UUID) of the move job.
LAST_CUTOVER_TRIGGER_TIMESTAMP
DATE
The time when move the operation initiated cutover.
LAST_UPDATED
DATE
The date and time the NetApp Cluster-Mode volume move data was last updated in the StorageConsole database.
MANAGING_NODE_ID
NUMBER
Node in the cluster on which the move operation or job is/was running.
MANAGING_NODE_NAME
STRING
Managing node name
MAX_OF_CUTOVER_ATTEMPTS
NUMBER
Number of attempts to be used by the move operation to cutover to the destination volume.
MOVER_OPERATION_PHASE
STRING
The phase of the move operation.
MOVE_OPERATION_DETAILS
STRING
Details about any warnings, errors, and the state of the move operation.
NBR_OF_CUTOVER_ATTEMPTED
NUMBER
Number of times cutover has been attempted during the move operation.
NBR_OF_CUTOVER_HARD_DEFERRED
NUMBER
Number of times cutover has been hard-deferred during the move operation due to non-transient conditions that required interventions.
NBR_OF_CUTOVER_SOFT_DEFERRED
NUMBER
Number of times cutover has been soft-deferred during the move operation, due to transient conditions.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Name of the Vserver-scoped volume being moved.
NTC_VSERVER_ID
NUMBER
Name of the Vserver associated with the volume being moved.
PRIOR_ISSUES
STRING
The list of issues or transient errors encountered causing the move operation to retry the data copy phase or the cutover phase.
REMAINING_GB
NUMBER
The number of bytes remaining to be sent during volume move.
REMAINING_KB
NUMBER
The number of bytes remaining to be sent during volume move.
REPLICATION_THROUGHPUT
STRING
The current replication throughput of the move operation in Kb/s, Mb/s or Gb/s.
SENT_GB
NUMBER
The number of bytes sent thus far as part of a volume move.
SENT_KB
NUMBER
The number of bytes sent thus far as part of a volume move.
SOURCE_AGGREGATE_ID
NUMBER
Name of the aggregate where the volume being moved resides or originally resided.
SOURCE_AGGREGATE_NAME
STRING
Name of the aggregate where the volume being moved resides or originally resided.
SOURCE_NODE_ID
NUMBER
Name of the node where the source aggregate is located.
SOURCE_NODE_NAME
STRING
Name of the node where the source aggregate is located.
START_TIMESTAMP
DATE
The date and time in cluster's time zone when the volume move started.
VOLUME_MOVE_STATE
STRING
The state of the volume move at the time of issuing the command and the system gathering up the information about the move.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
APS_V_NTC_VOLUME_PERFORM_LOG
The aps_v_ntc_volume_perform_log view contains a single row for each NetApp Cluster Volume Performance Log.
Table 4.335 aps_v_ntc_volume_perform_log
Column Name
Data Type
Description
ARRAY_NAME
STRING
Array name
AVG_LATENCY_MS
NUMBER
Average latency in microseconds for the WAFL (Write Anywhere File Layout) file system to process all the operations on the volume; not including request processing or network communication time.
AVG_OTHER_LATENCY_MS
NUMBER
Average latency in microseconds for the WAFL (Write Anywhere File Layout) file system to process other operations to the volume; does not include request processing or network communication time.
CUM_INTERVAL_SEC
NUMBER
Time interval, in seconds, for which the NetApp Cluster-Mode volume performance history data was collected.
INTERVAL_TYPE
STRING
Interval type of the volume performance history collection.
LOG_DATE
DATE
Timestamp at which the performance data was collected.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VOLUME_ID
NUMBER
Instance name
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
OTHER_OPS
NUMBER
Number of other operations per second to the volume.
READ_BPS
NUMBER
Bytes read per second from the volume.
READ_LATENCY_MS
NUMBER
Average latency in microseconds for the WAFL (Write Anywhere File Layout) file system to process read requests.
READ_OPS
NUMBER
Number of reads per second to the volume
TOTAL_OPS
NUMBER
Number of operations per second serviced by the volume.
VOLUME_NAME
STRING
Volume name
VSERVER_NAME
STRING
Vserver name
WRITE_BPS
NUMBER
Bytes written per second to the volume.
WRITE_LATENCY_MS
NUMBER
Average latency in microseconds for the WAFL (Write Anywhere File Layout) file system to process write request to the volume; not including request processing or network communication time.
WRITE_OPS
NUMBER
Number of writes per second to the volume.
APS_V_NTC_Vserver
The aps_v_ntc_vserver view contains a single row for each NetApp Cluster Vserver.
Table 4.336 aps_v_ntc_vserver
Column Name
Data Type
Description
ALLOWED_PROTOCOLS
STRING
Vserver protocols.
ANTIVIRUS_ON_ACCESS_POLICY
STRING
Antivirus on access policy for the Vserver.
ARRAY_NAME
STRING
Array name
ARRAY_PORT_ID
NUMBER
Name of the port.
CREATION_DATE
DATE
The date and time the NetApp Cluster-Mode Vserver data was created in the StorageConsole database.
DISALLOWED_PROTOCOLS
STRING
Protocols not allowed for this Vserver.
ISCSI_TARGET_ALIAS_NAME
STRING
The iSCSI target alias of the Vserver.
IS_ISCSI_SERVICE_RUNNING
STRING
True if the iSCSI Service is running, false otherwise.
IS_REPOSITORY_VSERVER
STRING
Specifies if this Vserver is a Vserver with Infinite Volume.
LANGUAGE
STRING
Language to use for the Vserver. Default: C.UTF-8.
LAST_UPDATED
DATE
The date and time the NetApp Cluster Vserver data was last updated in the StorageConsole database.
LDAP_DOMAIN
STRING
LDAP client configuration details.
MAX_VOLUMES
STRING
Maximum number of volumes that can be created on the Vserver.
NAME_MAPPING_SWITCH
STRING
Name mapping switch configuration details for the Vserver.
NAME_SERVER_SWITCH
STRING
Name server switch configuration details for the Vserver.
NIS_DOMAIN
STRING
NIS domain configuration details for the Vserver.
NTC_STORAGE_SYSTEM_ID
NUMBER
Storage system ID, for internal use by the StorageConsole database.
NTC_VSERVER_ID
NUMBER
Vserver ID, for internal use by the StorageConsole database.
PORT_NAME
STRING
Port name
QOS_POLICY_GROUP
STRING
The QoS policy group associated with this volume. This optionally specifies which QoS policy group to apply to the Vserver.
QUOTA_POLICY
STRING
Quota policy for the Vserver.
ROOT_VOLUME_AGGREGATE_ID
NUMBER
The aggregate on which the root volume will be created.
ROOT_VOLUME_AGGREGATE_NAME
STRING
Root volume aggregate name
ROOT_VOLUME_ID
NUMBER
Root Volume ID, for internal use by the StorageConsole database.
ROOT_VOLUME_NAME
STRING
Root volume of the Vserver.
ROOT_VOLUME_SECURITY_STYLE
STRING
Security style of the root volume.
SNAPSHOT_POLICY
STRING
Default snapshot policy setting for all volumes of the Vserver.
VSERVER_COMMENT
STRING
Comments associated with the Vserver.
VSERVER_NAME
STRING
Vserver name
VSERVER_STATE
STRING
State of the Vserver. Indicates the data-serving ability of a Vserver; therefore it is applicable only for Data Vservers.
VSERVER_TYPE
STRING
Type of Vserver.
VSERVER_UUID
STRING
Universal unique identifier (UUID) for the Vserver.