Capacity Manager Database Views > NetApp Storage Systems Database Views
  
Version 10.0.01
NetApp Storage Systems Database Views
aps_v_nap_aggregate
The aps_v_nap_aggregate view provides NetApp aggregate details.
Table 4.304 aps_v_nap_aggregate
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
AGGREGATE_STATE
STRING
Aggregate state
AGGREGATE_TYPE
STRING
Aggregate type
AGGREGATE_UUID
STRING
Aggregate UUID
AVAILABLE_SIZE_gb
NUMBER
Available storage in GiB
AVAILABLE_SIZE_KB
NUMBER
Available storage in KiB
CHECK_SUM_STATUS
STRING
Checksum status
CHECK_SUM_STYLE
STRING
Checksum style
DISK_COUNT
NUMBER
Number of disks
FILES_TOTAL
NUMBER
Calculated total of files
FILES_USED
NUMBER
Files used
IS_CHECKSUM_ENABLED
STRING
Status of checksum: Y or N
IS_INCONSITENT
STRING
Inconsistent flag: Y or N
IS_SNAP_LOCK
STRING
Snap Lock flag: Y or N
LAST_UPDATED
DATE
Date last updated
MIRROR_STATUS
STRING
Mirror status description
NAP_AGGREGATE_ID
NUMBER
Aggregate ID
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID
PCT_USED
NUMBER
Percentage used
PLEX_COUNT
NUMBER
Number of Plexes
RAID_SIZE_gb
NUMBER
RAID size in GiB
RAID_SIZE_KB
NUMBER
RAID size in KiB
RAID_STATUS
STRING
RAID status
SNAPLOCK_TYPE
STRING
Snap Lock type
SYSTEM_NAME
STRING
NetApp system name
TOTAL_SIZE_gb
NUMBER
Total size of the aggregate in GiB
TOTAL_SIZE_KB
NUMBER
Total size of the aggregate in KiB
USED_SIZE_gb
NUMBER
Amount of aggregate used in GiB
USED_SIZE_KB
NUMBER
Amount of aggregate used in KiB
aps_v_nap_cifs_share
The aps_v_nap_cifs_share view contains a single row for CIFS shares
Table 4.305 aps_v_nap_cifs_share
Column Name
Data Type
Description
aggregate_name
STRING
Aggregate name
available_gb
NUMBER
CIFS available size in GiB
cifs_share_name
STRING
CIFS share name
description
STRING
Description of the share
force_group
STRING
Name of the group to which files to be created in the share belong to
host_id
NUMBER
Foreign key to host details
host_mount_point
STRING
Host mount point for CIFS
host_name
STRING
The hostname of the client/server
is_volume_offline
STRING
Y=Yes, N=No. If Yes, volume is offline and the shares are not available.
mount_point
STRING
Mount point of the share
nap_aggregate_id
NUMBER
Aggregate ID
nap_cifs_share_id
NUMBER
Foreign key to CIFS share details
nap_Qtree_id
NUMBER
Foreign key to Qtree details for NFS
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
nap_volume_id
NUMBER
Volume ID
nbr_max_user
NUMBER
Maximum number of simultaneous connections to the share
parent_storage_system_id
NUMBER
Parent Storage system Id (internal)
parent_system_name
STRING
Parent System Name
Qtree_name
STRING
Qtree name for NFS
storage_list
STRING
List of storage array id and name
SYSTEM_NAME
STRING
NetApp system name
total_gb
NUMBER
CIFS total size in GiB
used_gb
NUMBER
CIFS allocated size in GiB
volume_name
STRING
Volume name
aps_v_nap_disk
The aps_v_nap_disk view provides NetApp disk details.
Table 4.306 aps_v_nap_disk
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
BAY
STRING
Bay name
BLOCKS_READ
NUMBER
Blocks read
BLOCKS_WRITTEN
NUMBER
Blocks written
BROKEN_DETAILS
STRING
Broken details
BYTES_PER_SECTOR
NUMBER
Bytes per sector
CHECKSUM_COMPATIBILITY
STRING
Checksum compatibility
COPY_DESTINATION
STRING
Copy destination
COPY_PCT
NUMBER
Copy percentage
DISK_ID
NUMBER
Disk ID
DISK_MODEL
STRING
Disk model
DISK_NAME
STRING
Disk Name
DISK_TYPE
STRING
Disk Type
DISK_UID
STRING
Disk UID
FIRMWARE_REVISION
STRING
Firmware revision information
GROWN_DEFECT_LIST_COUNT
NUMBER
Grown defect list counter
HOST_ADAPTOR
STRING
Host adaptor name
IS_DYNAMICALLY_QUALIFIED
STRING
Flag for dynamically qualified: Y or N
IS_OFFLINE
STRING
Offline flag: Y or N
IS_PREFAILED
STRING
Prefailed flag: Y or N
IS_REPLACING
STRING
Replacing flag: Y or N
IS_ZEROED
STRING
Zeroed flag: Y or N
LAST_UPDATED
DATE
Last update date
NAP_AGGREGATE_ID
NUMBER
Aggregate ID
NAP_PHYSICAL_DISK_ID
NUMBER
Physical disk ID
NAP_PLEX_ID
NUMBER
Plex ID
NAP_RAID_GROUP_ID
NUMBER
RAID group ID
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID
NAP_VOLUME_ID
NUMBER
Volume ID
PHYSICAL_BLOCK
NUMBER
Physical disk block
PHYSICAL_SPACE_gb
NUMBER
Physical disk space in GiB
PHYSICAL_SPACE_KB
NUMBER
Physical disk space in KiB
PLEX_NAME
STRING
Plex Name
POOL_NAME
STRING
Pool name
PORT_ID
STRING
Port ID
PORT_NAME
STRING
Port name
POWERON_HOURS
NUMBER
Number of hours it is powered on
RAID_GROUP_NAME
STRING
RAID group name
RAID_STATE
STRING
RAID state
RAID_TYPE
STRING
RAID type
RAW_DISK_SECTORS
NUMBER
Raw disk sectors
RECONSTRUCTION_PCT
NUMBER
Reconstruction percentage
RPM
NUMBER
Disk speed
SCRUB_COUNT
NUMBER
Scrub count
SCUB_LAST_DONE
NUMBER
Scrub last done
SECONDARY_NAME
STRING
Secondary name
SECONDARY_PORT
STRING
Secondary port
SERIAL_NBR
NUMBER
Serial Number
SHELF
STRING
Shelf location
SHM_TIME_INTERVAL
NUMBER
SHM interval
SYSTEM_NAME
STRING
NetApp storage system name
USED_BLOCKS
NUMBER
Used blocks
USED_SPACE_gb
NUMBER
Used space in GiB
USED_SPACE_KB
NUMBER
Used space in KiB
VENDOR_ID
STRING
Vendor ID
VOLUME_NAME
STRING
Volume name
ZEROING_PCT
NUMBER
Zeroing percentage
aps_v_nap_lun
The aps_v_nap_lun view contains a single row for each LUN.
Table 4.307 aps_v_nap_lun
Column Name
Data Type
Description
aggregate_name
STRING
Aggregate name
backing_snapshot
STRING
Path to the backing snapshot file for a LUN, if there is one. Only returned if it has one. Note: This element is not returned for LUNs which are in snapshots.
igroup_name
STRING
Igroup name
is_mapped
STRING
Y=Yes, N=No. Whether or not the LUN is mapped to any initiators
is_online
STRING
Y=Yes, N=No. State of the LUN
is_read_only
STRING
Y=Yes, N=No
is_space_reserve_enabled
STRING
Y=Yes, N=No
logical_unit_id
NUMBER
Foreign key to logical unit details
lun_path
STRING
Path of the LUN
lun_share_state
STRING
Share state of the LUN, (all, none, read, or write). In the very rare case that the share state cannot be determined, unknown is returned.
lun_size_gb
NUMBER
LUN size in gigabytes
lun_uuid
STRING
Universal unique identifier (UUID) for the LUN
multi_protocal_type
STRING
Multi-protocol type of the LUN Possible values: aix, image, hpux, linux, netware, solaris, windows, vld, vmware, windows_gpt
nap_aggregate_id
NUMBER
Aggregate ID
nap_igroup_id
NUMBER
Foreign key to Igroup details
nap_Qtree_id
NUMBER
Foreign key to Qtree details
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
nap_volume_id
NUMBER
Volume ID
parent_storage_system_id
NUMBER
Parent Storage system Id (internal)
parent_system_name
STRING
Parent System Name
Qtree_name
STRING
Qtree name for NFS
storage_list
STRING
List of storage array id and name
SYSTEM_NAME
STRING
NetApp system name
volume_name
STRING
Volume name
aps_v_nap_nfs_export
The aps_v_nap_nfs_export view contains a single row for each NFS export.
Table 4.308 aps_v_nap_nfs_export
Column Name
Data Type
Description
aggregate_name
STRING
Aggregate name
available_gb
NUMBER
CIFS available size in GiB
host_id
NUMBER
Foreign key to host details
host_mount_point
STRING
Host mount point for NFS
host_name
STRING
The hostname of the client/server
host_type
STRING
Host type
nap_aggregate_id
NUMBER
Aggregate ID
nap_nfs_export_id
NUMBER
Foreign key to NFS export details
nap_Qtree_id
NUMBER
Foreign key to Qtree details for NFS
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
nap_volume_id
NUMBER
Volume ID
parent_storage_system_id
NUMBER
Parent Storage system ID (internal)
parent_system_name
STRING
Parent System Name
path_name
STRING
Path name
Qtree_name
STRING
Qtree name for NFS
root_host_name
STRING
The Root hostname
storage_list
STRING
List of storage array id and name
SYSTEM_NAME
STRING
NetApp system name
total_gb
NUMBER
CIFS total size in GiB
used_gb
NUMBER
CIFS allocated size in GiB
volume_name
STRING
Volume name
aps_v_nap_quota
The aps_v_nap_quota view contains a single row for each NetApp quota.
Table 4.309 aps_v_nap_quota
Column Name
Data Type
Description
disk_limit
NUMBER
Maximum amount of disk space, in KiB, allowed for the quota target (hard disk space limit)
disk_threshold
NUMBER
Disk space threshold, in KiB, for the quota target
disk_used
NUMBER
Current amount of disk space, in KiB, used by the quota target
file_limit
NUMBER
Maximum number of files allowed for the quota target (hard files limit)
file_used
NUMBER
Current number of files used by the quota target
group_name
STRING
Group name
last_updated
DATE
Last updated date
nap_group_id
NUMBER
Foreign key to Group details
nap_qtree_id
NUMBER
Foreign key to Qtree details for NFS
nap_quota_id
NUMBER
NetApp Quota ID (internal)
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
nap_user_id
NUMBER
Foreign key to User details
nap_volume_id
NUMBER
Foreign key to Volume details
qtree_name
STRING
Qtree name for NFS
quota_target
STRING
For an explicit quota, this value is a fully qualified quota target which is the quota target specified in the /etc/quotas file and the domain in the QUOTA_TARGET_DOMAIN directive is in effect. Multiple targets are comma separated. For a derived quota, the field is blank.
quota_type
STRING
The type of quota: user, group, or tree
quota_user_id
STRING
Quota user ID
quota_user_name
STRING
Quota user name
quota_user_type
STRING
Quota user type
soft_disk_limit
NUMBER
Soft disk space limit, in KiB, for the quota target
soft_file_limit
NUMBER
Soft file limit, in number of files, for the quota target
SYSTEM_NAME
STRING
NetApp system name
user_name
STRING
User name
vfiler
STRING
Name of the vfiler to which the quota applies, if vfilers are in use
volume_name
STRING
Volume name
aps_v_nap_quota_log
The aps_v_nap_quota_log view contains a single row for each NetApp quota log.
Table 4.310 aps_v_nap_quota_log
Column Name
Data Type
Description
disk_limit
NUMBER
Maximum amount of disk space, in KiB, allowed for the quota target (hard disk space limit)
disk_threshold
NUMBER
Disk space threshold, in KiB, for the quota target
disk_used
NUMBER
Current amount of disk space, in KiB, used by the quota target
file_limit
NUMBER
Maximum number of files allowed for the quota target (hard files limit)
file_used
NUMBER
Current number of files used by the quota target
log_date
DATE
Log date
nap_group_id
NUMBER
Internally generated number that identifies a NetApp Group.
nap_qtree_id
NUMBER
Foreign key to Qtree details for NFS
nap_quota_id
NUMBER
NetApp Quota ID (internal)
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
nap_user_id
NUMBER
Internally generated number that identifies a NetApp User.
nap_volume_id
NUMBER
Internally generated number that identifies a NetApp Volume.
Qtree_name
STRING
Qtree name for NFS
soft_disk_limit
NUMBER
Soft disk space limit, in KiB, for the quota target
soft_file_limit
NUMBER
Soft file limit, in number of files, for the quota target
SYSTEM_NAME
STRING
NetApp system name
aps_v_nap_quota_status
The aps_v_nap_quota_status view contains a single row for each NetApp quota status.
Table 4.311 aps_v_nap_quota_status
Column Name
Data Type
Description
last_updated
DATE
Last updated date
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
nap_volume_id
NUMBER
Foreign key to Volume details
pct_complete
NUMBER
The percentage complete for an “on” or “resize” operation. This is present when the status is “resizing” or “initializing”
quota_errors
STRING
Collection of quota errors including the value of the reason tag above. Each error will be separated by a new line, “\n”. Since the quota parser does not stop when a parsing error occurs, this tag returns all the errors from the quota parser. If not present, there are no errors.
reason
STRING
The last quota error message. If not present, there are no errors
status
STRING
Primary status of quotas on the indicated volume; Possible values: “on”, “off”, “resizing”, “initializing”, and “shutting down.”
sub_status
STRING
Minor quota status on the indicated volume. This status is only valid when primary status is “resizing” or “initializing.” Possible values are: “scanning”, “etc scanning”, “setup”, “queue scan”, “done”, and “none.”
SYSTEM_NAME
STRING
NetApp system name
volume_name
STRING
Volume name
aps_v_nap_qtree
The aps_v_nap_qtree view provides NetApp Qtree details.
Table 4.312 aps_v_nap_qtree
Column Name
Data Type
Description
LAST_UPDATED
DATE
Last updated
NAP_Qtree_ID
NUMBER
Qtree ID
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID
NAP_VOLUME_ID
NUMBER
NetApp volume ID
OPLOCKS
STRING
Opportunistic locking
Qtree_NAME
STRING
Qtree name
Qtree_NBR
NUMBER
Qtree number
SECURITY_STYLE
STRING
Security style
STATUS
STRING
Qtree status
SYSTEM_NAME
STRING
NetApp storage system name
VOLUME_NAME
STRING
Volume name
aps_v_nap_qtree_duplicated
The aps_v_nap_qtree_duplicated view contains rows for each qtree which might be in both the Original array and the Virtual Filer.
Table 4.313 aps_v_nap_qtree_duplicated
Column Name
Data Type
Description
LAST_UPDATED
DATE
Last updated
NAP_Qtree_ID
NUMBER
Qtree ID
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID
NAP_VOLUME_ID
NUMBER
NetApp volume ID
OPLOCKS
STRING
Opportunistic locking
Qtree_NAME
STRING
Qtree name
Qtree_NBR
NUMBER
Qtree number
SECURITY_STYLE
STRING
Security style
STATUS
STRING
Qtree status
SYSTEM_NAME
STRING
NetApp storage system name
VOLUME_NAME
STRING
Volume name
aps_v_nap_snapshot
The aps_v_nap_snapshot view provides NetApp snapshot details.
Table 4.314 aps_v_nap_snapshot
Column Name
Data Type
Description
ACCESS_TIME
DATE
Access date and time
CUM_PCT_OF_TOTAL_BLOCKS
NUMBER
Cumulative percentage of total blocks
CUM_PCT_OF_USED_BLOCKS
NUMBER
Cumulative percentage of used blocks
CUM_TOTAL
NUMBER
Cumulative total blocks
DEPENDENCY
STRING
Dependency
IS_BUSY
STRING
Busy flag: Y or N
LAST_UPDATED
DATE
Last updated date
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp Storage System ID (internal number)
NAP_VOLUME_ID
NUMBER
Volume ID
PCT_OF_TOTAL_BLOCKS
NUMBER
Percentage of total blocks
PCT_OF_USED_BLOCKS
NUMBER
Percentage of used blocks
SNAPSHOT_NAME
STRING
Snapshot name
SYSTEM_NAME
STRING
NetApp Storage System name
TOTAL
NUMBER
Total blocks
VOLUME_NAME
STRING
Volume name
aps_v_nap_snapshot_log
The aps_v_nap_snapshot_log view provides NetApp snapshot log details.
Table 4.315 aps_v_nap_snapshot_log
Column Name
Data Type
Description
log_date
DATE
Date when log record was created
nap_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
nap_volume_id
NUMBER
Foreign key to aps_v_nap_volume
used_kb
NUMBER
Used space in kilobytes
aps_v_nap_snapshot_schedule
The aps_v_nap_snapshot_schedule view provides NetApp snapshot schedule details.
Table 4.316 aps_v_nap_snapshot_schedule
Column Name
Data Type
Description
last_updated
DATE
Date and time last updated
nap_storage_system_id
NUMBER
Foreign key to aps_v_nap_storage_system
nap_volume_id
NUMBER
Foreign key to aps_v_nap_volume
snapshots_per_day
NUMBER
Number of snapshots per day
snapshots_per_hour
NUMBER
Number of snapshots per hour
snapshots_per_minute
NUMBER
Number of snapshots per minute
snapshots_per_week
NUMBER
Number of snapshots per week
which_hours
STRING
schedule hours
which_minutes
STRING
schedule minutes
aps_v_nap_storage_system
The aps_v_nap_storage_system view provides NetApp Storage System details.
Table 4.317 aps_v_nap_storage_system
Column Name
Data Type
Description
BACKPLANE_PART_NBR
STRING
Backplane part number
BACKPLANE_REVISION
STRING
Backplane revision information
BACKPLANE_SERIAL_NBR
STRING
Backplane serial number
BOARD_SPEED
NUMBER
Board speed in megaHertz
BOARD_TYPE
STRING
System board type
CACHE_gb
NUMBER
Cache in GiB
CACHE_KB
NUMBER
Cache in KiB
CONFIG_AVAILABLE_gb
NUMBER
Configuration available in GiB
CONFIG_AVAILABLE_KB
NUMBER
Configuration available in KiB
CONFIG_CAPACITY_gb
NUMBER
Configuration capacity in GiB
CONFIG_CAPACITY_KB
NUMBER
Configuration capacity in KiB
CONFIG_USED_gb
NUMBER
Configuration used in GiB
CONFIG_USED_KB
NUMBER
Configuration used in KiB
CPU_CLOB_REVISION_ID
STRING
Processor CIOB (Champion I/O Bus)
CPU_FIRMWARE_RELEASE
STRING
CPU Firmware release number
CPU_MICROCODE_VERSION
STRING
CPU microcode version
CPU_PART_NUMBER
STRING
CPU part number
CPU_PROCESSOR_ID
STRING
CPU processor ID
CPU_PROCESSOR_TYPE
STRING
CPU type
CPU_REVISION
STRING
CPU revision
CPU_SERIAL_NUMBER
STRING
CPU serial number
DEVICE_MANAGER_ID
NUMBER
Foreign key to device manager details
DOMAIN_ID
NUMBER
Domain ID
DOMAIN_NAME
STRING
Domain Name
IS_ACTIVE
STRING
Active status: Y or N
ISCSI_NODE_NAME
STRING
iSCSI Node Name of the array
LAST_UPDATED
DATE
Last updated date
MAJOR_VERSION
STRING
Current ONTAPI major version
MEMORY_SIZE_gB
NUMBER
Memory size in GiB
MEMORY_SIZE_KB
NUMBER
Memory size in KiB
MINOR_VERSION
STRING
Current ONTAPI minor version
NAP_STORAGE_SYSTEM_ID
STRING
NetApp Storage System internal ID
NBR_ALLOCATED_LUNS
NUMBER
Number of Allocated LUNs
NBR_OF_LUNS
NUMBER
Number of available LUNs
NBR_OF_PROCESSORS
STRING
Number of processors
OBJECT_ID
STRING
Object ID
ONTAP_VERSION
STRING
Current ONTAPI major version
PARTNER_SYSTEM_ID
STRING
Partner system ID
PARTNER_SYSTEM_NAME
STRING
Partner system name
PARTNER_SYSTEM_SERIAL_NBR
STRING
Partner system serial number
PROD_TYPE
STRING
Product type
RAW_ALLOCATED_gb
NUMBER
Raw allocated storage in GiB
RAW_ALLOCATED_KB
NUMBER
Raw allocated storage in KiB
RAW_AVAILABLE_gb
NUMBER
Raw available storage in GiB
RAW_AVAILABLE_KB
NUMBER
Raw available storage in KiB
RAW_CAPACITY_gb
NUMBER
Raw storage capacity in GiB
RAW_CAPACITY_KB
NUMBER
Raw storage capacity in KiB
STATUS
STRING
System status
SUPPORTS_RAID_ARRAY
STRING
Supports RAID array back-end connectivity: Y or N
SYSTEM_ID
STRING
NetApp System ID
SYSTEM_MACHINE_TYPE
STRING
System machine type
SYSTEM_MODEL
STRING
System model
SYSTEM_NAME
STRING
NetApp System name
SYSTEM_REVISION
STRING
System revision
SYSTEM_SERIAL_NBR
STRING
System serial number
VENDOR_ID
STRING
Hardware vendor ID
aps_v_nap_volume
The aps_v_nap_volume view provides NetApp volume details.
Table 4.318 aps_v_nap_volume
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
AVAILABLE_SIZE_gb
NUMBER
Available size in GiB
AVAILABLE_SIZE_KB
NUMBER
Available size in KiB
BLOCKS_RESERVED
NUMBER
Blocks reserved
CHECK_SUM_STYLE
STRING
Checksum style
CONTAINING_AGGREGATE
STRING
Containing aggregate
DISK_COUNT
NUMBER
Disk count
FILES_TOTAL
NUMBER
Total number of files
FILES_USED
NUMBER
Total of files used
INIT_QUOTA
NUMBER
Initial quota
IS_CHECKSUM_ENABLED
STRING
Checksum enabled: Y or N
IS_INCONSITENT
STRING
Is inconsistent: Y or N
IS_SNAP_LOCK
STRING
Is snap lock: Y or N
IS_UNRECOVERABLE
STRING
Is recoverable: Y or N
LAST_UPDATED
DATE
Last date updated
MIRROR_STATUS
STRING
Mirror status
NAP_AGGREGATE_ID
NUMBER
NetApp Aggregate ID
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
NAP_VOLUME_ID
NUMBER
Volume ID
PCT_USED
NUMBER
Percentage used
PERCENT_RESERVED
NUMBER
Percent reserved
PLEX_COUNT
NUMBER
Number of Plexes
RAID_SIZE_gb
NUMBER
RAID size in GiB
RAID_SIZE_KB
NUMBER
RAID size in KiB
RAID_STATUS
STRING
RAID status
REQD_RESERVE_gb
NUMBER
Required reserved size in GiB
REQD_RESERVE_KB
NUMBER
Required reserved size in KiB
RESERVE_gb
NUMBER
Reserved size in GiB
RESERVE_KB
NUMBER
Reserved size in KiB
RESERVE_SPACE
STRING
Reserve space
RESERVE_USED_gb
NUMBER
Reserved used size in GiB
RESERVE_USED_KB
NUMBER
Reserved used size in KiB
SNAPLOCK_TYPE
STRING
Snaplock type
SPACE_RESERVE_ENABLED
STRING
Space reserve enabled: Y or N
SYSTEM_NAME
STRING
NetApp system name
TOTAL_SIZE_gb
NUMBER
Total size in GiB
TOTAL_SIZE_KB
NUMBER
Total size in KiB
USED_SIZE_gb
NUMBER
Used size in GiB
USED_SIZE_KB
NUMBER
Used size in KiB
VOLUME_NAME
STRING
Volume name
VOLUME_STATE
STRING
Volume state
VOLUME_TYPE
STRING
Volume type
VOLUME_UUID
STRING
Volume UUID
aps_v_nap_volume_cifs_nfs
The aps_v_nap_volume_cifs_nfs view contains a single row for volume/cifs/nfs.
Table 4.319 aps_v_nap_volume_cifs_nfs
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
aggregate_pct_used
NUMBER
Aggregate percentage used
cifs_available_gb
NUMBER
CIFS available size in GiB
cifs_host_id
NUMBER
Foreign key to host details
cifs_host_mount_point
STRING
Host mount point for CIFS
cifs_host_name
STRING
The hostname of the client/server
cifs_nap_Qtree_id
NUMBER
Foreign key to Qtree details for CIFS
cifs_nap_volume_id
NUMBER
Foreign key to Volume details for CIFS
cifs_Qtree_name
STRING
Qtree name for CIFS
cifs_share_name
STRING
CIFS share name
cifs_total_gb
NUMBER
CIFS total size in GiB
cifs_used_gb
NUMBER
CIFS allocated size in GiB
description
STRING
Description of the share
force_group
STRING
Name of the group to which files to be created in the share belong to
host_type
STRING
Host type
is_volume_offline
STRING
Y=Yes, N=No. If Yes, volume is offline and the shares are not available.
mount_point
STRING
Mount point of the share
NAP_AGGREGATE_ID
NUMBER
NetApp Aggregate ID
nap_cifs_share_id
NUMBER
Foreign key to CIFS share details
nap_nfs_export_id
NUMBER
Foreign key to NFS export details
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
NAP_VOLUME_ID
NUMBER
Volume ID
nbr_max_user
NUMBER
Maximum number of simultaneous connections to the share
nfs_available_gb
NUMBER
NFS available size in GiB
nfs_host_id
NUMBER
Foreign key to host details
nfs_host_mount_point
STRING
Host mount point for NFS
nfs_host_name
STRING
The hostname of the client/server
nfs_nap_Qtree_id
NUMBER
Foreign key to Qtree details for NFS
nfs_nap_volume_id
NUMBER
Foreign key to Volume details for NFS
nfs_path_name
STRING
NFS path name
nfs_Qtree_name
STRING
Qtree name for NFS
nfs_total_gb
NUMBER
NFS total size in GiB
nfs_used_gb
NUMBER
NFS allocated size in GiB
num_of_exports
NUMBER
Number of NFS exports
num_of_luns
NUMBER
Number of LUNs
num_of_Qtrees
NUMBER
Number of Qtrees
num_of_shares
NUMBER
Number of CIFS shares
num_of_snapshots
NUMBER
Number of Snapshots
parent_storage_system_id
NUMBER
Parent Storage system Id (internal)
parent_system_name
STRING
Parent System Name
raid_type
STRING
The current RAID status. Possible values include: copying, degraded, foreign, growing, initializing, invalid, ironing, mirror degraded, mirrored, needs check, noparity, normal, out-of-date, partial, raid0, raid4, raid_dp, reconstruct, resyncing, snapmirrored, verifying, unrecoverable. This field can contain a combination of the above status values, in a comma-separated list.
root_host_name
STRING
Root hostname
space_guarantee
STRING
Flexible volumes only. The storage guarantee associated with the flexible volume. Possible values: none, file, volume.
storage_list
STRING
List of storage array id and name
SYSTEM_NAME
STRING
NetApp system name
volume_allocated_gb
NUMBER
Volume allocated size in GiB
volume_available_gb
NUMBER
Volume available size in GiB
VOLUME_NAME
STRING
Volume name
volume_total_gb
NUMBER
Volume total size in GiB
volume_type
STRING
Volume type
aps_v_nap_volume_duplicated
The aps_v_nap_volume_duplicated view contains rows for each volume which might be in both the Original array and the Virtual Filer.
Table 4.320 aps_v_nap_volume_duplicated
Column Name
Data Type
Description
AGGREGATE_NAME
STRING
Aggregate name
AVAILABLE_SIZE_gb
NUMBER
Available size in GiB
AVAILABLE_SIZE_KB
NUMBER
Available size in KiB
BLOCKS_RESERVED
NUMBER
Blocks reserved
CHECK_SUM_STYLE
STRING
Checksum style
CONTAINING_AGGREGATE
STRING
Containing aggregate
DISK_COUNT
NUMBER
Disk count
FILES_TOTAL
NUMBER
Total number of files
FILES_USED
NUMBER
Total of files used
INIT_QUOTA
NUMBER
Initial quota
IS_CHECKSUM_ENABLED
STRING
Checksum enabled: Y or N
IS_INCONSIsTENT
STRING
Is inconsistent: Y or N
IS_SNAP_LOCK
STRING
Is snap lock: Y or N
IS_UNRECOVERABLE
STRING
Is recoverable: Y or N
LAST_UPDATED
DATE
Last date updated
MIRROR_STATUS
STRING
Mirror status
NAP_AGGREGATE_ID
NUMBER
NetApp Aggregate ID
NAP_STORAGE_SYSTEM_ID
NUMBER
NetApp storage system ID (internal)
NAP_VOLUME_ID
NUMBER
Volume ID
PCT_USED
NUMBER
Percentage used
PERCENT_RESERVED
NUMBER
Percent reserved
PLEX_COUNT
NUMBER
Number of Plexes
RAID_SIZE_gb
NUMBER
RAID size in GiB
RAID_SIZE_KB
NUMBER
RAID size in KiB
RAID_STATUS
STRING
RAID status
REQD_RESERVE_gb
NUMBER
Required reserved size in GiB
REQD_RESERVE_KB
NUMBER
Required reserved size in KiB
RESERVE_gb
NUMBER
Reserved size in GiB
RESERVE_KB
NUMBER
Reserved size in KiB
RESERVE_SPACE
STRING
Reserve space
RESERVE_USED_gb
NUMBER
Reserved used size in GiB
RESERVE_USED_KB
NUMBER
Reserved used size in KiB
SNAPLOCK_TYPE
STRING
Snaplock type
SPACE_RESERVE_ENABLED
STRING
Space reserve enabled: Y or N
SYSTEM_NAME
STRING
NetApp system name
TOTAL_SIZE_gb
NUMBER
Total size in GiB
TOTAL_SIZE_KB
NUMBER
Total size in KiB
USED_SIZE_gb
NUMBER
Used size in GiB
USED_SIZE_KB
NUMBER
Used size in KiB
VOLUME_NAME
STRING
Volume name
VOLUME_STATE
STRING
Volume state
VOLUME_TYPE
STRING
Volume type
VOLUME_UUID
STRING
Volume UUID
aps_v_nap_volume_log
The aps_v_nap_volume_log view provides NetApp volume log details.
Table 4.321 aps_v_nap_volume_log
Column Name
Data Type
Description
available_size_kb
NUMBER
Available size in KiB
log_date
DATE
Log date
nap_volume_id
NUMBER
Volume ID
System_name
STRING
System Name
total_size_kb
NUMBER
Total size in KiB
used_size_kb
NUMBER
Used size in KiB
volume_name
STRING
Volume Name