Capacity Manager Database Views > NetApp Cluster-Mode Database Views
  
Version 10.1.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 332 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 333 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 334 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 335 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 336 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 337 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 338 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 339 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 340 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 341 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 342 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 343 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 344 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 345 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 346 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 347 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 348 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 349 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 350 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 351 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 352 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 353 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