NetApp Storage Systems Database Views

Table 3.238 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

Table 3.239 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

Table 3.240 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

Table 3.241 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

Table 3.242 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

Table 3.243 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_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

Table 3.244 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_qtree_id	NUMBER	Foreign key to Qtree details for NFS
NAP_STORAGE_SYSTEM_ID	NUMBER	NetApp storage system ID (internal)
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

Table 3.245 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

Table 3.246 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

Table 3.247 aps_v_nap_snapmirror_error
Column Name	Data Type	Description
last_updated	DATE	Date and time last updated
nap_snapmirror_schd_id	NUMBER	Foreign key to aps_v_nap_snapmirror_schd
nap_snapmirror_status_id	NUMBER	Foreign key to aps_v_nap_snapmirror_status
org_storage_system_id	NUMBER	Original storage system id. Foreign key to aps_v_nap_storage_system.
transfer_error	STRING	SnapMirror transfer error

Table 3.248 aps_v_nap_snapmirror_schd
Column Name	Data Type	Description
days_of_month	STRING	Days of month
days_of_week	STRING	Days of week
destination_qtree_id	NUMBER	Destination QTree ID
destination_qtree_name	STRING	Destination QTree name
destination_storage_system_id	NUMBER	Foreign key to aps_v_nap_storage_system
destination_system_name	STRING	Destination system name
destination_volume_id	NUMBER	Destination volume ID. Foreign key to aps_v_nap_volume.
destination_volume_name	STRING	Destination volume name
domain_id	NUMBER	Foreign key to apt_v_domain
err_nbr	NUMBER	Error number
err_reason	STRING	Error reason
hour	STRING	Hour
is_system_generated	STRING	Is the schedule system generated?
last_updated	DATE	Date and time last updated
max_transfer_rate	NUMBER	Maximum transfer rate
minute	STRING	Minute
nap_snapmirror_schd_id	NUMBER	Primary key
schd_type	STRING	Schedule type
source_qtree_id	NUMBER	Source Qtree ID
source_qtree_name	STRING	Source QTree name
source_storage_system_id	NUMBER	Source storage system ID. Foreign key to aps_v_nap_storage_system.
source_system_name	STRING	Source system name
source_volume_id	NUMBER	Foreign key to aps_v_nap_volume
source_volume_name	STRING	Source volume name
sync_ops_throttle	STRING	Sync OPS throttle
sync_visibility_freq	NUMBER	Sync visibility frequency

Table 3.249 aps_v_nap_snapmirror_status
Column Name	Data Type	Description
base_snapshot_name	STRING	Base snapshot name
contents	STRING	SnapMirror contents
cur_transfer_type	STRING	Current transfer type
lag_time	NUMBER	Lag time
last_transfer_duration	NUMBER	Last transfer duration
last_transfer_from	STRING	Last transferred from
last_transfer_size_kb	NUMBER	Last transfer size in KiB
last_transfer_type	STRING	Last transfer type
last_updated	DATE	Date and time last updated
mirror_state	STRING	Mirror state
mirror_status	STRING	Mirror status
mirror_timestamp	DATE	Mirror timestamp
nap_snapmirror_schd_id	NUMBER	Foreign key to aps_v_nap_snapmirror_schd
nap_snapmirror_status_id	NUMBER	Primary key
summary_status	NUMBER	Summary status
transfer_progress	NUMBER	Transfer progress

Table 3.250 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

Table 3.251 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

Table 3.252 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

Table 3.253 aps_v_nap_snapvault_config
Column Name	Data Type	Description
nap_snapvault_config_id	NUMBER	Primary key
domain_id	NUMBER	Foreign key to apt_v_domain
source_system_name	STRING	Source system name
source_storage_system_id	NUMBER	Foreign key to aps_v_nap_storage_system
source_volume_name	STRING	Source volume name
source_volume_id	NUMBER	Foreign key to aps_v_nap_volume
source_qtree_name	STRING	Source QTree name
source_qtree_id	NUMBER	Source QTree ID
destination_system_name	STRING	Destination system name
destination_storage_system_id	NUMBER	Foreign key to aps_v_nap_storage_system
destination_volume_name	STRING	Destination volume name
destination_volume_id	NUMBER	Foreign key to aps_v_nap_volume
destination_qtree_name	STRING	Destination QTree name
destination_qtree_id	NUMBER	Destination QTree ID
source_snapshot_name	STRING	Source snapshot name
is_backup_allowed	STRING	Is backup allowed?
max_transfer_rate	NUMBER	Maximum transfer rate
tries_count	NUMBER	Number of tries
root_snapvault_config_id	NUMBER	Root snapvault config ID
chain_order	NUMBER	SnapVault chain order
last_updated	DATE	Date and time last updated

Table 3.254 aps_v_nap_snapvault_error
Column Name	Data Type	Description
last_updated	DATE	Date and time last updated
nap_snapvault_config_id	NUMBER	Foreign key to aps_v_nap_snapvault_config
nap_snapvault_status_id	NUMBER	Foreign key to aps_v_nap_snapvault_status
org_storage_system_id	NUMBER	Foreign key to aps_v_nap_storage_system
transfer_error	STRING	Transfer error

Table 3.255 aps_v_nap_snapvault_pri_schd
Column Name	Data Type	Description
days_of_week	STRING	Primary schedule - days of the week
hours_of_day	STRING	Primary schedule - hours of the day
last_updated	DATE	Date and time last updated
nap_snapvault_pri_schd_id	NUMBER	Primary key
nap_storage_system_id	NUMBER	Foreign key to aps_v_nap_storage_system
nap_volume_id	NUMBER	Foreign key to aps_v_nap_volume
retention_count	NUMBER	Retention count
schedule_name	STRING	Primary schedule name
status	STRING	Status of the primary schedule

Table 3.256 aps_v_nap_snapvault_sec_schd
Column Name	Data Type	Description
days_of_week	STRING	SnapVault secondary schedule days of the week
hours_of_day	STRING	SnapVault secondary schedule hours of the day
is_auto_update	STRING	Is snapvault auto updatable?
last_updated	DATE	Date and time last updated
nap_snapvault_sec_schd_id	NUMBER	Primary key
nap_storage_system_id	NUMBER	Foreign key to aps_v_nap_storage_system
nap_volume_id	NUMBER	Foreign key to aps_v_nap_volume
retention_count	NUMBER	Retention count
schedule_name	STRING	Schedule name
status	STRING	SnapVault status

Table 3.257 aps_v_nap_snapvault_status
Column Name	Data Type	Description
base_snapshot_name	STRING	Base snapshot name
contents	STRING	SnapVault contents
cur_transfer_type	STRING	Current transfer type
lag_time	NUMBER	Lag time
last_transfer_duration	NUMBER	Last transfer duration
last_transfer_from	STRING	Last transferred from
last_transfer_size_kb	NUMBER	Last transfer size in KiB
last_transfer_type	STRING	Last transfer type
last_updated	DATE	Date and time last updated
mirror_state	STRING	Mirror state
mirror_status	STRING	Mirror status
mirror_timestamp	DATE	Mirror timestamp
nap_snapvault_config_id	NUMBER	Foreign key to aps_v_nap_snapvault_config
nap_snapvault_status_id	NUMBER	Primary key
summary_status	NUMBER	Summary status
transfer_progress	NUMBER	SnapVault transfer progress

Table 3.258 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

Table 3.259 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

Table 3.260 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