SchemaSpy Analysis of ocum - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Apr 23 05:29 EDT 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ocum contains 2239 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
aggregate availabilityRiskLevel int 10
aggregate capacityRiskLevel int 10
aggregate cluster_id bigint 19  √  null
aggregate daysUntilFull double 22  √  null
aggregate healthStatus int 10
aggregate id bigint 19
aggregate lastSync bigint 19
aggregate performanceRiskLevel int 10 0
aggregate protectionRiskLevel int 10
aggregatecalculationsview aggregateId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregatecalculationsview dailyGrowthRatePercent double 22  √  null
aggregatecalculationsview dfBytesAvailPercent decimal 26,4  √  null
aggregatecalculationsview dfBytesUsedPercent decimal 26,4  √  null
aggregatecapacityutilizationview aggregateType varchar 17
aggregatecapacityutilizationview aggrId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregatecapacityutilizationview aggrName varchar 255 Textual name
aggregatecapacityutilizationview availableDataCapacity decimal 10,2  √  null
aggregatecapacityutilizationview availableDataCapacityPercentage decimal 25,2  √  null
aggregatecapacityutilizationview bytesUsedPerDay double 22  √  0
aggregatecapacityutilizationview clusterFqdn varchar 255  √  null
aggregatecapacityutilizationview clusterId bigint 19
aggregatecapacityutilizationview clusterName varchar 255  √  null
aggregatecapacityutilizationview clusternodeId bigint 19
aggregatecapacityutilizationview clusterNodeName varchar 255  √  null
aggregatecapacityutilizationview dailyGrowthRate double 19,2  √  null
aggregatecapacityutilizationview daysToFull bigint unsigned 20  √  null
aggregatecapacityutilizationview haPair varchar 255  √  null
aggregatecapacityutilizationview objectStoreName varchar 255  √  null
aggregatecapacityutilizationview overCommittedCapacityPercentage decimal 26,2  √  null
aggregatecapacityutilizationview raidtype varchar 15  √  null
aggregatecapacityutilizationview resourcekey varchar 512
aggregatecapacityutilizationview snapLockType varchar 255  √  null
aggregatecapacityutilizationview snapshotReserveAvailCapacity decimal 10,2  √  null
aggregatecapacityutilizationview snapshotReserveAvailPercentage varchar 71  √  null
aggregatecapacityutilizationview snapshotReserveTotalCapacity decimal 10,2  √  null
aggregatecapacityutilizationview snapshotReserveUsedCapacity decimal 10,2  √  null
aggregatecapacityutilizationview snapshotReserveUsedPercentage varchar 71  √  null
aggregatecapacityutilizationview state varchar 255
aggregatecapacityutilizationview totalCommitted decimal 10,2  √  null
aggregatecapacityutilizationview totalDataCapacity decimal 10,2  √  null
aggregatecapacityutilizationview usedDataCapacity decimal 10,2  √  null
aggregatecapacityutilizationview usedDataCapacityPercentage decimal 25,2  √  null
aggregatecapacityutilizationview usedExternalCapacityTierSpace decimal 10,2  √  null
aggregategrowthrateinfo aggregate_id bigint 19
aggregategrowthrateinfo id bigint 19
aggregategrowthrateinfo lastSampleTime timestamp 19  √  null
aggregategrowthrateinfo meanGrowthRate double 22 0
aggregategrowthrateinfo numRates int 10 0
aggregategrowthrateinfo objVersion int 10
aggregategrowthrateinfo sumOfSquaresOfDifferencesFromMean double 22 0
aggregatehistorymonth aggregateId bigint 19
aggregatehistorymonth dfKBytesCompressionSpaceSavingsSum bigint 19 0
aggregatehistorymonth dfKBytesDedupeSpaceSavingsSum bigint 19 0
aggregatehistorymonth dfKBytesTotal bigint 19 0
aggregatehistorymonth dfKBytesTotalCommittedSum bigint 19 0
aggregatehistorymonth dfKBytesUsedSum bigint 19 0
aggregatehistorymonth dfSnapshotKBytesTotal bigint 19 0
aggregatehistorymonth dfSnapshotKBytesUsedSum bigint 19 0
aggregatehistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
aggregatehistorymonth sampleCount int 10 1
aggregatehistoryweek aggregateId bigint 19
aggregatehistoryweek dfKBytesCompressionSpaceSavingsSum bigint 19 0
aggregatehistoryweek dfKBytesDedupeSpaceSavingsSum bigint 19 0
aggregatehistoryweek dfKBytesTotal bigint 19 0
aggregatehistoryweek dfKBytesTotalCommittedSum bigint 19 0
aggregatehistoryweek dfKBytesUsedSum bigint 19 0
aggregatehistoryweek dfSnapshotKBytesTotal bigint 19 0
aggregatehistoryweek dfSnapshotKBytesUsedSum bigint 19 0
aggregatehistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
aggregatehistoryweek sampleCount int 10 1
aggregatehistoryyear aggregateId bigint 19
aggregatehistoryyear dfKBytesCompressionSpaceSavingsSum bigint 19 0
aggregatehistoryyear dfKBytesDedupeSpaceSavingsSum bigint 19 0
aggregatehistoryyear dfKBytesTotal bigint 19 0
aggregatehistoryyear dfKBytesTotalCommittedSum bigint 19 0
aggregatehistoryyear dfKBytesUsedSum bigint 19 0
aggregatehistoryyear dfSnapshotKBytesTotal bigint 19 0
aggregatehistoryyear dfSnapshotKBytesUsedSum bigint 19 0
aggregatehistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
aggregatehistoryyear sampleCount int 10 1
aggregatelivelistdtoview aggregateDerivedType enum 17  √  null Aggregate Derived Type.
aggregatelivelistdtoview aggregateType varchar 10  √  null
aggregatelivelistdtoview clusterFqdn varchar 255  √  null
aggregatelivelistdtoview clusterHealthStatus int 10
aggregatelivelistdtoview clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
aggregatelivelistdtoview clusterName varchar 255 Textual name
aggregatelivelistdtoview clusterNodeHealthStatus int 10
aggregatelivelistdtoview clusterNodeId bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
aggregatelivelistdtoview clusterNodeName varchar 255 Textual name
aggregatelivelistdtoview dfBytesAvail bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-space-attributes size-available
aggregatelivelistdtoview dfBytesAvailPercent decimal 26,4  √  null
aggregatelivelistdtoview dfBytesTotal bigint 19  √  null Total size (in bytes) of the referenced file system . If the referenced file system is restricted or offline, a value of 0 is returned
aggregatelivelistdtoview dfBytesTotalCommitted bigint 19  √  null A derived measure of the committed capacity of all Volumes on this Aggregate. "Committed" here is defined as the total capacity a volume might consume if entirely full.
aggregatelivelistdtoview dfBytesUsed bigint 19  √  null Number of bytes used in the referenced file system. If the referenced file system is restricted or offline, a value of 0 is returned
aggregatelivelistdtoview dfBytesUsedPercent decimal 26,4  √  null
aggregatelivelistdtoview hasLocalRoot bit 0  √  null Whether the aggregate contains the local root volume. ZAPIs: aggr-get-iter has-local-root.
aggregatelivelistdtoview hasPartnerRoot bit 0  √  null Whether the aggregate contains the partner's root volume. ZAPIs: aggr-get-iter has-partner-root.
aggregatelivelistdtoview healthStatus int 10
aggregatelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregatelivelistdtoview isCftPrecommit int 10  √  null
aggregatelivelistdtoview isHybridEnabled bit 0  √  null If true, aggregate is eligible to contain both SSD and non-SSD RAID groups
aggregatelivelistdtoview mirrorStatusRaw varchar 255  √  null
aggregatelivelistdtoview name varchar 255 Textual name
aggregatelivelistdtoview raidStatus varchar 255  √  null RAID status as string
aggregatelivelistdtoview raidType varchar 255  √  null
aggregatelivelistdtoview resourcePoolId bigint 19  √  null
aggregatelivelistdtoview resyncPercent decimal 32  √  null
aggregatelivelistdtoview snapLockType varchar 255  √  null
aggregatelivelistdtoview state varchar 255  √  null
aggregatelivelistdtoview totalStorageEfficiencyRatio varchar 20  √  null Indicates the total storage efficiency ratio of an aggregate
aggregatelivelistdtoview usedExternalTierCapacity bigint 19  √  null
aggregatelivelistdtoview versionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
aggregatelivelistdtoview versionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
aggregatelivelistdtoview versionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
aggregateregressioninfo aggregate_id bigint 19
aggregateregressioninfo bytesUsedPerDay double 22 0
aggregateregressioninfo id bigint 19
aggregateregressioninfo lastSampleTime timestamp 19  √  null
aggregateregressioninfo meanBytesData double 22 0
aggregateregressioninfo meanSnapshotData double 22 0
aggregateregressioninfo meanTime double 22 0
aggregateregressioninfo numSamples bigint 19 0
aggregateregressioninfo objVersion int 10
aggregateregressioninfo snapshotBytesUsedPerDay double 22 0
aggregateregressioninfo sumProductOfTimeAndBytesData double 22 0
aggregateregressioninfo sumProductOfTimeAndSnapshotData double 22 0
aggregateregressioninfo sumTimeSquared double 22 0
aggregatestoragepoollivelistdtoview allocatedCache bigint 19  √  null Capacity provisioned by aggregate from storage pool
aggregatestoragepoollivelistdtoview allocationUnits bigint 19  √  null No of memory units provisioned by aggregate from storage pool
aggregatestoragepoollivelistdtoview containerDisksCount bigint 19 The number of disks that are part of the storage pool
aggregatestoragepoollivelistdtoview healthStatus int 10
aggregatestoragepoollivelistdtoview Id bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregatestoragepoollivelistdtoview name varchar 255 Textual name
aggregatestoragepoollivelistdtoview storagePoolHealthStatus int 10 0
aggregatestoragepoollivelistdtoview storagePoolid bigint 19 Locally unique object identifier. ZAPI: storage-pool-get-iter.storage-pool-info
aggregatestoragepoollivelistdtoview storagePoolName varchar 255 The cluster-wide unique name of the storage pool.
alert description varchar 1024  √  null
alert disabled bit 1
alert eventSeverity varchar 16  √  null
alert eventTypeRegex varchar 255  √  null
alert excludeFilter longtext 2147483647  √  null
alert id bigint 19
alert includeFilter longtext 2147483647  √  null
alert name varchar 255
alert objVersion int 10
alert repeatDuration bigint 19  √  null
alert resourceTypes longtext 2147483647  √  null
alert scriptId bigint 19  √  null
alert sendSnmpTrap bit 1
alert timeFrom bigint 19  √  null
alert timeTo bigint 19  √  null
alert_emailaddressrecipients alert_id bigint 19
alert_emailaddressrecipients emailAddress varchar 255
alert_emailadminrecipients alert_id bigint 19
alert_emailadminrecipients authorizationUnit_id bigint 19
alert_eventseverities alert_id bigint 19
alert_eventseverities eventSeverity varchar 16
alert_script_audit emailAddress varchar 255  √  null
alert_script_audit eventId bigint 19
alert_script_audit id bigint 19
alert_script_audit scriptName varchar 255  √  null
alert_script_audit snmpDestination varchar 45  √  null
alert_script_audit triggerTimestamp timestamp 19 CURRENT_TIMESTAMP
alerteventtypevalues alert_id bigint 19
alerteventtypevalues eventTypeValue_id bigint 19
alertresourceobjects alert_id bigint 19
alertresourceobjects resourceObject_id bigint 19
alertresourceobjects resourceObject_type varchar 100
annotation id bigint 19  √ 
annotation isBuiltIn bit 1
annotation legacyName varchar 255  √  null
annotation name varchar 255
annotation type_id bigint 19
annotationmanualresourcemapping annotationTypeId bigint 19
annotationmanualresourcemapping annotationValueId bigint 19
annotationmanualresourcemapping resourceId bigint 19
annotationmanualresourcemapping resourceType varchar 100
annotationofcluster data-priority varchar 255  √  null
annotationofcluster id bigint 19
annotationofvolume data-priority varchar 255  √  null
annotationofvolume id bigint 19
annotationofvserver data-priority varchar 255  √  null
annotationofvserver id bigint 19
annotationresourceobject annotation_id bigint 19
annotationresourceobject annotationRule_id bigint 19  √  null
annotationresourceobject annotationType_id bigint 19
annotationresourceobject resource_id bigint 19
annotationresourceobject resource_type varchar 100
annotationresourceobjectlivelistdtoview annotationName varchar 255
annotationresourceobjectlivelistdtoview annotationTypeName varchar 255
annotationresourceobjectlivelistdtoview resourceId bigint 19
annotationresourceobjectlivelistdtoview resourceName varchar 255  √  null
annotationresourceobjectlivelistdtoview resourceType varchar 100
annotationrule annotationTypeId bigint 19
annotationrule annotationValueId bigint 19
annotationrule id bigint 19  √ 
annotationrule name varchar 255
annotationrule rank int 10
annotationrule resourceType varchar 255
annotationrulelivelistdtoview annotationTypeId bigint 19 0
annotationrulelivelistdtoview annotationTypeName varchar 255
annotationrulelivelistdtoview annotationValueFullName varchar 511  √  null
annotationrulelivelistdtoview annotationValueId bigint 19 0
annotationrulelivelistdtoview annotationValueName varchar 255
annotationrulelivelistdtoview id bigint 19 0
annotationrulelivelistdtoview name varchar 255
annotationrulelivelistdtoview numberOfAnnotatedObjects bigint 19  √  null
annotationrulelivelistdtoview rank int 10
annotationrulelivelistdtoview resourceType varchar 255
annotationtype createdByUsername varchar 255  √  null
annotationtype createdOnTimestamp timestamp 19  √  CURRENT_TIMESTAMP
annotationtype description varchar 1024
annotationtype id bigint 19  √ 
annotationtype isBuiltIn bit 1
annotationtype legacyName varchar 255  √  null
annotationtype name varchar 255
annotationtypevalueview annotationTypeId bigint 19  √  0
annotationtypevalueview annotationTypeName varchar 255  √  null
annotationtypevalueview annotationValueHealthStatus int 10 0
annotationtypevalueview annotationValueId bigint 19 0
annotationtypevalueview annotationValueName varchar 255
annotationtypevalueview healthStatus int 10 0
annotationvaluebreakdownlivelistdtoview annotationTypeId bigint 19  √  0
annotationvaluebreakdownlivelistdtoview annotationTypeName varchar 255  √  null
annotationvaluebreakdownlivelistdtoview annotationValueFullName varchar 511  √  null
annotationvaluebreakdownlivelistdtoview annotationValueHealthStatus int 10 0
annotationvaluebreakdownlivelistdtoview annotationValueId bigint 19 0
annotationvaluebreakdownlivelistdtoview annotationValueName varchar 255
annotationvaluebreakdownlivelistdtoview clusterCount decimal 23  √  null
annotationvaluebreakdownlivelistdtoview healthStatus int 10 0
annotationvaluebreakdownlivelistdtoview volumecount decimal 23  √  null
annotationvaluebreakdownlivelistdtoview vservercount decimal 23  √  null
authorizationunit authorizationUnitType varchar 255
authorizationunit contact varchar 128  √  null
authorizationunit emailAddress varchar 255  √  null
authorizationunit id bigint 19
authorizationunit name varchar 255
authorizationunit objVersion int 10
authorizationunit pagerAddress varchar 255  √  null
authorizationunit passwordHash varchar 64  √  null
authorizationunit passwordResetTokenExpirationDate timestamp 19  √  null
authorizationunit passwordResetTokenHash varchar 64  √  null
authorizationunit passwordResetTokenSalt varchar 8  √  null
authorizationunit passwordSalt varchar 8  √  null
authorizationunit role_id bigint 19
backupconsolidateddumpinfo binLogName varchar 255  √  null
backupconsolidateddumpinfo creationTime timestamp 19  √  null
backupconsolidateddumpinfo fileName varchar 255
backupconsolidateddumpinfo fileSize bigint 19  √  null
backupconsolidateddumpinfo id bigint 19
backupconsolidateddumpinfo objVersion int 10 0
backupfileinfo backupTotalSize bigint 19 0
backupfileinfo binLogName varchar 255  √  null
backupfileinfo creationTime timestamp 19  √  null
backupfileinfo databaseDumpSize bigint 19 0
backupfileinfo fileName varchar 255
backupfileinfo hasIncrementalDump bit 1 b'1'
backupfileinfo id bigint 19
backupfileinfo isScheduled bit 1  √  b'1'
backupfileinfo objVersion int 10 0
backupfileinfo size bigint 19  √  null
backupfileinfo status varchar 255
bridge cluster_id bigint 19
bridge firmware varchar 255  √  null
bridge healthStatus int 10
bridge id bigint 19
bridge ipAddress varchar 255  √  null
bridge isBeingMonitored bit 1  √  null
bridge model varchar 255  √  null
bridge objectName varchar 255
bridge objVersion int 10
bridge resourceKey varchar 512
bridge serialNumber varchar 255  √  null
bridge totalTemperatureSensorCount int 10  √  null
bridge vendor varchar 20  √  null
bridge wwn varchar 255
bridgestackconnection bridge_id bigint 19
bridgestackconnection cluster_id bigint 19
bridgestackconnection healthStatus int 10
bridgestackconnection id bigint 19
bridgestackconnection objectName varchar 255
bridgestackconnection objVersion int 10
bridgestackconnection resourceKey varchar 512
bridgestackconnection stack_id varchar 255
bridgestacklink bridgePort varchar 255  √  null
bridgestacklink bridgePortWWPN varchar 255  √  null
bridgestacklink bridgeStackConnection_id bigint 19  √  null
bridgestacklink id bigint 19
bridgestacklink linkStatus int 10  √  null
bridgestacklink objVersion int 10
bridgestacklink resourceKey varchar 512
bridgestacklink shelfPort varchar 255  √  null
bridgestacklink shelfPortWWPN varchar 255  √  null
cifsshare cluster_id bigint 19  √  null
cifsshare id bigint 19
cifsshare lastKnownQtreeId bigint 19  √  null
cifsshare lastKnownVolumeId bigint 19  √  null
cifsshare lastSync bigint 19
cifssharelivelistdtoview cifsStatus int 10 0
cifssharelivelistdtoview containingObject varchar 256  √  null
cifssharelivelistdtoview containingObjectType varchar 256  √  null
cifssharelivelistdtoview derivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
cifssharelivelistdtoview exportPolicyHealthStatus int 10
cifssharelivelistdtoview exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
cifssharelivelistdtoview exportPolicyName varchar 255  √  null
cifssharelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: cifs-share-get-iter.cifs-share
cifssharelivelistdtoview isJunctionPathActive bit 0  √  null If mounted volume is accessible
cifssharelivelistdtoview isVserverRoot bit 0  √  null Is the volume the root of a vserver
cifssharelivelistdtoview junctionPath varchar 255  √  null
cifssharelivelistdtoview name varchar 255  √  null
cifssharelivelistdtoview nfsEquivalent int 10 0
cifssharelivelistdtoview path varchar 255  √  null
cifssharelivelistdtoview qtreeHealthStatus int 10  √  null
cifssharelivelistdtoview qtreeId bigint 19  √  null Locally unique object identifier. ZAPIs: qtree-list-iter.qtree-info
cifssharelivelistdtoview qtreeName varchar 255  √  null
cifssharelivelistdtoview securityStyle varchar 256  √  null
cifssharelivelistdtoview unAvailableParentVolumeId bigint 19  √  null
cifssharelivelistdtoview volumeHealthStatus int 10
cifssharelivelistdtoview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
cifssharelivelistdtoview volumeName varchar 255 Textual name
cifssharelivelistdtoview volumeState varchar 255  √  null
cifssharelivelistdtoview vserverHealthStatus int 10
cifssharelivelistdtoview vserverId bigint 19
cifssharelivelistdtoview vserverName varchar 255 Textual name
clienteventdetails event_id bigint 19
clienteventdetails eventUrl varchar 360  √  null
clienteventdetails id bigint 19
clienteventdetails objVersion int 10
cluster availabilityRiskLevel int 10
cluster capacityRiskLevel int 10
cluster cluster_id bigint 19  √  null
cluster dataSource_id int 10
cluster fqdn varchar 255  √  null
cluster hasSingleNode bit 1
cluster healthStatus int 10
cluster id bigint 19
cluster isBridgeStretchConfig bit 1  √  b'1'
cluster isHardwareSystem bit 1  √  b'1'
cluster lastSync bigint 19
cluster performanceRiskLevel int 10 0
cluster protectionRiskLevel int 10
clusterhistorymonth clusterId bigint 19
clusterhistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
clusterhistorymonth rawBytesTotalSum decimal 22 0
clusterhistorymonth rawBytesUsedSum decimal 24 0
clusterhistorymonth sampleCount int 10 1
clusterhistoryweek clusterId bigint 19
clusterhistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
clusterhistoryweek rawBytesTotalSum decimal 22 0
clusterhistoryweek rawBytesUsedSum decimal 24 0
clusterhistoryweek sampleCount int 10 1
clusterhistoryyear clusterId bigint 19
clusterhistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
clusterhistoryyear rawBytesTotalSum decimal 22 0
clusterhistoryyear rawBytesUsedSum decimal 24 0
clusterhistoryyear sampleCount int 10 1
clusterlivelistdtoview communicationStatus int 10  √  null
clusterlivelistdtoview contact varchar 255  √  null The contact information for the cluster, ZAPIs: cluster-identity-get cluster-contact
clusterlivelistdtoview diagnosisStatus varchar 255  √  null Overall system health as determined by diagnosis framework - ZAPI raw value
clusterlivelistdtoview durationSinceLastUpdate bigint 19  √  null
clusterlivelistdtoview fqdn varchar 255  √  null
clusterlivelistdtoview healthStatus int 10
clusterlivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterlivelistdtoview lastUpdateTime bigint 19  √  null
clusterlivelistdtoview location varchar 255  √  null The location of the cluster, ZAPIs: cluster-identity-get cluster-location
clusterlivelistdtoview name varchar 255 Textual name
clusterlivelistdtoview numberOfNodes bigint 19  √  null
clusterlivelistdtoview primaryHostName varchar 255  √  null Address used to acquire information about this cluster
clusterlivelistdtoview serialNumber varchar 255  √  null Serial number
clusterlivelistdtoview shortOSVersion varchar 1024  √  null
clusterlivelistdtoview sslFipsEnabled bit 0  √  null Indicates whether or not SSL FIPS 140-2 is Enabled
clusternode cluster_id bigint 19  √  null
clusternode healthStatus int 10
clusternode id bigint 19
clusternode lastSync bigint 19
clusternode mtAutomaticUso bit 1  √  b'1'
clusternodededicatesparecapacityview node_id bigint 19  √  null
clusternodededicatesparecapacityview rawBytesDedicatedSpare decimal 41  √  null
clusternodedowneventsview downTimestamp timestamp 19  √  null
clusternodedowneventsview eventName varchar 255
clusternodedowneventsview node_id bigint 19
clusternodehighavailabilitystateview haState varchar 14
clusternodehighavailabilitystateview haStateErrorReason text 65535  √  null
clusternodehighavailabilitystateview haStatus varchar 21
clusternodehighavailabilitystateview isSfoPairInterconnectUp int 10  √  null
clusternodehighavailabilitystateview node_id bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
clusternodehistorymonth clusterNodeId bigint 19
clusternodehistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
clusternodehistorymonth rawBytesTotalSum decimal 24 0
clusternodehistorymonth rawBytesUsedSum decimal 24 0
clusternodehistorymonth sampleCount int 10 1
clusternodehistoryweek clusterNodeId bigint 19
clusternodehistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
clusternodehistoryweek rawBytesTotalSum decimal 24 0
clusternodehistoryweek rawBytesUsedSum decimal 24 0
clusternodehistoryweek sampleCount int 10 1
clusternodehistoryyear clusterNodeId bigint 19
clusternodehistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
clusternodehistoryyear rawBytesTotalSum decimal 24 0
clusternodehistoryyear rawBytesUsedSum decimal 24 0
clusternodehistoryyear sampleCount int 10 1
clusternodelivelistdtoview aggrBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
clusternodelivelistdtoview aggrBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
clusternodelivelistdtoview clusterFqdn varchar 255  √  null
clusternodelivelistdtoview clusterHealthStatus int 10
clusternodelivelistdtoview clusterId bigint 19
clusternodelivelistdtoview clusterName varchar 255 Textual name
clusternodelivelistdtoview contact varchar 255  √  null The owner of the Node. ZAPI: system-node-get-iter node-owner
clusternodelivelistdtoview diskCount bigint 19  √  null
clusternodelivelistdtoview diskShelveCount bigint 19  √  null
clusternodelivelistdtoview downTimestamp timestamp 19  √  null
clusternodelivelistdtoview ethernetPortCount bigint 19  √  null
clusternodelivelistdtoview fcoePortCount bigint 19  √  null
clusternodelivelistdtoview fcPortCount bigint 19  √  null
clusternodelivelistdtoview firmwareVersion varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
clusternodelivelistdtoview flashCardCount bigint 19  √  null
clusternodelivelistdtoview flashCardSize decimal 44  √  null
clusternodelivelistdtoview haPairName varchar 255  √  null
clusternodelivelistdtoview haState varchar 14  √ 
clusternodelivelistdtoview haStateErrorReason text 65535  √  null
clusternodelivelistdtoview haStatus varchar 21  √ 
clusternodelivelistdtoview healthStatus int 10
clusternodelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
clusternodelivelistdtoview isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
clusternodelivelistdtoview isSfoPairInterconnectUp int 10  √  null
clusternodelivelistdtoview isUp bit 0  √  null The RDB health of the node. True means the node is in quorum. ZAPI: system-node-get-iter is-node-healthy
clusternodelivelistdtoview location varchar 255  √  null Location of the node.
clusternodelivelistdtoview model varchar 255  √  null Hardware model of this node.
clusternodelivelistdtoview name varchar 255 Textual name
clusternodelivelistdtoview rawBytesDedicatedSpare decimal 41  √  null
clusternodelivelistdtoview rawBytesSharedCacheSpare decimal 41  √  null
clusternodelivelistdtoview rawBytesSharedDataSpare decimal 42  √  null
clusternodelivelistdtoview rawBytesSpare decimal 65  √  null
clusternodelivelistdtoview rawBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
clusternodelivelistdtoview rawBytesUsed bigint 19  √  null DERIVED.Sum of all disks size used
clusternodelivelistdtoview serialNumber varchar 255  √  null Serial number
clusternodelivelistdtoview shortOSVersion varchar 1024  √  null
clusternodelivelistdtoview svmCount bigint 19  √  null
clusternodelivelistdtoview version varchar 255  √  null Version of the cluster
clusternodelivelistdtoview versionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to this Node.
clusternodelivelistdtoview versionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to this Node
clusternodelivelistdtoview versionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to this Node
clusternoderawsparecapacityview node_id bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
clusternoderawsparecapacityview rawBytesSpare decimal 65  √  null
clusternoderawsparesharedcachecapacityview node_id bigint 19
clusternoderawsparesharedcachecapacityview rawBytesSharedCacheSpare decimal 41  √  null
clusternoderawspareshareddatacapacityview node_id bigint 19  √  null
clusternoderawspareshareddatacapacityview rawBytesSharedDataSpare decimal 42  √  null
clusterunconfiguredcapacitymapping ClusterName varchar 255 Textual name
clusterunconfiguredcapacitymapping objid bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterunconfiguredcapacitymapping resourceKey varchar 512
clusterunconfiguredcapacitymapping TotExternalCapacityTierLicensedSpaceUsed decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapacityTierUnLicensedSpaceUsed decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapaityTierLicensedSpace bigint 19  √  null
clusterunconfiguredcapacitymapping unconfiguredRawCapacity decimal 60  √  null
conditiongroup id bigint 19  √ 
conditiongroup selectionCriterionId bigint 19
conditiontable annotationValueId bigint 19  √  null
conditiontable attributeType varchar 16
conditiontable conditionGroupId bigint 19
conditiontable id bigint 19  √ 
conditiontable operandId bigint 19
conditiontable operator varchar 16
conditiontable value varchar 255
customer_usage id bigint 19
customer_usage name varchar 255  √  null
customer_usage value varchar 45  √  null
customeventtype description varchar 255
customeventtype id bigint 19
customeventtypevalue id bigint 19
customeventtypevalue unqualifiedPrettyName varchar 255
databaseproperty propertyKey varchar 255
databaseproperty propertyValue varchar 255  √  null
datapolicy dataPolicyExpression longtext 2147483647
datapolicy id bigint 19
datapolicy objVersion int 10
datapolicy vserver_id bigint 19
datasource acquisitionMessage longtext 2147483647  √  null
datasource acquisitionStatus int 10  √  null
datasource analysisMessage longtext 2147483647  √  null
datasource analysisStatus int 10  √  null
datasource communicationStatus int 10  √  null
datasource healthStatus int 10
datasource id int 10
datasource lastOperationFailureTime timestamp 19  √  null
datasource lastOperationSuccessTime timestamp 19  √  null
datasource objectName varchar 255
datasource objectResourceKey varchar 512 1
datasource objVersion int 10
datasource operation int 10  √  1
datasource operationEndTime timestamp 19  √  null
datasource operationStartTime timestamp 19  √  null
datasource operationState int 10  √  0
datasource pingable bit 1 b'1'
datasource resourceKey varchar 512
datasourcelivelistdtoview clusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
datasourcelivelistdtoview durationSinceLastFailure bigint 19  √  null
datasourcelivelistdtoview durationSinceLastSuccess bigint 19  √  null
datasourcelivelistdtoview id int 10
datasourcelivelistdtoview lastOperationFailureTime timestamp 19  √  null
datasourcelivelistdtoview lastOperationSuccessTime timestamp 19  √  null
datasourcelivelistdtoview name varchar 255  √  null
datasourcelivelistdtoview operation int 10  √  1
datasourcelivelistdtoview operationEndTime timestamp 19  √  null
datasourcelivelistdtoview operationStartTime timestamp 19  √  null
datasourcelivelistdtoview operationState int 10  √  0
deferredmccresource cluster_id bigint 19
deferredmccresource deferredTimestamp timestamp 19  √  null
deferredmccresource id bigint 19
deferredmccresource resourceId bigint 19
deferredmccresource resourceType varchar 40
deferredontapalert changeType int 10
deferredontapalert cluster_id bigint 19
deferredontapalert deferredTimestamp timestamp 19  √  null
deferredontapalert id bigint 19
deferredontapalert ontapAlert_id bigint 19
deletedvolume aggregateName varchar 255
deletedvolume clusterName varchar 255
deletedvolume id bigint 19
deletedvolume junctionPath varchar 512  √  null
deletedvolume objVersion int 10
deletedvolume volumeName varchar 255
deletedvolume volumeUUID varchar 36  √  null
deletedvolume vserverName varchar 255
diskaggregaterelationship id bigint 19  √ 
diskaggregaterelationship lastKnownAggregateId bigint 19
diskaggregaterelationship lastKnownDiskId bigint 19
diskaggregaterelationshipaggrcountview aggrCount bigint 19 0
diskaggregaterelationshipaggrcountview diskId bigint 19  √  null
diskcapacitymapping clusterId bigint 19
diskcapacitymapping unconfiguredRawCapacity decimal 60  √  null
disklivelistdtoview bay varchar 255  √  null Disk shelf bay, if it can be determined
disklivelistdtoview clusterHealthStatus int 10
disklivelistdtoview clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
disklivelistdtoview clusterName varchar 255 Textual name
disklivelistdtoview containerType varchar 255  √  null
disklivelistdtoview diskType varchar 255  √  null
disklivelistdtoview effectiveType varchar 255  √  null
disklivelistdtoview firmwareRevision varchar 255  √  null Firmware revision of disk. The format of the firmware revision will vary depending on the type of disk and its vendor
disklivelistdtoview healthStatus int 10
disklivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: storage-disk-get-iter.storage-disk-info
disklivelistdtoview impactedAggregateHealthStatus bigint 19  √  null
disklivelistdtoview impactedAggregateId bigint 19  √  null
disklivelistdtoview impactedAggregateName varchar 255  √  null
disklivelistdtoview impactedAggregatesCount bigint 19  √  null
disklivelistdtoview isLocalAttach int 10  √  null
disklivelistdtoview model varchar 255  √  null Disk model string
disklivelistdtoview name varchar 255 Textual name
disklivelistdtoview objectId bigint 19 Locally unique object identifier. ZAPIs: storage-disk-get-iter.storage-disk-info
disklivelistdtoview ownerNodeClusterId bigint 19  √  null
disklivelistdtoview ownerNodeHealthStatus int 10  √  null
disklivelistdtoview ownerNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
disklivelistdtoview ownerNodeName varchar 255  √  null Textual name
disklivelistdtoview percentRatedLifeUsed int 10  √  null An estimate of the percentage of device life that has been used
disklivelistdtoview raidGroupName varchar 255  √  null Textual name
disklivelistdtoview raidState varchar 40  √  null
disklivelistdtoview raidType varchar 255  √  null
disklivelistdtoview rpm int 10  √  null Disk RPM
disklivelistdtoview shelf varchar 255  √  null Disk shelf, if it can be determined
disklivelistdtoview storagePoolHealthStatus int 10  √  null
disklivelistdtoview storagePoolId bigint 19  √  null Locally unique object identifier. ZAPI: storage-pool-get-iter.storage-pool-info
disklivelistdtoview storagePoolName varchar 255  √  null The cluster-wide unique name of the storage pool.
disklivelistdtoview totalBytes bigint 19  √  null DERIVED from totalBlocks * 4096 bytes/block.
disklivelistdtoview usedBytes bigint 19  √  null DERIVED from usedBlocks * 4096 bytes/block.
disklivelistdtoview vendorName varchar 255  √  null Disk vendor
disklivelistdtoview wearLevelPercent int 10  √  null Percentage of device spare blocks that have been used.
efficiencypolicy cluster_id bigint 19  √  null
efficiencypolicy healthStatus int 10
efficiencypolicy id bigint 19
efficiencypolicy lastSync bigint 19
event acknowledgedBy varchar 128  √  null
event acknowledgedTimestamp timestamp 19  √  null
event assignedTimestamp timestamp 19  √  null
event assignedTo varchar 128  √  null
event cluster_id bigint 19  √  null
event clusterNode_id bigint 19  √  null
event encodedArguments longtext 2147483647  √  null
event eventTimestamp timestamp 19  √  null
event id bigint 19
event impactArea varchar 60  √  null
event isChecked bit 1  √  null
event isContinuous bit 1 b'1'
event lastObservedTime bigint 19  √  null
event maintenance bit 1 b'0'
event objVersion int 10
event obsoleteCause varchar 60  √  null
event obsoleteCauseEncodedArguments longtext 2147483647  √  null
event obsoleteCauseEvent_id bigint 19  √  null
event obsoleteCauseValue_id bigint 19  √  null
event obsoleteTimestamp timestamp 19  √  null
event resolvedBy varchar 128  √  null
event resolvedTimestamp timestamp 19  √  null
event source_fullName varchar 2000
event source_id bigint 19
event source_resourceKey varchar 512
event source_resourceType varchar 40
event source_type varchar 100
event state varchar 16
event subType smallint 5  √  null
event targetId bigint 19  √  null
event targetType smallint 5  √  null
event thresholdPolicyId bigint 19  √  null
event value_id bigint 19
event vserver_id bigint 19  √  null
eventnote author varchar 64
eventnote content varchar 255
eventnote createdTimestamp timestamp 19  √  null
eventnote event_id bigint 19
eventnote id bigint 19
eventnote objVersion int 10
eventontapsystemhealthalertmapping alert_cluster_id bigint 19  √  null
eventontapsystemhealthalertmapping alert_id bigint 19
eventontapsystemhealthalertmapping cluster_id bigint 19  √  null
eventontapsystemhealthalertmapping event_id bigint 19
eventontapsystemhealthalertmapping event_source_id bigint 19
eventontapsystemhealthalertmapping eventResolvedTimestamp timestamp 19  √  null
eventontapsystemhealthalertmapping eventTypeValueName varchar 255
eventontapsystemhealthalertmapping id bigint 19
eventtype allowsBuiltInAlert bit 1
eventtype category varchar 60  √  null
eventtype id bigint 19
eventtype ignoresDuplicates bit 1
eventtype impactArea varchar 60  √  null
eventtype isAutoReset bit 1
eventtype isMultiCurrent bit 1
eventtype maxDuplicatesToIgnore int 10  √  null
eventtype name varchar 128
eventtype objType varchar 100
eventtype objVersion int 10
eventtype parentCategory_id bigint 19  √  null
eventtypecategoryclosureassociation container_id bigint 19
eventtypecategoryclosureassociation eventType_id bigint 19
eventtypecategorycontainer id bigint 19
eventtypecategorycontainer name varchar 255
eventtypecategorycontainer objVersion int 10
eventtypecategorycontainer parentCategory_id bigint 19  √  null
eventtypesourcetypes eventType_id bigint 19
eventtypesourcetypes sourceType varchar 40
eventtypesourcetypes sourceTypeDisplayName varchar 255
eventtypevalue eventDisplayName varchar 255
eventtypevalue id bigint 19
eventtypevalue impactLevel int 10
eventtypevalue internalName varchar 100
eventtypevalue isEventGenerationEnabled bit 1 b'1'
eventtypevalue objType varchar 100
eventtypevalue objVersion int 10
eventtypevalue outboundTrapOID int 10  √  null
eventtypevalue severity int 10
eventtypevalue type_id bigint 19
eventtypevalue uniqueName varchar 255
exportpolicy accessProtocols varchar 255  √  null
exportpolicy cluster_id bigint 19  √  null
exportpolicy healthStatus int 10
exportpolicy id bigint 19
exportpolicy lastSync bigint 19
exportrule cluster_id bigint 19  √  null
exportrule id bigint 19
exportrule lastSync bigint 19
exportrulelivelistdtoview accessProtocol varchar 255 Client access protocol. Default value is 'any'. May be comma separated
exportrulelivelistdtoview clientMatch varchar 255 Client match specification for Export rule. The clients specified are enforced with this Export rule. The rule with the higher rule index value takes precedence
exportrulelivelistdtoview exportPolicyHealthStatus int 10
exportrulelivelistdtoview exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
exportrulelivelistdtoview exportPolicyName varchar 255  √  null Name of the policy
exportrulelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: export-rule-get-iter.export-rule-info
exportrulelivelistdtoview roRule varchar 255  √  null Rule for read-only access. Ordered, comma separated list of the array values in ONTAP.
exportrulelivelistdtoview ruleIndex int 10  √  null Export rule index
exportrulelivelistdtoview rwRule varchar 255  √  null Rule for read-write access. Ordered, comma separated list of the array values in ONTAP.
exportrulelivelistdtoview vserverHealthStatus int 10
exportrulelivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
exportrulelivelistdtoview vserverName varchar 255 Textual name
externalcache clusterNode_id bigint 19
externalcache externalCacheHitsPerSecond bigint 19  √  null
externalcache hitPercentage int 10  √  null
externalcache id bigint 19
externalcache objVersion int 10
externalcache readRequestsPerSecond bigint 19  √  null
externalcache sizeInGB bigint 19  √  null
externalcache usagePercentage int 10  √  null
externalcachehistorymonth clusterNodeId bigint 19
externalcachehistorymonth externalCacheHitsPerSecondSum bigint 19 0
externalcachehistorymonth hitPercentageSum bigint 19 0
externalcachehistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
externalcachehistorymonth readRequestsPerSecondSum bigint 19 0
externalcachehistorymonth sampleCount int 10 1
externalcachehistorymonth sizeInGBSum bigint 19 0
externalcachehistorymonth usagePercentageSum bigint 19 0
externalcachehistoryweek clusterNodeId bigint 19
externalcachehistoryweek externalCacheHitsPerSecondSum bigint 19 0
externalcachehistoryweek hitPercentageSum bigint 19 0
externalcachehistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
externalcachehistoryweek readRequestsPerSecondSum bigint 19 0
externalcachehistoryweek sampleCount int 10 1
externalcachehistoryweek sizeInGBSum bigint 19 0
externalcachehistoryweek usagePercentageSum bigint 19 0
externalcachehistoryyear clusterNodeId bigint 19
externalcachehistoryyear externalCacheHitsPerSecondSum bigint 19 0
externalcachehistoryyear hitPercentageSum bigint 19 0
externalcachehistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
externalcachehistoryyear readRequestsPerSecondSum bigint 19 0
externalcachehistoryyear sampleCount int 10 1
externalcachehistoryyear sizeInGBSum bigint 19 0
externalcachehistoryyear usagePercentageSum bigint 19 0
favorite id bigint 19
favorite resourceKey varchar 512
favorite resourceObject_id bigint 19
favorite resourceObject_type varchar 50
favorite timeStamp timestamp 19  √  null
fcptarget cluster_id bigint 19  √  null
fcptarget currentState varchar 255  √  null
fcptarget healthStatus int 10
fcptarget id bigint 19
fcptarget lastSync bigint 19
fcptarget previousState varchar 255  √  null
flashcard cluster_id bigint 19  √  null
flashcard healthStatus int 10
flashcard id bigint 19
flashcard lastSync bigint 19
flexvolcalculationsview isPrimary int 10 0
flexvolcalculationsview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
groupaction description varchar 1024  √  null
groupaction groupActionType varchar 255
groupaction groupId bigint 19  √  null
groupaction id bigint 19  √ 
groupaction name varchar 255
groupaction priority int 10
groupactionargument groupActionArgumentRawValue varchar 255  √  null
groupactionargument groupActionId bigint 19  √  null
groupactionargument groupActionTypeParameter varchar 255
groupactionargument id bigint 19  √ 
groupactionlivelistdtoview description varchar 1024  √  null
groupactionlivelistdtoview groupActionType varchar 255
groupactionlivelistdtoview groupId bigint 19  √  null
groupactionlivelistdtoview groupName varchar 255  √  null
groupactionlivelistdtoview id bigint 19 0
groupactionlivelistdtoview name varchar 255
groupactionlivelistdtoview priority int 10
grouplivelistdtoview description varchar 1024  √  null
grouplivelistdtoview id bigint 19 0
grouplivelistdtoview name varchar 255
grouplivelistdtoview numberOfActions bigint 19  √  null
grouplivelistdtoview numberOfClusters bigint 19  √  null
grouplivelistdtoview numberOfMembershipRules bigint 19  √  null
grouplivelistdtoview numberOfSVMs bigint 19  √  null
grouplivelistdtoview numberOfVolumes bigint 19  √  null
groupmembership groupId bigint 19
groupmembership groupMembershipRuleId bigint 19
groupmembership resourceId bigint 19
groupmembership storageObjectType varchar 100
groupmembershiprule groupId bigint 19
groupmembershiprule id bigint 19  √ 
groupmembershiprule name varchar 255
groupmembershiprule storageObjectType varchar 255
groupmembershiprulelivelistdtoview groupId bigint 19
groupmembershiprulelivelistdtoview groupName varchar 255  √  null
groupmembershiprulelivelistdtoview id bigint 19 0
groupmembershiprulelivelistdtoview name varchar 255
groupmembershiprulelivelistdtoview numberOfMatchingObjects bigint 19  √  null
groupmembershiprulelivelistdtoview storageObjectType varchar 255
groups createdByUsername varchar 255
groups createdOnTimestamp timestamp 19 CURRENT_TIMESTAMP
groups description varchar 1024  √  null
groups id bigint 19  √ 
groups name varchar 255
halevelmapping aggregateBytesTotal decimal 41  √  null
halevelmapping aggregateBytesUsed decimal 41  √  null
halevelmapping assignedLunCapacity decimal 65  √  null
halevelmapping clusterId bigint 19  √  null
halevelmapping haPairId bigint 19 Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
halevelmapping haPairName varchar 511  √  null
halevelmapping isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
halevelmapping model varchar 255  √  null Hardware model of this node.
halevelmapping nodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
halevelmapping ontapVersion varchar 1024  √  null
halevelmapping partnerNodeId bigint 19  √  null
halevelmapping rawDiskBytesTotal decimal 41  √  null
halevelmapping totalVolumeCapacity decimal 63  √  null
halevelmapping unassignedLunCapacity decimal 65  √  null
halevelmapping volumeProtectionCapacity decimal 63  √  null
halevelmapping volumeUsedCapacity decimal 64  √  null
hapairview haPairName varchar 255  √  null
hapairview node1Id bigint 19 The objid of node1 in this ha_pair.
hapairview node2Id bigint 19 The objid of node2 in this ha_pair.
hapairview objid bigint 19 Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
hibernate_sequences next_val int 10
hibernate_sequences sequence_name varchar 60
igrouplivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: igroup-get-iter.initiator-group-info
igrouplivelistdtoview igroupName varchar 255 Textual name
igrouplivelistdtoview igroupType varchar 255  √  null Raw value of type of initiators in this group.
igrouplivelistdtoview initiatorMappedIgroupCount bigint 19  √  0
igrouplivelistdtoview lifMappedIgroupCount varchar 278  √  null
igrouplivelistdtoview lunMappedIgroupCount bigint 19  √  0
igrouplivelistdtoview mappedLunIdentifier text 65535  √  null
igrouplivelistdtoview osType varchar 255  √  null OS type of the initiator group
igrouplivelistdtoview portSetName varchar 255  √  null Textual name
igrouplivelistdtoview vserverHealthStatus int 10
igrouplivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
igrouplivelistdtoview vserverName varchar 255 Textual name
infinitevolhistorymonth dfKBytesCompressionSpaceSavingsSum bigint 19 0
infinitevolhistorymonth dfKBytesDedupeSpaceSavingsSum bigint 19 0
infinitevolhistorymonth dfKBytesTotal bigint 19 0
infinitevolhistorymonth dfKBytesUsedSum bigint 19 0
infinitevolhistorymonth dfSnapshotKBytesTotal bigint 19 0
infinitevolhistorymonth dfSnapshotKBytesUsedSum bigint 19 0
infinitevolhistorymonth overwriteReserveSpaceAvailSum bigint 19 0
infinitevolhistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
infinitevolhistorymonth sampleCount int 10 1
infinitevolhistorymonth volumeId bigint 19
infinitevolhistoryweek dfKBytesCompressionSpaceSavingsSum bigint 19 0
infinitevolhistoryweek dfKBytesDedupeSpaceSavingsSum bigint 19 0
infinitevolhistoryweek dfKBytesTotal bigint 19 0
infinitevolhistoryweek dfKBytesUsedSum bigint 19 0
infinitevolhistoryweek dfSnapshotKBytesTotal bigint 19 0
infinitevolhistoryweek dfSnapshotKBytesUsedSum bigint 19 0
infinitevolhistoryweek overwriteReserveSpaceAvailSum bigint 19 0
infinitevolhistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
infinitevolhistoryweek sampleCount int 10 1
infinitevolhistoryweek volumeId bigint 19
infinitevolhistoryyear dfKBytesCompressionSpaceSavingsSum bigint 19 0
infinitevolhistoryyear dfKBytesDedupeSpaceSavingsSum bigint 19 0
infinitevolhistoryyear dfKBytesTotal bigint 19 0
infinitevolhistoryyear dfKBytesUsedSum bigint 19 0
infinitevolhistoryyear dfSnapshotKBytesTotal bigint 19 0
infinitevolhistoryyear dfSnapshotKBytesUsedSum bigint 19 0
infinitevolhistoryyear overwriteReserveSpaceAvailSum bigint 19 0
infinitevolhistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
infinitevolhistoryyear sampleCount int 10 1
infinitevolhistoryyear volumeId bigint 19
initiator cluster_id bigint 19  √  null
initiator id bigint 19
initiator lastSync bigint 19
initiatorcountperigroupdtoview igroupId bigint 19
initiatorcountperigroupdtoview initiatorMappedIgroup bigint 19 0
initiatordtoviewlist id bigint 19  √  null Locally unique object identifier. ZAPIs: igroup-get-iter.initiator-group-info.initiators.initiator-info
initiatordtoviewlist igroupMappedInitiatorCount bigint 19 0
initiatordtoviewlist initiatorName varchar 255 Textual name
initiatordtoviewlist initiatorType varchar 5
initiatordtoviewlist vserverHealthStatus int 10
initiatordtoviewlist vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
initiatordtoviewlist vserverName varchar 255 Textual name
initiatorgroup cluster_id bigint 19  √  null
initiatorgroup healthStatus int 10
initiatorgroup id bigint 19
initiatorgroup lastSync bigint 19
internodeconnection cluster_id bigint 19
internodeconnection firstNode_id bigint 19  √  null
internodeconnection healthStatus int 10
internodeconnection id bigint 19
internodeconnection objectName varchar 255
internodeconnection objVersion int 10
internodeconnection peercluster_id bigint 19
internodeconnection resourceKey varchar 512
internodeconnection secondNode_id bigint 19  √  null
internodelink firstNodePort varchar 255  √  null
internodelink firstNodePortWWPN varchar 255  √  null
internodelink id bigint 19
internodelink InterNodeConnection_id bigint 19  √  null
internodelink linkStatus int 10  √  null
internodelink objVersion int 10
internodelink resourceKey varchar 512
internodelink secondNodePort varchar 255  √  null
internodelink secondNodePortWWPN varchar 255  √  null
interswitchconnection cluster_id bigint 19
interswitchconnection firstSwitch_id bigint 19  √  null
interswitchconnection healthStatus int 10
interswitchconnection id bigint 19
interswitchconnection objectName varchar 255
interswitchconnection objVersion int 10
interswitchconnection peercluster_id bigint 19
interswitchconnection resourceKey varchar 512
interswitchconnection secondSwitch_id bigint 19  √  null
interswitchlink firstSwitchPort varchar 255  √  null
interswitchlink firstSwitchPortWWPN varchar 255  √  null
interswitchlink id bigint 19
interswitchlink interSwitchConnection_id bigint 19  √  null
interswitchlink linkStatus int 10  √  null
interswitchlink objVersion int 10
interswitchlink resourceKey varchar 512
interswitchlink secondSwitchPort varchar 255  √  null
interswitchlink secondSwitchPortWWPN varchar 255  √  null
inventoryscheduleview createdBy varchar 255
inventoryscheduleview createdTimestamp timestamp 19 0000-00-00 00:00:00.000
inventoryscheduleview day enum 9  √  null
inventoryscheduleview format enum 4
inventoryscheduleview id bigint 19 0
inventoryscheduleview intervalUnit enum 7
inventoryscheduleview name varchar 255
inventoryscheduleview objectType varchar 255
inventoryscheduleview recipients varchar 255
inventoryscheduleview startTime varchar 20
inventoryscheduleview viewId bigint 19 0
inventoryscheduleview viewName varchar 255
inventoryscheduleview viewStyle enum 7
inventoryscheduleview viewType enum 28
inventoryview category enum 28
inventoryview columns json 0  √  null
inventoryview createdBy varchar 255
inventoryview createdTimestamp timestamp 19  √  null
inventoryview filters json 0  √  null
inventoryview id bigint 19  √ 
inventoryview name varchar 255
inventoryview object varchar 255
inventoryview search varchar 255  √  null
inventoryview sort varchar 100  √  null
inventoryview style enum 7
inventoryviewreport id bigint 19
inventoryviewreport reportExportCount int 10 0
inventoryviewreport reportName varchar 255
inventoryviewreport reportObjectType varchar 255
inventoryviewreport reportTimeRangeInHours int 10  √  null
inventoryviewreport reportType varchar 255  √  CSV
inventoryviewschedule createdBy varchar 255
inventoryviewschedule createdTimestamp timestamp 19 CURRENT_TIMESTAMP(3)
inventoryviewschedule day enum 9  √  null
inventoryviewschedule format enum 4
inventoryviewschedule id bigint 19  √ 
inventoryviewschedule intervalUnit enum 7
inventoryviewschedule name varchar 255
inventoryviewschedule recipients varchar 255
inventoryviewschedule startTime varchar 20
inventoryviewschedule viewId bigint 19
job category varchar 32
job compensationJob_id varchar 64  √  null
job completedTimestamp timestamp 19  √  null
job contextObject_id bigint 19  √  null
job contextObject_type varchar 100  √  null
job id varchar 64
job job longblob 2147483647  √  null
job jobType varchar 64
job name varchar 280
job status varchar 32
job submittedTimestamp timestamp 19 CURRENT_TIMESTAMP
jobreportview completedTimestamp timestamp 19  √  null
jobreportview id varchar 64
jobreportview jobType varchar 64
jobreportview name varchar 280
jobreportview state varchar 9
jobreportview status int 10 0
jobreportview submittedTimestamp timestamp 19 0000-00-00 00:00:00
ldapserver address varchar 255
ldapserver id bigint 19
ldapserver objVersion int 10
ldapserver port int 10  √  null
license id bigint 19
license licenseData varchar 10000
license uuid varchar 50  √  null
lifcountperigrouplistdtoview igroupId bigint 19 Locally unique object identifier. ZAPIs: igroup-get-iter.initiator-group-info
lifcountperigrouplistdtoview LIFMappingCount bigint 19 0
lifcountperigrouplistdtoview portSetName varchar 255 Textual name
logicalinterface cluster_id bigint 19  √  null
logicalinterface healthStatus int 10
logicalinterface id bigint 19
logicalinterface lastSync bigint 19
logicalinterface owner_id bigint 19
logicalinterface owner_type varchar 100
logicalinterface resource_type varchar 40
logicalinterfacelivelistdtoview address varchar 255  √  null
logicalinterfacelivelistdtoview adminStatus varchar 255  √  null
logicalinterfacelivelistdtoview clusterHealthStatus int 10  √  null
logicalinterfacelivelistdtoview clusterId bigint 19
logicalinterfacelivelistdtoview clusterName varchar 255 Textual name
logicalinterfacelivelistdtoview currentPortHealthStatus bigint 19  √  null
logicalinterfacelivelistdtoview currentPortId bigint 19  √  null
logicalinterfacelivelistdtoview currentPortName varchar 511  √  null
logicalinterfacelivelistdtoview dataProtocols varchar 255  √  null Specifies the list of data protocols configured on the LIF. This can be comma separated. Possible values: nfs, cifs, iscsi, fcp, fc_nvme, fcache, none
logicalinterfacelivelistdtoview failoverGroup varchar 255  √  null The cluster-wide unique name of the failover group.
logicalinterfacelivelistdtoview failoverPolicy varchar 255  √  null
logicalinterfacelivelistdtoview healthStatus int 10  √  null
logicalinterfacelivelistdtoview homePortHealthStatus bigint 19  √  null
logicalinterfacelivelistdtoview homePortId bigint 19  √  null
logicalinterfacelivelistdtoview homePortName varchar 511  √  null
logicalinterfacelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: net-interface-get-iter.net-interface-info
logicalinterfacelivelistdtoview name varchar 255 Textual name
logicalinterfacelivelistdtoview ownerHealthStatus bigint 19  √  null
logicalinterfacelivelistdtoview ownerId bigint 19  √  null
logicalinterfacelivelistdtoview ownerName varchar 255  √  null
logicalinterfacelivelistdtoview portsetNames text 65535  √  null
logicalinterfacelivelistdtoview role varchar 255  √  null
logicalinterfacelivelistdtoview routingGroupId bigint 19  √  null
logicalinterfacelivelistdtoview routingGroupName varchar 255  √  null
logicalinterfacelivelistdtoview status varchar 255  √  null
lun cluster_id bigint 19  √  null
lun healthStatus int 10
lun id bigint 19
lun lastSync bigint 19
lun name varchar 255
lun qtree_id bigint 19  √  null
luncountperigrouplistdtoview igroupId bigint 19  √  null
luncountperigrouplistdtoview LUNMappedIgroup bigint 19 0
luncountperigrouplistdtoview mappedLunIdentifier text 65535  √  null
lunlivelistdtoview container varchar 511  √  null
lunlivelistdtoview healthStatus int 10
lunlivelistdtoview Id bigint 19 Locally unique object identifier. ZAPIs: lun-get-iter.lun-info
lunlivelistdtoview isMapped bit 0  √  null Is the LUN mapped to any initiator?
lunlivelistdtoview isOnline bit 0  √  null Is LUN online?
lunlivelistdtoview isThinProvision int 10  √  null
lunlivelistdtoview lunSize bigint 19  √  null Size of the LUN in bytes
lunlivelistdtoview mappedLunIdentifier text 65535  √  null
lunlivelistdtoview name varchar 255  √  null
lunlivelistdtoview osType varchar 255  √  null The OS type of the LUN
lunlivelistdtoview qtreeHealthStatus int 10  √  null
lunlivelistdtoview qtreeId bigint 19  √  null Locally unique object identifier. ZAPIs: qtree-list-iter.qtree-info
lunlivelistdtoview qtreeName varchar 255  √  null
lunlivelistdtoview serialNumber varchar 255  √  null Serial number of the LUN
lunlivelistdtoview volumeHealthStatus int 10
lunlivelistdtoview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
lunlivelistdtoview volumeName varchar 255 Textual name
lunlivelistdtoview vserverHealthStatus int 10
lunlivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
lunlivelistdtoview vserverName varchar 255 Textual name
lunmapidperigroupdtoview lunId bigint 19
lunmapidperigroupdtoview mappedLunIdentifier text 65535  √  null
lunnodecapacitymapping assignedLunCapacity decimal 41  √  null
lunnodecapacitymapping isLunMapped int 10  √  null
lunnodecapacitymapping nodeId bigint 19  √  null
lunnodecapacitymapping unassignedLunCapacity decimal 41  √  null
maintenance_window endTime bigint 19
maintenance_window id bigint 19
maintenance_window startTime bigint 19
maintenance_window_object_mapping id bigint 19
maintenance_window_object_mapping maintenanceWindowId bigint 19
maintenance_window_object_mapping resourceId bigint 19
maintenance_window_object_mapping resourceType varchar 40
managedvolumecalculationsview dailyGrowthRatePercent double 22  √  null
managedvolumecalculationsview dailySnapshotGrowthRatePercent double 22  √  null
managedvolumecalculationsview daysUntilFull double 22  √  null
managedvolumecalculationsview snapshotReserveDaysUntilFull double 22  √  null
managedvolumecalculationsview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
managementstation healthStatus int 10
managementstation id bigint 19
managementstation objectName varchar 255
managementstation objVersion int 10
managementstation resourceKey varchar 512
manualannotationbreakdownlivelistdto annotationTypeId bigint 19  √  0
manualannotationbreakdownlivelistdto annotationTypeName varchar 255  √  null
manualannotationbreakdownlivelistdto annotationValueFullName varchar 511  √  null
manualannotationbreakdownlivelistdto annotationValueHealthStatus int 10 0
manualannotationbreakdownlivelistdto annotationValueId bigint 19 0
manualannotationbreakdownlivelistdto annotationValueName varchar 255
manualannotationbreakdownlivelistdto clusterCount decimal 23  √  null
manualannotationbreakdownlivelistdto healthStatus int 10 0
manualannotationbreakdownlivelistdto volumecount decimal 23  √  null
manualannotationbreakdownlivelistdto vservercount decimal 23  √  null
metroclusterrelationship cluster_id bigint 19  √  null
metroclusterrelationship healthStatus int 10
metroclusterrelationship id bigint 19
metroclusterrelationship objectName varchar 255
metroclusterrelationship objVersion int 10
metroclusterrelationship peerCluster_id bigint 19  √  null
metroclusterrelationship resourceKey varchar 512
namespace cluster_id bigint 19  √  null
namespace healthStatus int 10
namespace id bigint 19
namespace lastSync bigint 19
namespace name varchar 255
namespace qtree_id bigint 19  √  null
networkport cluster_id bigint 19  √  null
networkport currentLinkStatus varchar 255  √  null
networkport healthStatus int 10
networkport id bigint 19
networkport lastSync bigint 19
networkport previousLinkStatus varchar 255  √  null
nfsexportlivelistdtoview derivedStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
nfsexportlivelistdtoview exportPolicyHealthStatus int 10
nfsexportlivelistdtoview exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
nfsexportlivelistdtoview exportPolicyName varchar 255  √  null Name of the policy
nfsexportlivelistdtoview healthStatus int 10
nfsexportlivelistdtoview id bigint 19  √  null
nfsexportlivelistdtoview isJunctionPathActive bit 0  √  null If mounted volume is accessible
nfsexportlivelistdtoview isNfsEnabled int 10  √  null
nfsexportlivelistdtoview isVserverRoot bit 0  √  null Is the volume the root of a vserver
nfsexportlivelistdtoview junctionPath varchar 511  √  null
nfsexportlivelistdtoview name text 65535  √  null
nfsexportlivelistdtoview nfsExportStatus varchar 7
nfsexportlivelistdtoview qtreeHealthStatus binary 0  √  null
nfsexportlivelistdtoview qtreeId bigint 19  √  null
nfsexportlivelistdtoview qtreeName varchar 255  √  null
nfsexportlivelistdtoview securityPermission varchar 255  √  null Unix permission bits in octal string format
nfsexportlivelistdtoview securityStyle varchar 255  √  null
nfsexportlivelistdtoview unAvailableParentVolumeId bigint 19  √  null
nfsexportlivelistdtoview volumeHealthStatus int 10
nfsexportlivelistdtoview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
nfsexportlivelistdtoview volumeName varchar 255 Textual name
nfsexportlivelistdtoview volumeState varchar 255  √  null
nfsexportlivelistdtoview vserverHealthStatus int 10
nfsexportlivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
nfsexportlivelistdtoview vserverName varchar 255 Textual name
nfsexportreportview clusterFqdn varchar 255  √  null
nfsexportreportview clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
nfsexportreportview clusterName varchar 255 Textual name
nfsexportreportview exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
nfsexportreportview exportPolicyName varchar 255  √  null Name of the policy
nfsexportreportview isJunctionPathActive bit 0  √  null If mounted volume is accessible
nfsexportreportview isVserverRoot bit 0  √  null Is the volume the root of a vserver
nfsexportreportview junctionPath varchar 511  √  null
nfsexportreportview nfsStatus varchar 6
nfsexportreportview qtreeId bigint 19  √  null
nfsexportreportview qtreeName varchar 255  √  null
nfsexportreportview ruleAccessProtocol varchar 255 Client access protocol. Default value is 'any'. May be comma separated
nfsexportreportview ruleClientMatch varchar 255 Client match specification for Export rule. The clients specified are enforced with this Export rule. The rule with the higher rule index value takes precedence
nfsexportreportview ruleIndex int 10  √  null Export rule index
nfsexportreportview ruleRoRule varchar 255  √  null Rule for read-only access. Ordered, comma separated list of the array values in ONTAP.
nfsexportreportview ruleRwRule varchar 255  √  null Rule for read-write access. Ordered, comma separated list of the array values in ONTAP.
nfsexportreportview securityPermission varchar 256  √  null
nfsexportreportview securityStyle varchar 255  √  null
nfsexportreportview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
nfsexportreportview volumeName varchar 255 Textual name
nfsexportreportview volumeState varchar 255  √  null
nfsexportreportview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
nfsexportreportview vserverName varchar 255 Textual name
nodebridgeconnection bridge_id bigint 19  √  null
nodebridgeconnection cluster_id bigint 19
nodebridgeconnection healthStatus int 10
nodebridgeconnection id bigint 19
nodebridgeconnection node_id bigint 19  √  null
nodebridgeconnection objectName varchar 255
nodebridgeconnection objVersion int 10
nodebridgeconnection resourceKey varchar 512
nodebridgelink bridgePort varchar 255  √  null
nodebridgelink bridgePortWWPN varchar 255  √  null
nodebridgelink id bigint 19
nodebridgelink linkStatus int 10  √  null
nodebridgelink nodeBridgeConnection_id bigint 19  √  null
nodebridgelink nodePort varchar 255  √  null
nodebridgelink nodePortWWPN varchar 255  √  null
nodebridgelink objVersion int 10
nodebridgelink resourceKey varchar 512
nodelevelcapacitymapping aggregateBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
nodelevelcapacitymapping aggregateBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
nodelevelcapacitymapping assignedLunCapacity decimal 63  √  null
nodelevelcapacitymapping clusterId bigint 19
nodelevelcapacitymapping cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
nodelevelcapacitymapping isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
nodelevelcapacitymapping model varchar 255  √  null Hardware model of this node.
nodelevelcapacitymapping nodeId bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
nodelevelcapacitymapping nodeName varchar 255 Textual name
nodelevelcapacitymapping ontapVersion varchar 1024  √  null
nodelevelcapacitymapping partnerNodeId bigint 19  √  null
nodelevelcapacitymapping partnerNodeName varchar 255 Textual name
nodelevelcapacitymapping rawDiskBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
nodelevelcapacitymapping serialNumber varchar 255  √  null Serial number
nodelevelcapacitymapping totalVolumeCapacity decimal 41  √  null
nodelevelcapacitymapping unassignedLunCapacity decimal 63  √  null
nodelevelcapacitymapping volumeProtectionCapacity decimal 41  √  null
nodelevelcapacitymapping volumeUsedCapacity decimal 42  √  null
nodestackconnection cluster_id bigint 19
nodestackconnection healthStatus int 10
nodestackconnection id bigint 19
nodestackconnection isLocalAttach bit 1  √  null
nodestackconnection node_id bigint 19
nodestackconnection objectName varchar 255
nodestackconnection objVersion int 10
nodestackconnection peercluster_id bigint 19  √  null
nodestackconnection resourceKey varchar 512
nodestackconnection stack_id varchar 255
nodestacklink id bigint 19
nodestacklink linkStatus int 10  √  null
nodestacklink nodePort varchar 255  √  null
nodestacklink nodePortWWPN varchar 255  √  null
nodestacklink nodeStackConnection_id bigint 19  √  null
nodestacklink objVersion int 10
nodestacklink resourceKey varchar 512
nodestacklink shelfPort varchar 255  √  null
nodestacklink shelfPortWWPN varchar 255  √  null
nodeswitchconnection cluster_id bigint 19
nodeswitchconnection healthStatus int 10
nodeswitchconnection id bigint 19
nodeswitchconnection node_id bigint 19  √  null
nodeswitchconnection objectName varchar 255
nodeswitchconnection objVersion int 10
nodeswitchconnection resourceKey varchar 512
nodeswitchconnection switch_id bigint 19  √  null
nodeswitchlink id bigint 19
nodeswitchlink linkStatus int 10  √  null
nodeswitchlink nodePort varchar 255  √  null
nodeswitchlink nodePortWWPN varchar 255  √  null
nodeswitchlink nodeSwitchConnection_id bigint 19  √  null
nodeswitchlink objVersion int 10
nodeswitchlink peerType varchar 64  √  null
nodeswitchlink resourceKey varchar 512
nodeswitchlink switchPort varchar 255  √  null
nodeswitchlink switchPortWWPN varchar 255  √  null
objectstore_config cluster_id bigint 19  √  null
objectstore_config healthStatus int 10
objectstore_config id bigint 19
objectstore_config lastSync bigint 19
ocummonitoringstatus cluster_id bigint 19  √  null
ocummonitoringstatus id bigint 19  √ 
ocummonitoringstatus isEmsConfigured bit 1  √  b'0'
ocummonitoringstatus metroClusterMonitorStatus int 10 0
ontapalert cluster_id bigint 19  √  null
ontapalert id bigint 19
ontapalert lastSync bigint 19
ontapems cluster_id bigint 19
ontapems clusterNodeName varchar 255  √  null
ontapems emsCorrectiveAction varchar 4096  √  null
ontapems emsEmissionTimestamp timestamp 19 0000-00-00 00:00:00
ontapems emsEvent varchar 4096
ontapems emsGenericTriggerCondition varchar 4096  √  null
ontapems emsMessageName varchar 255
ontapems emsMessageSeverity varchar 255
ontapems id bigint 19
ontapems objVersion int 10
ontapems recievedTimestamp timestamp 19 CURRENT_TIMESTAMP
ontapemsparameter id bigint 19
ontapemsparameter objVersion int 10
ontapemsparameter ontapEms_id bigint 19  √  null
ontapemsparameter paramName varchar 255  √  null
ontapemsparameter paramValue varchar 255  √  null
ontapfaultinfo additionalInfo varchar 1023  √  null
ontapfaultinfo alertId varchar 255
ontapfaultinfo alertingResource varchar 255
ontapfaultinfo alertingResourceName varchar 255  √  null
ontapfaultinfo alertOrigin varchar 255  √  null
ontapfaultinfo cluster_id bigint 19
ontapfaultinfo correctiveActions varchar 1023  √  null
ontapfaultinfo deleteTime timestamp 19  √  null
ontapfaultinfo id bigint 19
ontapfaultinfo indicationTime timestamp 19  √  null
ontapfaultinfo isActiveAlert bit 1  √  b'1'
ontapfaultinfo lastSync bigint 19  √  null
ontapfaultinfo objVersion int 10
ontapfaultinfo perceivedSeverity varchar 1023  √  null
ontapfaultinfo possibleEffect varchar 1023  √  null
ontapfaultinfo probableCause varchar 511  √  null
ontapfaultinfo probableCauseDescription varchar 1023  √  null
ontapfaultinfo resourceKey varchar 512
ontapfaultinfo uuid varchar 255  √  null
optionchainvalue domainObject_id bigint 19
optionchainvalue domainObject_type varchar 100
optionchainvalue id bigint 19
optionchainvalue objVersion int 10
optionchainvalue optionName varchar 255
optionchainvalue optionValue varchar 255
persistentproperty id bigint 19
persistentproperty objVersion int 10
persistentproperty propertyKey varchar 255
persistentproperty propertyValue longtext 2147483647  √  null
plex cluster_id bigint 19  √  null
plex id bigint 19  √ 
plex isOnline bit 1  √  b'0'
plex lastSync bigint 19
portlivelistdtoview healthStatus int 10 0
portlivelistdtoview id bigint 19 0
portlivelistdtoview lifCount bigint 19  √  null
portlivelistdtoview name varchar 255  √  null
portlivelistdtoview nodeHealthStatus int 10  √  null
portlivelistdtoview nodeId bigint 19  √  null
portlivelistdtoview nodeName varchar 255  √  null
portlivelistdtoview objectId bigint 19 0
portlivelistdtoview portType varchar 255  √  null
portlivelistdtoview role varchar 255  √  null
portlivelistdtoview state varchar 255  √  null
portset cluster_id bigint 19  √  null
portset healthStatus int 10
portset id bigint 19
portset lastSync bigint 19
portsetnamesperlogicalinterfacedtoview lifId bigint 19 Locally unique object identifier. ZAPIs: net-interface-get-iter.net-interface-info
portsetnamesperlogicalinterfacedtoview portSetNames text 65535  √  null
qrtz_blob_triggers BLOB_DATA blob 65535  √  null
qrtz_blob_triggers SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_blob_triggers TRIGGER_GROUP varchar 200
qrtz_blob_triggers TRIGGER_NAME varchar 200
qrtz_calendars CALENDAR blob 65535
qrtz_calendars CALENDAR_NAME varchar 200
qrtz_calendars SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_cron_triggers CRON_EXPRESSION varchar 120
qrtz_cron_triggers SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_cron_triggers TIME_ZONE_ID varchar 80  √  null
qrtz_cron_triggers TRIGGER_GROUP varchar 200
qrtz_cron_triggers TRIGGER_NAME varchar 200
qrtz_fired_triggers ENTRY_ID varchar 95
qrtz_fired_triggers FIRED_TIME bigint 19
qrtz_fired_triggers INSTANCE_NAME varchar 200
qrtz_fired_triggers is_nonconcurrent bit 0  √  null
qrtz_fired_triggers is_update_data bit 0  √  null
qrtz_fired_triggers JOB_GROUP varchar 200  √  null
qrtz_fired_triggers JOB_NAME varchar 200  √  null
qrtz_fired_triggers PRIORITY int 10
qrtz_fired_triggers REQUESTS_RECOVERY varchar 1  √  null
qrtz_fired_triggers SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_fired_triggers SCHED_TIME bigint 19
qrtz_fired_triggers STATE varchar 16
qrtz_fired_triggers TRIGGER_GROUP varchar 200
qrtz_fired_triggers TRIGGER_NAME varchar 200
qrtz_job_details DESCRIPTION varchar 250  √  null
qrtz_job_details IS_DURABLE varchar 1
qrtz_job_details is_nonconcurrent bit 0  √  null
qrtz_job_details is_update_data bit 0  √  null
qrtz_job_details JOB_CLASS_NAME varchar 250
qrtz_job_details JOB_DATA blob 65535  √  null
qrtz_job_details JOB_GROUP varchar 200
qrtz_job_details JOB_NAME varchar 200
qrtz_job_details REQUESTS_RECOVERY varchar 1
qrtz_job_details SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_locks LOCK_NAME varchar 40
qrtz_locks SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_paused_trigger_grps SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_paused_trigger_grps TRIGGER_GROUP varchar 200
qrtz_scheduler_state CHECKIN_INTERVAL bigint 19
qrtz_scheduler_state INSTANCE_NAME varchar 200
qrtz_scheduler_state LAST_CHECKIN_TIME bigint 19
qrtz_scheduler_state SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_simple_triggers REPEAT_COUNT bigint 19
qrtz_simple_triggers REPEAT_INTERVAL bigint 19
qrtz_simple_triggers SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_simple_triggers TIMES_TRIGGERED bigint 19
qrtz_simple_triggers TRIGGER_GROUP varchar 200
qrtz_simple_triggers TRIGGER_NAME varchar 200
qrtz_simprop_triggers BOOL_PROP_1 bit 0  √  null
qrtz_simprop_triggers BOOL_PROP_2 bit 0  √  null
qrtz_simprop_triggers DEC_PROP_1 decimal 13,4  √  null
qrtz_simprop_triggers DEC_PROP_2 decimal 13,4  √  null
qrtz_simprop_triggers INT_PROP_1 int 10  √  null
qrtz_simprop_triggers INT_PROP_2 int 10  √  null
qrtz_simprop_triggers LONG_PROP_1 bigint 19  √  null
qrtz_simprop_triggers LONG_PROP_2 bigint 19  √  null
qrtz_simprop_triggers SCHED_NAME varchar 120
qrtz_simprop_triggers STR_PROP_1 varchar 512  √  null
qrtz_simprop_triggers STR_PROP_2 varchar 512  √  null
qrtz_simprop_triggers STR_PROP_3 varchar 512  √  null
qrtz_simprop_triggers TRIGGER_GROUP varchar 200
qrtz_simprop_triggers TRIGGER_NAME varchar 200
qrtz_triggers CALENDAR_NAME varchar 200  √  null
qrtz_triggers DESCRIPTION varchar 250  √  null
qrtz_triggers END_TIME bigint 19  √  null
qrtz_triggers JOB_DATA blob 65535  √  null
qrtz_triggers JOB_GROUP varchar 200
qrtz_triggers JOB_NAME varchar 200
qrtz_triggers MISFIRE_INSTR smallint 5  √  null
qrtz_triggers NEXT_FIRE_TIME bigint 19  √  null
qrtz_triggers PREV_FIRE_TIME bigint 19  √  null
qrtz_triggers PRIORITY int 10  √  null
qrtz_triggers SCHED_NAME varchar 120 unifiedManagerScheduler
qrtz_triggers START_TIME bigint 19
qrtz_triggers TRIGGER_GROUP varchar 200
qrtz_triggers TRIGGER_NAME varchar 200
qrtz_triggers TRIGGER_STATE varchar 16
qrtz_triggers TRIGGER_TYPE varchar 8
qtree cluster_id bigint 19  √  null
qtree healthStatus int 10
qtree id bigint 19
qtree lastSync bigint 19
qtree quota_id bigint 19  √  null
qtreecapacityutilizationreportview clusterFqdn varchar 255  √  null
qtreecapacityutilizationreportview clusterId bigint 19 0
qtreecapacityutilizationreportview clusterName varchar 255
qtreecapacityutilizationreportview diskHardLimit bigint 19  √  null
qtreecapacityutilizationreportview diskHardLimitUnlimited tinyint 3  √  null
qtreecapacityutilizationreportview diskSoftLimit bigint 19  √  null
qtreecapacityutilizationreportview diskSoftLimitUnlimited tinyint 3  √  null
qtreecapacityutilizationreportview diskThreshold bigint 19  √  null
qtreecapacityutilizationreportview diskThresholdUnlimited tinyint 3  √  null
qtreecapacityutilizationreportview diskTotal bigint 19  √  null
qtreecapacityutilizationreportview diskUsed bigint 19  √  null
qtreecapacityutilizationreportview diskUsedPercent decimal 30,4  √  null
qtreecapacityutilizationreportview fileHardLimit bigint 19  √  null
qtreecapacityutilizationreportview fileHardLimitUnlimited tinyint 3  √  null
qtreecapacityutilizationreportview fileSoftLimit bigint 19  √  null
qtreecapacityutilizationreportview fileSoftLimitUnlimited tinyint 3  √  null
qtreecapacityutilizationreportview fileUsed bigint 19  √  null
qtreecapacityutilizationreportview fileUsedPercent decimal 26,4  √  null
qtreecapacityutilizationreportview fileUsedUnlimited tinyint 3  √  null
qtreecapacityutilizationreportview healthStatus int 10  √  null
qtreecapacityutilizationreportview isQuotaSet bigint 19 0
qtreecapacityutilizationreportview qtreeId bigint 19  √  null
qtreecapacityutilizationreportview qtreeName varchar 255  √  null
qtreecapacityutilizationreportview quotaId bigint 19  √  null
qtreecapacityutilizationreportview quotaType varchar 10  √  null
qtreecapacityutilizationreportview quotaUserName text 65535  √  null
qtreecapacityutilizationreportview status varchar 12  √  null
qtreecapacityutilizationreportview volumeId bigint 19 0
qtreecapacityutilizationreportview volumeName varchar 255
qtreecapacityutilizationreportview vserverId bigint 19 0
qtreecapacityutilizationreportview vserverName varchar 255
qtreelivelistdtoview diskHardLimit bigint 19  √  null
qtreelivelistdtoview diskHardLimitUnlimited bit 0  √  1 True if there is no disk limit
qtreelivelistdtoview diskSoftLimit bigint 19  √  null
qtreelivelistdtoview diskSoftLimitUnlimited bit 0  √  1 True if there is no soft disk limit
qtreelivelistdtoview diskThreshold bigint 19  √  null
qtreelivelistdtoview diskThresholdUnlimited bit 0  √  1 True if there is no threshold limit
qtreelivelistdtoview diskTotal bigint 19  √  null
qtreelivelistdtoview diskUsed bigint 19  √  null
qtreelivelistdtoview diskUsedPercent decimal 30,4  √  null
qtreelivelistdtoview fileHardLimit bigint 19  √  null
qtreelivelistdtoview fileHardLimitUnlimited bit 0  √  1 True if there is no file limit
qtreelivelistdtoview fileSoftLimit bigint 19  √  null
qtreelivelistdtoview fileSoftLimitUnlimited bit 0  √  1 True if there is no soft file limit
qtreelivelistdtoview fileUsed bigint 19  √  null Current number of files used by the quota target
qtreelivelistdtoview fileUsedPercent decimal 26,4  √  null
qtreelivelistdtoview fileUsedUnlimited bit 0  √  1 True if there is no limit for file used
qtreelivelistdtoview healthStatus int 10
qtreelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: qtree-list-iter.qtree-info
qtreelivelistdtoview isQuotaSet int 10 0
qtreelivelistdtoview name varchar 255  √  null
qtreelivelistdtoview qtreeId bigint 19  √  null Reference to the qtree to which this quota applies
qtreelivelistdtoview volumeHealthStatus int 10
qtreelivelistdtoview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
qtreelivelistdtoview volumeName varchar 255 Textual name
qtreelivelistdtoview vserverHealthStatus int 10
qtreelivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
qtreelivelistdtoview vserverName varchar 255 Textual name
readytaskworkitemqueueentry attributeName varchar 64  √  null
readytaskworkitemqueueentry attributeValue varchar 64  √  null
readytaskworkitemqueueentry id bigint 19
readytaskworkitemqueueentry objVersion int 10
readytaskworkitemqueueentry running bit 1
readytaskworkitemqueueentry workItem longblob 2147483647
readytaskworkitemqueueentry workItemId varchar 64
resourcepool capacityAvailable bigint 19
resourcepool capacityTotal bigint 19
resourcepool capacityUsed bigint 19
resourcepool description longtext 2147483647  √  null
resourcepool id bigint 19
resourcepool objectName varchar 255
resourcepool objVersion int 10
resourcepool resourceKey varchar 512
resourcepool snapLockType longtext 2147483647  √  null
resourcepoolaggregates aggregate_id bigint 19
resourcepoolaggregates resourcePool_id bigint 19
resourcepoollivelistdtoview capacityAvailable bigint 19
resourcepoollivelistdtoview capacityTotal bigint 19
resourcepoollivelistdtoview capacityUsed bigint 19
resourcepoollivelistdtoview capacityUsedPercent decimal 26,4  √  null
resourcepoollivelistdtoview description longtext 2147483647  √  null
resourcepoollivelistdtoview id bigint 19
resourcepoollivelistdtoview name varchar 255
resourcepoollivelistdtoview resourceKey varchar 512
resourcepoollivelistdtoview snapLockType longtext 2147483647  √  null
role id bigint 19
role objectName varchar 255
role objVersion int 10
routinggrouproutesview gateway varchar 255  √  null The IP address and subnet mask of destination
routinggrouproutesview id bigint 19
routinggrouproutesview route varchar 255  √  null The IP address and subnet mask of destination
routinggrouproutesview routingGroupId bigint 19  √  null
ruletemplate expression longtext 2147483647
ruletemplate id bigint 19
ruletemplate name varchar 255
ruletemplate objVersion int 10
script description varchar 1024  √  null
script id bigint 19
script name varchar 255
scriptlivelistdtoview description varchar 1024  √  null
scriptlivelistdtoview id bigint 19
scriptlivelistdtoview name varchar 255
selectioncriterion annotationRuleId bigint 19  √  null
selectioncriterion groupMembershipRuleId bigint 19  √  null
selectioncriterion id bigint 19  √ 
selectioncriterion ruleType varchar 32
serviceworkflow description varchar 1024
serviceworkflow healthStatus int 10
serviceworkflow id bigint 19
serviceworkflow objectName varchar 255
serviceworkflow objVersion int 10
serviceworkflow resourceKey varchar 512
serviceworkflow type varchar 64
serviceworkflow uuid varchar 64
snapmirrorrelationship calculatedLagErrorThreshold bigint 19  √  null
snapmirrorrelationship calculatedLagWarningThreshold bigint 19  √  null
snapmirrorrelationship cluster_id bigint 19  √  null
snapmirrorrelationship healthStatus int 10
snapmirrorrelationship id bigint 19
snapmirrorrelationship isVersionFlexibleReplicationEnabled enum 15 none
snapmirrorrelationship lagStatus enum 7  √  null
snapmirrorrelationship lastSuccessfulTransferDuration bigint 19  √  null
snapmirrorrelationship lastSuccessfulTransferEndTimestamp timestamp 19  √  null
snapmirrorrelationship lastSuccessfulTransferSize bigint 19  √  null
snapmirrorrelationship lastSync bigint 19
snapmirrorrelationship name varchar 2048
snapmirrorrelationship overallStatus enum 7  √  null
snapmirrortransfer bytesTransferred bigint 19  √  null
snapmirrortransfer dataCollectionTimestamp timestamp 19 CURRENT_TIMESTAMP
snapmirrortransfer id bigint 19
snapmirrortransfer isMissingData bit 1  √  null
snapmirrortransfer lagDuration bigint 19  √  null
snapmirrortransfer lagErrorThreshold bigint 19  √  null
snapmirrortransfer lagWarningThreshold bigint 19  √  null
snapmirrortransfer lastTransferEndTimestamp timestamp 19  √  null
snapmirrortransfer objVersion int 10
snapmirrortransfer snapMirrorRelationshipId bigint 19  √  null
snapmirrortransfer state enum 12  √  null
snapmirrortransfer transferDuration bigint 19  √  null
snapmirrortransfer transferError varchar 1024  √  null
snapshotexpirerecord expirationRequestTimestamp timestamp 19 CURRENT_TIMESTAMP
snapshotexpirerecord id bigint 19
snapshotexpirerecord lastDeleteAttemptTimestamp timestamp 19  √  null
snapshotexpirerecord objVersion int 10
snapshotexpirerecord snapshotResourceKey varchar 512
snapshotmetadata fieldName varchar 255
snapshotmetadata fieldValue varchar 16384
snapshotmetadata id bigint 19
snapshotmetadata objVersion int 10
snapshotmetadata snapshotResourceKey varchar 512
snapshotpolicy cluster_id bigint 19  √  null
snapshotpolicy healthStatus int 10
snapshotpolicy id bigint 19
snapshotpolicy lastSync bigint 19
storagearray arrayId decimal 20  √  null
storagearray firmwareRevision varchar 128  √  null
storagearray id bigint 19
storagearray managementAddress varchar 64  √  null
storagearray model varchar 255  √  null
storagearray objVersion int 10
storagearray prefix varchar 16  √  null
storagearray serialNumber varchar 64
storagearray vendor varchar 255
storagearrayclusterassociation cluster_id bigint 19
storagearrayclusterassociation id bigint 19
storagearrayclusterassociation idOnCluster decimal 20  √  null
storagearrayclusterassociation nameOnCluster varchar 64  √  null
storagearrayclusterassociation objVersion int 10
storagearrayclusterassociation storageArray_id bigint 19
storagearraylunpath diskName varchar 255  √  null
storagearraylunpath id bigint 19
storagearraylunpath isPrimaryPath bit 1
storagearraylunpath loadPercent float 12  √  null
storagearraylunpath lunIops decimal 20  √  null
storagearraylunpath lunNumber int 10  √  null
storagearraylunpath objVersion int 10
storagearraylunpath storageArrayLUN_id bigint 19  √  null
storagearraylunpath storageArrayPort_id bigint 19  √  null
storagearraylunpath storageArrayPortWwpn varchar 64  √  null
storagearraylunpath switchName varchar 64  √  null
storagearraylunpath switchPort varchar 64  √  null
storagearrayport id bigint 19
storagearrayport objVersion int 10
storagearrayport storageArray_id bigint 19
storagearrayport wwnn varchar 64
storagearrayport wwpn varchar 64
storagearrayportclusterassociation cluster_id bigint 19
storagearrayportclusterassociation storageArrayPort_id bigint 19
storageclass cluster_id bigint 19  √  null
storageclass healthStatus int 10
storageclass id bigint 19
storageclass lastSync bigint 19
storageservice clientTag varchar 32  √  null
storageservice description varchar 255  √  null
storageservice healthStatus int 10
storageservice id bigint 19
storageservice isMarkedForDeletion bit 1
storageservice objectName varchar 255
storageservice objVersion int 10
storageservice owner varchar 64  √  null
storageservice resourceKey varchar 512
storageservice_contacts contact varchar 255
storageservice_contacts storageService_id bigint 19
storageserviceconnection connectionType varchar 64
storageserviceconnection destinationNode_id bigint 19
storageserviceconnection id bigint 19
storageserviceconnection isLagErrorEnabled bit 1  √  null
storageserviceconnection isLagWarningEnabled bit 1  √  null
storageserviceconnection isNetworkCompressionEnabled bit 1 b'0'
storageserviceconnection lagErrorThreshold bigint 19  √  null
storageserviceconnection lagWarningThreshold bigint 19  √  null
storageserviceconnection maxTransferRate bigint 19  √  null
storageserviceconnection objVersion int 10
storageserviceconnection resourceKey varchar 512
storageserviceconnection sourceNode_id bigint 19
storageserviceconnection storageService_id bigint 19
storageserviceconnectionmember connection_id bigint 19
storageserviceconnectionmember destinationNodeMember_id bigint 19
storageserviceconnectionmember id bigint 19
storageserviceconnectionmember initialRelationshipId bigint 19  √  null
storageserviceconnectionmember objVersion int 10
storageserviceconnectionmember relationship_id bigint 19  √  null
storageserviceconnectionmember rootMemberInfo_id bigint 19
storageserviceconnectionmember sourceNodeMember_id bigint 19
storageservicenode id bigint 19
storageservicenode isThinProvision bit 1 b'1'
storageservicenode nodeName varchar 255
storageservicenode objVersion int 10
storageservicenode resourceKey varchar 512
storageservicenode serviceWorkflow_id bigint 19  √  null
storageservicenode storageService_id bigint 19
storageservicenodemember id bigint 19
storageservicenodemember initialClusterName varchar 255
storageservicenodemember initialVolumeFullName varchar 512
storageservicenodemember initialVolumeId bigint 19  √  null
storageservicenodemember initialVolumeInstanceUuid varchar 255
storageservicenodemember initialVolumeName varchar 255
storageservicenodemember initialVolumeResourceKey varchar 512  √  null
storageservicenodemember initialVserverName varchar 255
storageservicenodemember node_id bigint 19
storageservicenodemember objVersion int 10
storageservicenodemember rootMemberInfo_id bigint 19
storageservicenodemember volume_id bigint 19  √  null
storageservicenoderesourcepool resourcePool_id bigint 19
storageservicenoderesourcepool storageServiceNode_id bigint 19
storageservicerootmemberinfo id bigint 19
storageservicerootmemberinfo objVersion int 10
storageservicerootmemberinfo rootNodeMember_id bigint 19  √  null
storageservicerootmemberinfo storageService_id bigint 19
storageservicesubscription context varchar 255
storageservicesubscription id bigint 19
storageservicesubscription objVersion int 10
storageservicesubscription resourceKey varchar 512
storageservicesubscription storageService_id bigint 19
storageservicesubscription_metadatafields fieldName varchar 255
storageservicesubscription_metadatafields fieldValue longtext 2147483647
storageservicesubscription_metadatafields StorageServiceSubscription_id bigint 19
storageservicesubscriptionrootmember rootMemberInfo_id bigint 19
storageservicesubscriptionrootmember subscription_id bigint 19
storageservicevserverdestination connectionType varchar 32
storageservicevserverdestination destinationVserver_id bigint 19
storageservicevserverdestination id bigint 19
storageservicevserverdestination objVersion int 10
storageservicevserverdestination sourceVserver_id bigint 19  √  null
storageshelf cluster_id bigint 19  √  null
storageshelf healthStatus int 10
storageshelf id bigint 19
storageshelf lastSync bigint 19
storageshelf name varchar 40  √  null
storagesummary aggregateCapacity decimal 10,3  √  null
storagesummary aggregateUsedCapacity decimal 10,3  √  null
storagesummary allocatedLunCapacity decimal 10,3  √  null
storagesummary clusterFqdn varchar 255  √  null
storagesummary clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
storagesummary clusterName varchar 255 Textual name
storagesummary haPair varchar 255  √  null
storagesummary model varchar 255  √  null Hardware model of this node.
storagesummary ontapVersion varchar 1024  √  null
storagesummary rawCapacity decimal 10,3  √  null
storagesummary resourceKey varchar 512
storagesummary totalClusterStorageGridCapacitySpaceUsed decimal 10,3  √  null
storagesummary totalExternalCapacityTierLicensedSpace decimal 10,3  √  null
storagesummary totalExternalCapacityTierLicensedSpaceUsed decimal 10,3  √  null
storagesummary unallocatedLunCapacity decimal 10,3  √  null
storagesummary unconfiguredRawCapacity decimal 10,3  √  null
storagesummary volumeCapacity decimal 10,3  √  null
storagesummary volumeProtectionCapacity decimal 10,3  √  null
storagesummary volumeUsedCapacity decimal 10,3  √  null
subscribedems description varchar 4096  √  null
subscribedems id bigint 19
subscribedems isEnabled bit 1 b'1'
subscribedems messageName varchar 255
subscribedems status varchar 30  √  null
svmrelationshiplivelistdtoview destinationClusterHealthStatus int 10
svmrelationshiplivelistdtoview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
svmrelationshiplivelistdtoview destinationClusterName varchar 255 Textual name
svmrelationshiplivelistdtoview destinationVserverHealthStatus int 10
svmrelationshiplivelistdtoview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
svmrelationshiplivelistdtoview destinationVserverName varchar 255 Textual name
svmrelationshiplivelistdtoview healthStatus int 10
svmrelationshiplivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
svmrelationshiplivelistdtoview isHealthy bit 0  √  null False if the last manual or scheduled update failed or was aborted, or if the last scheduled update was delayed. Otherwise true
svmrelationshiplivelistdtoview lagDuration bigint 19  √  null
svmrelationshiplivelistdtoview lagStatus enum 7  √  null
svmrelationshiplivelistdtoview lastSuccessfulUpdateTime bigint 19  √  null
svmrelationshiplivelistdtoview lastTransferDuration bigint 19  √  null
svmrelationshiplivelistdtoview lastTransferSize bigint 19  √  null The total number of bytes transferred as part of the last transfer. ZAPI: snapmirror-info.last-transfer-size
svmrelationshiplivelistdtoview name varchar 2048
svmrelationshiplivelistdtoview objectId bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
svmrelationshiplivelistdtoview overallStatus enum 7  √  null
svmrelationshiplivelistdtoview relationshipState varchar 255  √  null Raw mirror state enum value
svmrelationshiplivelistdtoview relationshipStatus varchar 255  √  null Raw relationship status enum value
svmrelationshiplivelistdtoview scheduleId bigint 19  √  null
svmrelationshiplivelistdtoview scheduleName varchar 255  √  null The name of the job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-name
svmrelationshiplivelistdtoview snapMirrorPolicyId bigint 19  √  null
svmrelationshiplivelistdtoview snapMirrorPolicyName varchar 255  √  null The name of the policy.
svmrelationshiplivelistdtoview sourceClusterHealthStatus int 10  √  null
svmrelationshiplivelistdtoview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
svmrelationshiplivelistdtoview sourceClusterName varchar 255  √  null Textual name
svmrelationshiplivelistdtoview sourceVserverHealthStatus int 10  √  null
svmrelationshiplivelistdtoview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
svmrelationshiplivelistdtoview sourceVserverName varchar 255  √  null Textual name
switch cluster_id bigint 19
switch domainId int 10  √  null
switch fabricName varchar 255  √  null
switch firmwareVersion varchar 255  √  null
switch healthStatus int 10
switch id bigint 19
switch ipAddress varchar 255  √  null
switch model varchar 255  √  null
switch objectName varchar 255
switch objVersion int 10
switch resourceKey varchar 512
switch role varchar 20  √  null
switch status varchar 255  √  null
switch totalFanCount int 10  √  null
switch totalpowerSupplyCount int 10  √  null
switch totalTemperatureSensorCount int 10  √  null
switch vendor varchar 20  √  null
switch wwn varchar 255
switchbridgeconnection bridge_id bigint 19  √  null
switchbridgeconnection cluster_id bigint 19
switchbridgeconnection healthStatus int 10
switchbridgeconnection id bigint 19
switchbridgeconnection objectName varchar 255
switchbridgeconnection objVersion int 10
switchbridgeconnection resourceKey varchar 512
switchbridgeconnection switch_id bigint 19  √  null
switchbridgelink bridgePort varchar 255  √  null
switchbridgelink bridgePortWWPN varchar 255  √  null
switchbridgelink id bigint 19
switchbridgelink linkStatus int 10  √  null
switchbridgelink objVersion int 10
switchbridgelink resourceKey varchar 512
switchbridgelink switchBridgeConnection_id bigint 19  √  null
switchbridgelink switchPort varchar 255  √  null
switchbridgelink switchPortWWPN varchar 255  √  null
switchinterswitchrelationship interSwitchConnection_id bigint 19
switchinterswitchrelationship switch_id bigint 19
targetportalgroup cluster_id bigint 19  √  null
targetportalgroup healthStatus int 10
targetportalgroup id bigint 19
targetportalgroup lastSync bigint 19
task completedTimestamp timestamp 19  √  null
task data longtext 2147483647  √  null
task dependencyOrder int 10
task description longtext 2147483647  √  null
task failureReason longtext 2147483647  √  null
task id varchar 64
task job_id varchar 64
task name varchar 2048
task priority varchar 32
task reportable bit 1
task startedTimestamp timestamp 19  √  null
task status varchar 32
task task longblob 2147483647  √  null
task taskGuardName varchar 255
task taskType varchar 64
taskmessage id varchar 64
taskmessage level varchar 16
taskmessage message longtext 2147483647
taskmessage task_id varchar 64
taskmessage timestamp timestamp 19 CURRENT_TIMESTAMP
taskobjectinteraction object_fullName varchar 2000
taskobjectinteraction object_id bigint 19
taskobjectinteraction object_resourceKey varchar 512
taskobjectinteraction object_type varchar 100
taskobjectinteraction task_id varchar 64
taskpredecessor task_id varchar 64
taskpredecessor taskPredecessor_id varchar 64
taskreportview completedTimestamp timestamp 19  √  null
taskreportview data longtext 2147483647  √  null
taskreportview dependencyOrder int 10
taskreportview description longtext 2147483647  √  null
taskreportview failureReason longtext 2147483647  √  null
taskreportview id varchar 64
taskreportview internalStatus varchar 32
taskreportview jobId varchar 64
taskreportview name varchar 2048
taskreportview priority varchar 32
taskreportview reportable bit 1
taskreportview startedTimestamp timestamp 19  √  null
taskreportview status int 10  √  null
taskreportview taskGuardName varchar 255
taskreportview taskState varchar 32  √  null
taskreportview taskType varchar 64
taskretry id varchar 64
taskretry job_id varchar 64
taskretry task_id varchar 64
taskretry timeRetryAt timestamp 19  √  null
taskstatuschange changeSequence int 10
taskstatuschange id varchar 64
taskstatuschange status varchar 32
taskstatuschange task_id varchar 64
taskstatuschange timestamp timestamp 19 CURRENT_TIMESTAMP
taskstatuschangeview changeSequence int 10
taskstatuschangeview id varchar 64
taskstatuschangeview status int 10  √  null
taskstatuschangeview taskId varchar 64
taskstatuschangeview taskState varchar 32  √  null
taskstatuschangeview timestamp timestamp 19 0000-00-00 00:00:00
thresholdobjectstocheck dataSource_id bigint 19
thresholdobjectstocheck insertionTimestamp timestamp 19 CURRENT_TIMESTAMP
thresholdobjectstocheck object_fullName varchar 2000
thresholdobjectstocheck object_id bigint 19
thresholdobjectstocheck object_ResourceKey varchar 512
thresholdobjectstocheck object_type varchar 100
trap event_id bigint 19  √  null
trap id bigint 19
trap objVersion int 10
trap severity varchar 16
trap source_id bigint 19  √  null
trap trapTimestamp timestamp 19  √  null
trap trapType varchar 32
trapvarbinding id bigint 19
trapvarbinding mibSymbol varchar 128  √  null
trapvarbinding objVersion int 10
trapvarbinding oid varchar 128
trapvarbinding trap_id bigint 19  √  null
trapvarbinding varValue varchar 1024  √  null
userquota cluster_id bigint 19  √  null
userquota emailAddress varchar 255  √  null
userquota emailGeneratedTime timestamp 19  √  null
userquota healthStatus int 10
userquota id bigint 19
userquota isEdited bit 1 b'0'
userquota lastSync bigint 19
userquota name varchar 1024  √  null
userquota qtree_id bigint 19  √  null
userquotalivelistdtoview diskHardLimit bigint 19  √  null
userquotalivelistdtoview diskHardLimitUnlimited bit 0 1 True if there is no disk limit
userquotalivelistdtoview diskSoftLimit bigint 19  √  null
userquotalivelistdtoview diskSoftLimitUnlimited bit 0 1 True if there is no soft disk limit
userquotalivelistdtoview diskThreshold bigint 19  √  null
userquotalivelistdtoview diskThresholdUnlimited bit 0 1 True if there is no threshold limit
userquotalivelistdtoview diskTotal bigint 19  √  null
userquotalivelistdtoview diskUsed bigint 19  √  null
userquotalivelistdtoview diskUsedPercent decimal 26,4  √  null
userquotalivelistdtoview fileHardLimit bigint 19  √  null Maximum number of files allowed for the quota target
userquotalivelistdtoview fileHardLimitUnlimited bit 0 1 True if there is no file limit
userquotalivelistdtoview fileSoftLimit bigint 19  √  null Soft file limit, in number of files, for the quota target
userquotalivelistdtoview fileSoftLimitUnlimited bit 0 1 True if there is no soft file limit
userquotalivelistdtoview fileUsed bigint 19  √  null Current number of files used by the quota target
userquotalivelistdtoview fileUsedPercent decimal 26,4  √  null
userquotalivelistdtoview fileUsedUnlimited bit 0 1 True if there is no limit for file used
userquotalivelistdtoview healthStatus int 10
userquotalivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: quota-report-iter.quota
userquotalivelistdtoview qtreeHealthStatus int 10  √  null
userquotalivelistdtoview qtreeId bigint 19  √  null
userquotalivelistdtoview qtreeName varchar 255  √  null
userquotalivelistdtoview quota varchar 1024  √  null
userquotalivelistdtoview quotaSource varchar 255  √  null
userquotalivelistdtoview quotaType enum 10  √  null Type of quota
userquotalivelistdtoview volumeHealthStatus int 10
userquotalivelistdtoview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
userquotalivelistdtoview volumeName varchar 255 Textual name
userquotalivelistdtoview vserverHealthStatus int 10
userquotalivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
userquotalivelistdtoview vserverName varchar 255 Textual name
volume aggregateCount int 10  √  1
volume cluster_id bigint 19  √  null
volume dfSnapshotBytesAvail double 22  √  null
volume dfSnapshotBytesUsed double 22  √  null
volume healthStatus int 10
volume id bigint 19
volume isSnapMirrorDestination bit 1  √  b'0'
volume lastSync bigint 19
volume namespaceConstituent_id bigint 19  √  null
volume nodeCount int 10  √  1
volume systemStorageClass_id bigint 19  √  null
volume unAvailableParentVolumeId bigint 19  √  null
volumeaggregatecapacitymappingview aggrSizeAvail decimal 41  √  null
volumeaggregatecapacitymappingview GROUP_CONCAT(volumeAggregateMapping.aggregateid) text 65535  √  null
volumeaggregatecapacitymappingview styleExtendedRaw varchar 255  √  null
volumeaggregatecapacitymappingview volumeId bigint 19  √  null
volumeaggregatemappingview aggregateId bigint 19  √  null
volumeaggregatemappingview styleExtendedRaw varchar 255  √  null
volumeaggregatemappingview volumeId bigint 19  √  null
volumecalculationsview dfBytesAvailablePercent decimal 27,4  √  null
volumecalculationsview dfBytesUsedPercent decimal 26,4  √  null
volumecalculationsview dfSnapshotBytesUsedPercent double 22  √  null
volumecalculationsview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumecapacityutilizationview autoGrow int 10 0
volumecapacityutilizationview availableData decimal 26,2  √  null
volumecapacityutilizationview availableDataCapacity decimal 10,2  √  null
volumecapacityutilizationview bytesUsedPerDay double 22  √  0
volumecapacityutilizationview cacheRetentionPriority varchar 255
volumecapacityutilizationview cachingPolicy varchar 255
volumecapacityutilizationview clusterFqdn varchar 255  √  null
volumecapacityutilizationview clusterId bigint 19
volumecapacityutilizationview clusterName varchar 255  √  null
volumecapacityutilizationview compression int 10 0
volumecapacityutilizationview compressionSpaceSavings decimal 10,2  √  null
volumecapacityutilizationview dailyGrowthRate double 19,2  √  null
volumecapacityutilizationview daysToFull bigint unsigned 20  √  null
volumecapacityutilizationview deduplication int 10 0
volumecapacityutilizationview deduplicationSpaceSavings decimal 10,2  √  null
volumecapacityutilizationview inodeUtilization decimal 25,2  √  null
volumecapacityutilizationview numberOfInodesUsed bigint 19  √  null Number of user-visible files (inodes) used. This field is valid only when the volume is online. ZAPIs: volume-get-iter volume-inode-attributes files-used
volumecapacityutilizationview protectionRole varchar 14
volumecapacityutilizationview quotaCommittedCapacity decimal 10,2  √  null
volumecapacityutilizationview quotaOverCommittedCapacity decimal 10,2  √  null
volumecapacityutilizationview resourceKey varchar 255  √  null
volumecapacityutilizationview snapLockExpiryDate varchar 64  √  null
volumecapacityutilizationview snapLockType varchar 255  √  null
volumecapacityutilizationview snapshotAutoDelete int 10 0
volumecapacityutilizationview snapshotOverflow double 19,2  √  null
volumecapacityutilizationview snapshotReserveAvailable double 19,2  √  null
volumecapacityutilizationview snapshotReserveAvailableCapacity decimal 10,2  √  null
volumecapacityutilizationview snapshotReserveTotalCapacity decimal 10,2  √  null
volumecapacityutilizationview snapshotReserveUsed double 19,2  √  null
volumecapacityutilizationview snapshotReserveUsedCapacity decimal 10,2  √  null
volumecapacityutilizationview spaceGuarantee varchar 255
volumecapacityutilizationview state varchar 255
volumecapacityutilizationview thinProvisioned int 10 0
volumecapacityutilizationview tieringPolicy varchar 255
volumecapacityutilizationview totalDataCapacity decimal 10,2  √  null
volumecapacityutilizationview totalNumberOfInodes bigint 19  √  null Total user-visible file (inode) count, i.e., current maximum number of user-visible files (inodes) that this volume can currently hold. ZAPIs: volume-get-iter volume-inode-attributes files-total
volumecapacityutilizationview usedData decimal 25,2  √  null
volumecapacityutilizationview usedDataCapacity decimal 10,2  √  null
volumecapacityutilizationview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumecapacityutilizationview volumeName varchar 255 Textual name
volumecapacityutilizationview vserverId bigint 19
volumecapacityutilizationview vserverName varchar 255  √  null
volumecapacityview autoGrow int 10 0
volumecapacityview availableDataCapacity decimal 10,2  √  null
volumecapacityview availableDataPercentage decimal 26,2  √  null
volumecapacityview bytesUsedPerDay double 22  √  0
volumecapacityview cacheRetentionPriority varchar 255
volumecapacityview cachingPolicy varchar 255
volumecapacityview cluster varchar 255  √  null
volumecapacityview clusterId bigint 19
volumecapacityview compression int 10 0
volumecapacityview compressionSpaceSavings decimal 10,2  √  null
volumecapacityview dailyGrowthRatePercentage double 19,2  √  null
volumecapacityview daysToFull bigint unsigned 20  √  null
volumecapacityview deduplication int 10 0
volumecapacityview deduplicationSpaceSavings decimal 10,2  √  null
volumecapacityview inodeUtilizationPercentage decimal 25,2  √  null
volumecapacityview numberOfInodesUsed bigint 19  √  null Number of user-visible files (inodes) used. This field is valid only when the volume is online. ZAPIs: volume-get-iter volume-inode-attributes files-used
volumecapacityview protectionRole varchar 14
volumecapacityview quotaCommittedCapacity decimal 10,2  √  null
volumecapacityview quotaOverCommittedCapacity decimal 10,2  √  null
volumecapacityview resourceKey varchar 255  √  null
volumecapacityview snapLockExpiryDate varchar 64  √  null
volumecapacityview snapLockType varchar 255  √  null
volumecapacityview snapshotAutoDelete int 10 0
volumecapacityview snapshotOverflowPercentage double 19,2  √  null
volumecapacityview snapshotReserveAvailableCapacity decimal 10,2  √  null
volumecapacityview snapshotReserveAvailablePercentage double 19,2  √  null
volumecapacityview snapshotReserveTotalCapacity decimal 10,2  √  null
volumecapacityview snapshotReserveUsedCapacity decimal 10,2  √  null
volumecapacityview snapshotReserveUsedPercentage double 19,2  √  null
volumecapacityview spaceGuarantee varchar 255
volumecapacityview state varchar 255
volumecapacityview svm varchar 255  √  null
volumecapacityview svmId bigint 19
volumecapacityview thinProvisioned int 10 0
volumecapacityview tieringPolicy varchar 255
volumecapacityview totalDataCapacity decimal 10,2  √  null
volumecapacityview totalNumberOfInodes bigint 19  √  null Total user-visible file (inode) count, i.e., current maximum number of user-visible files (inodes) that this volume can currently hold. ZAPIs: volume-get-iter volume-inode-attributes files-total
volumecapacityview usedDataCapacity decimal 10,2  √  null
volumecapacityview usedDataPercentage decimal 25,2  √  null
volumecapacityview volume varchar 255 Textual name
volumecapacityview volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumedatatransferstatusview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumedatatransferstatusview destinationClusterFqdn varchar 255  √  null
volumedatatransferstatusview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumedatatransferstatusview destinationClusterName varchar 255 Textual name
volumedatatransferstatusview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumedatatransferstatusview destinationVolumeName varchar 255 Textual name
volumedatatransferstatusview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumedatatransferstatusview destinationVserverName varchar 255 Textual name
volumedatatransferstatusview operationResult int 10 0
volumedatatransferstatusview operationType varchar 255
volumedatatransferstatusview relationshipId bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
volumedatatransferstatusview sourceClusterFqdn varchar 255  √  null
volumedatatransferstatusview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumedatatransferstatusview sourceClusterName varchar 255  √  null Textual name
volumedatatransferstatusview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumedatatransferstatusview sourceVolumeName varchar 255  √  null Textual name
volumedatatransferstatusview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumedatatransferstatusview sourceVserverName varchar 255  √  null Textual name
volumedatatransferstatusview transferDuration decimal 24,3  √  null
volumedatatransferstatusview transferEndTime datetime 19  √  null
volumedatatransferstatusview transferSize decimal 23,3  √  null
volumedatatransferstatusview transferStartTime datetime 19  √  null
volumeflexgroupaggregaterelationshipview aggregateId bigint 19  √  null
volumeflexgroupaggregaterelationshipview flexgroupId bigint 19  √  null Volume ObjId of the flexgroup volume which this flexgroup constituent belongs to
volumegrowthrateinfo id bigint 19
volumegrowthrateinfo lastSampleTime timestamp 19  √  null
volumegrowthrateinfo meanGrowthRate double 22 0
volumegrowthrateinfo numRates int 10 0
volumegrowthrateinfo objVersion int 10
volumegrowthrateinfo sumOfSquaresOfDifferencesFromMean double 22 0
volumegrowthrateinfo volume_id bigint 19
volumehistorymonth dfKBytesCloneSpaceSavingsSum bigint 19 0
volumehistorymonth dfKBytesCompressionSpaceSavingsSum bigint 19 0
volumehistorymonth dfKBytesDedupeSpaceSavingsSum bigint 19 0
volumehistorymonth dfKBytesTotal bigint 19 0
volumehistorymonth dfKBytesUsedSum bigint 19 0
volumehistorymonth dfSnapshotKBytesTotal bigint 19 0
volumehistorymonth dfSnapshotKBytesUsedSum bigint 19 0
volumehistorymonth overwriteReserveSpaceAvailSum bigint 19 0
volumehistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
volumehistorymonth sampleCount int 10 1
volumehistorymonth volumeId bigint 19
volumehistoryweek dfKBytesCloneSpaceSavingsSum bigint 19 0
volumehistoryweek dfKBytesCompressionSpaceSavingsSum bigint 19 0
volumehistoryweek dfKBytesDedupeSpaceSavingsSum bigint 19 0
volumehistoryweek dfKBytesTotal bigint 19 0
volumehistoryweek dfKBytesUsedSum bigint 19 0
volumehistoryweek dfSnapshotKBytesTotal bigint 19 0
volumehistoryweek dfSnapshotKBytesUsedSum bigint 19 0
volumehistoryweek overwriteReserveSpaceAvailSum bigint 19 0
volumehistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
volumehistoryweek sampleCount int 10 1
volumehistoryweek volumeId bigint 19
volumehistoryyear dfKBytesCloneSpaceSavingsSum bigint 19 0
volumehistoryyear dfKBytesCompressionSpaceSavingsSum bigint 19 0
volumehistoryyear dfKBytesDedupeSpaceSavingsSum bigint 19 0
volumehistoryyear dfKBytesTotal bigint 19 0
volumehistoryyear dfKBytesUsedSum bigint 19 0
volumehistoryyear dfSnapshotKBytesTotal bigint 19 0
volumehistoryyear dfSnapshotKBytesUsedSum bigint 19 0
volumehistoryyear overwriteReserveSpaceAvailSum bigint 19 0
volumehistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
volumehistoryyear sampleCount int 10 1
volumehistoryyear volumeId bigint 19
volumejunctionpathhistory changedTime bigint 19
volumejunctionpathhistory id bigint 19
volumejunctionpathhistory junctionPath varchar 255  √  null
volumejunctionpathhistory objVersion int 10
volumejunctionpathhistory volume_id bigint 19
volumelivelistdtoview aggregateCount int 10  √  1
volumelivelistdtoview aggregateHealthStatus int 10  √  null
volumelivelistdtoview aggregateId bigint 19  √  null Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
volumelivelistdtoview aggregateName varchar 255  √  null Textual name
volumelivelistdtoview cacheRetentionPriority varchar 255  √  null raw cache retention priority associated with volumes
volumelivelistdtoview cachingPolicy varchar 255  √  null raw cache policy associated with volumes
volumelivelistdtoview clusterFqdn varchar 255  √  null
volumelivelistdtoview clusterHealthStatus int 10
volumelivelistdtoview clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumelivelistdtoview clusterName varchar 255 Textual name
volumelivelistdtoview clusterNodeHealthStatus int 10  √  null
volumelivelistdtoview clusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
volumelivelistdtoview clusterNodeName varchar 255  √  null Textual name
volumelivelistdtoview clusterVersion varchar 255  √  null Version of the cluster
volumelivelistdtoview clusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumelivelistdtoview clusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumelivelistdtoview clusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumelivelistdtoview compressionState int 10  √  null
volumelivelistdtoview constituentRole varchar 255  √  null
volumelivelistdtoview dedupeEnabled int 10  √  null
volumelivelistdtoview dfBytesActualSize bigint 19  √  null Size of volume in bytes. Includes WAFL reserve and snapshot reserve
volumelivelistdtoview dfBytesAvail bigint 19  √  null
volumelivelistdtoview dfBytesAvailablePercent decimal 27,4  √  null
volumelivelistdtoview dfBytesLogicalSpaceUsedPercent int 10  √  null Total used logical space available in the volume in terms of percentage
volumelivelistdtoview dfBytesTotal bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
volumelivelistdtoview dfBytesUsed bigint 19  √  null Used size of the volume in bytes
volumelivelistdtoview dfBytesUsedPercent decimal 26,4  √  null
volumelivelistdtoview healthStatus int 10
volumelivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumelivelistdtoview isCftPrecommit int 10  √  null
volumelivelistdtoview isThinProvisioned int 10  √  null
volumelivelistdtoview junctionPath varchar 255  √  null
volumelivelistdtoview lastVolumeMoveState varchar 40  √  null
volumelivelistdtoview localSnapshotPolicyName varchar 255  √  null A human readable string describing the name of the snapshot scheduling policy.
volumelivelistdtoview logicalSpaceReportingStatus varchar 13
volumelivelistdtoview name varchar 255 Textual name
volumelivelistdtoview nodeCount int 10  √  1
volumelivelistdtoview objectId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumelivelistdtoview protectionRole varchar 13
volumelivelistdtoview snapLockType varchar 255  √  null
volumelivelistdtoview state varchar 255  √  null
volumelivelistdtoview storageClassName varchar 255  √  null Storage Service Name. ZAPIs: volume-storage-service-get-iter.storage-service-info.storage-service
volumelivelistdtoview styleExtended varchar 255  √  null Identifies license type
volumelivelistdtoview syncMirrorRelationshipParticipantStatus varchar 21  √  null
volumelivelistdtoview tieringPolicy varchar 255  √  null Identifies assicated tiering policy for a volume
volumelivelistdtoview volStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
volumelivelistdtoview volType varchar 255  √  null
volumelivelistdtoview vserverHealthStatus int 10
volumelivelistdtoview vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumelivelistdtoview vserverName varchar 255 Textual name
volumelivelistmaxvolumemovejobview maxStartTime timestamp 19  √  null The date and time in cluster timezone when the volume move started. ZAPI: volume-move-get-iter volume-move-info start-timestamp
volumelivelistmaxvolumemovejobview maxUpdateTime bigint 19  √  null
volumelivelistmaxvolumemovejobview volumeId bigint 19
volumemovehistory cluster_id bigint 19  √  null
volumemovehistory id bigint 19
volumemovehistory lastSync bigint 19
volumemovehistory moveState varchar 40  √  null
volumenodecapacitymapping nodeId bigint 19  √  null
volumenodecapacitymapping totalVolumeCapacity decimal 41  √  null
volumenodecapacitymapping volumeProtectionCapacity decimal 41  √  null
volumenodecapacitymapping volumeUsedCapacity decimal 42  √  null
volumeoutgoingrelationshipview sourceVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumeregressioninfo bytesUsedPerDay double 22 0
volumeregressioninfo id bigint 19
volumeregressioninfo lastSampleTime timestamp 19  √  null
volumeregressioninfo meanBytesData double 22 0
volumeregressioninfo meanSnapshotData double 22 0
volumeregressioninfo meanTime double 22 0
volumeregressioninfo numSamples bigint 19 0
volumeregressioninfo objVersion int 10
volumeregressioninfo snapshotBytesUsedPerDay double 22 0
volumeregressioninfo sumProductOfTimeAndBytesData double 22 0
volumeregressioninfo sumProductOfTimeAndSnapshotData double 22 0
volumeregressioninfo sumTimeSquared double 22 0
volumeregressioninfo volume_id bigint 19
volumerelationshiplivelistdtoview controlPlane varchar 255  √  null The type of the control plane used for the relationship.
volumerelationshiplivelistdtoview derivedRelationshipType varchar 255  √  null indicates modes of sync-snap-mirror- full or relaxed along with existing relationship-types
volumerelationshiplivelistdtoview destinationAggregateHealthStatus int 10  √  null
volumerelationshiplivelistdtoview destinationAggregateId bigint 19  √  null Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
volumerelationshiplivelistdtoview destinationAggregateName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview destinationClusterFqdn varchar 255  √  null
volumerelationshiplivelistdtoview destinationClusterHealthStatus int 10
volumerelationshiplivelistdtoview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiplivelistdtoview destinationClusterName varchar 255 Textual name
volumerelationshiplivelistdtoview destinationClusterNodeHealthStatus int 10  √  null
volumerelationshiplivelistdtoview destinationClusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
volumerelationshiplivelistdtoview destinationClusterNodeName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview destinationClusterVersion varchar 255  √  null Version of the cluster
volumerelationshiplivelistdtoview destinationClusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshiplivelistdtoview destinationClusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshiplivelistdtoview destinationClusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshiplivelistdtoview destinationNodeCount int 10  √  1
volumerelationshiplivelistdtoview destinationPath text 65535  √  null
volumerelationshiplivelistdtoview destinationVolumeHealthStatus int 10
volumerelationshiplivelistdtoview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiplivelistdtoview destinationVolumeName varchar 255 Textual name
volumerelationshiplivelistdtoview destinationVolumeState varchar 255  √  null
volumerelationshiplivelistdtoview destinationVolumeStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
volumerelationshiplivelistdtoview destinationVolumeType varchar 255  √  null
volumerelationshiplivelistdtoview destinationVserverHealthStatus int 10
volumerelationshiplivelistdtoview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiplivelistdtoview destinationVserverName varchar 255 Textual name
volumerelationshiplivelistdtoview healthStatus int 10
volumerelationshiplivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
volumerelationshiplivelistdtoview isHealthy int 10  √  null
volumerelationshiplivelistdtoview lagDuration bigint 19  √  null
volumerelationshiplivelistdtoview lagStatus varchar 14  √  null
volumerelationshiplivelistdtoview lastSuccessfulUpdateTime bigint 19  √  null
volumerelationshiplivelistdtoview lastTransferDuration bigint 19  √  null
volumerelationshiplivelistdtoview lastTransferEndTime timestamp 19  √  null
volumerelationshiplivelistdtoview lastTransferSize bigint 19  √  null
volumerelationshiplivelistdtoview name varchar 2048
volumerelationshiplivelistdtoview objectId bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
volumerelationshiplivelistdtoview overallStatus enum 7  √  null
volumerelationshiplivelistdtoview relationshipState varchar 255  √  null Raw mirror state enum value
volumerelationshiplivelistdtoview relationshipStatus varchar 255  √  null Raw relationship status enum value
volumerelationshiplivelistdtoview relationshipType varchar 255  √  null Raw relationship status enum value
volumerelationshiplivelistdtoview scheduleId bigint 19  √  null
volumerelationshiplivelistdtoview scheduleName varchar 255  √  null
volumerelationshiplivelistdtoview snapMirrorPolicyId bigint 19  √  null
volumerelationshiplivelistdtoview snapMirrorPolicyName varchar 255  √  null The name of the policy.
volumerelationshiplivelistdtoview snapMirrorPolicyType enum 18  √  null The type of the Snapmirror policy - "vault" , "async_mirror" , "mirror_vault" ,"sync_mirror", "strict_sync_mirror"
volumerelationshiplivelistdtoview sourceAggregateHealthStatus int 10  √  null
volumerelationshiplivelistdtoview sourceAggregateId bigint 19  √  null Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
volumerelationshiplivelistdtoview sourceAggregateName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview sourceClusterFqdn varchar 255  √  null
volumerelationshiplivelistdtoview sourceClusterHealthStatus int 10  √  null
volumerelationshiplivelistdtoview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiplivelistdtoview sourceClusterName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview sourceClusterNodeHealthStatus int 10  √  null
volumerelationshiplivelistdtoview sourceClusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
volumerelationshiplivelistdtoview sourceClusterNodeName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview sourceClusterVersion varchar 255  √  null Version of the cluster
volumerelationshiplivelistdtoview sourceClusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshiplivelistdtoview sourceClusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshiplivelistdtoview sourceClusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshiplivelistdtoview sourceNodeCount int 10  √  1
volumerelationshiplivelistdtoview sourcePath text 65535  √  null
volumerelationshiplivelistdtoview sourceVolumeHealthStatus int 10  √  null
volumerelationshiplivelistdtoview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiplivelistdtoview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview sourceVolumeState varchar 255  √  null
volumerelationshiplivelistdtoview sourceVolumeStyle enum 11  √  null DERIVED. Similar to ZAPI based style, but adds in constituent as necessary.
volumerelationshiplivelistdtoview sourceVolumeType varchar 255  √  null
volumerelationshiplivelistdtoview sourceVserverHealthStatus int 10  √  null
volumerelationshiplivelistdtoview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiplivelistdtoview sourceVserverName varchar 255  √  null Textual name
volumerelationshiplivelistdtoview storageServiceName varchar 255  √  null Storage Service Name. ZAPIs: volume-storage-service-get-iter.storage-service-info.storage-service
volumerelationshiplivelistdtoview transferPriority varchar 255  √  null
volumerelationshiplivelistdtoview unhealthyReason varchar 255  √  null The reason the relationship is not healthy
volumerelationshiplivelistdtoview versionFlexibleReplication enum 15 none
volumesnapshot_metadatafields fieldName varchar 255
volumesnapshot_metadatafields fieldValue longtext 2147483647
volumesnapshot_metadatafields snapshot_id bigint 19
volumetransferrateweeklyview day varchar 9  √  null
volumetransferrateweeklyview endTime varchar 24  √  null
volumetransferrateweeklyview totalTransferSize decimal 46,3  √  null
vserver availabilityRiskLevel int 10
vserver capacityRiskLevel int 10
vserver cluster_id bigint 19  √  null
vserver healthStatus int 10
vserver id bigint 19
vserver lastSync bigint 19
vserver metadataVolumeId bigint 19  √  null
vserver metadataVolumeLastUpdateTime timestamp 19  √  null
vserver performanceRiskLevel int 10 0
vserver protectionRiskLevel int 10
vserver volumeBytesAvail double 22  √  null
vserver volumeBytesTotal double 22  √  null
vserver volumeBytesUsed double 22  √  null
vserverassociationlivelistdtoview connectionType varchar 32
vserverassociationlivelistdtoview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
vserverassociationlivelistdtoview destinationClusterName varchar 255 Textual name
vserverassociationlivelistdtoview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverassociationlivelistdtoview destinationVserverName varchar 255 Textual name
vserverassociationlivelistdtoview id bigint 19
vserverassociationlivelistdtoview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
vserverassociationlivelistdtoview sourceClusterName varchar 255  √  null Textual name
vserverassociationlivelistdtoview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverassociationlivelistdtoview sourceVserverName varchar 255  √  null Textual name
vserverhistorymonth kBytesTotalSum bigint 19
vserverhistorymonth kBytesUsedSum bigint 19
vserverhistorymonth periodEndTime timestamp 19 CURRENT_TIMESTAMP
vserverhistorymonth sampleCount int 10 1
vserverhistorymonth vserverId bigint 19
vserverhistoryweek kBytesTotalSum bigint 19
vserverhistoryweek kBytesUsedSum bigint 19
vserverhistoryweek periodEndTime timestamp 19 CURRENT_TIMESTAMP
vserverhistoryweek sampleCount int 10 1
vserverhistoryweek vserverId bigint 19
vserverhistoryyear kBytesTotalSum bigint 19
vserverhistoryyear kBytesUsedSum bigint 19
vserverhistoryyear periodEndTime timestamp 19 CURRENT_TIMESTAMP
vserverhistoryyear sampleCount int 10 1
vserverhistoryyear vserverId bigint 19
vserverlivelistdtoview activeNisDomainName varchar 255  √  null DERIVED. Domain name of the active NIS server - NULL if none is active.
vserverlivelistdtoview activeNisServers text 65535  √  null DERIVED. NIS servers value of the active NIS server - NULL if none is active.
vserverlivelistdtoview allowedProtocols varchar 255  √  null Ordered list of allowed protocols. List of: cifs, nfs, iscsi, and fcp
vserverlivelistdtoview allowedVolumeType varchar 19
vserverlivelistdtoview bytesAvail double 22  √  null
vserverlivelistdtoview bytesTotal double 22  √  null
vserverlivelistdtoview bytesUsed double 22  √  null
vserverlivelistdtoview cifsEnabled bit 0  √  null CIFS access is supported and enabled
vserverlivelistdtoview clusterFqdn varchar 255  √  null
vserverlivelistdtoview clusterHealthStatus int 10
vserverlivelistdtoview clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
vserverlivelistdtoview clusterName varchar 255 Textual name
vserverlivelistdtoview dnsDomainNames varchar 255  √  null List of DNS domains. The first domain is the one that the Vserver belongs to
vserverlivelistdtoview dnsEnabled bit 0  √  null True if DNS enabled
vserverlivelistdtoview dnsServers varchar 255  √  null IPv4 addresses of name servers. Multiple values will be sorted comma separated
vserverlivelistdtoview fcpEnabled bit 0  √  null FCP access is supported and enabled
vserverlivelistdtoview healthStatus int 10
vserverlivelistdtoview id bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverlivelistdtoview iscsiEnabled bit 0  √  null iSCSI access is supported and enabled
vserverlivelistdtoview isRepository bit 0  √  null Specifies if this Vserver is a repository Vserver
vserverlivelistdtoview ldapEnabled bit 0  √  null If true, the corresponding Lightweight Directory Access Protocol (LDAP) configuration is enabled for this Vserver.
vserverlivelistdtoview maximumVolumes int 10  √  null Maximum number of volumes that can be created on the Vserver
vserverlivelistdtoview name varchar 255 Textual name
vserverlivelistdtoview nameServerSwitch varchar 255  √  null Name Server switch configuration details for the Vserver.Multiple values will be ordered comma separated
vserverlivelistdtoview nfsEnabled bit 0  √  null NFS access is supported and enabled
vserverlivelistdtoview nisEnabled bit 0  √  null Specifies whether the NIS domain configuration is active or inactive
vserverlivelistdtoview rootVolumeHealthStatus int 10  √  null
vserverlivelistdtoview rootVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
vserverlivelistdtoview rootVolumeName varchar 255  √  null Textual name
vserverlivelistdtoview snapshotPolicyHealthStatus int 10  √  null
vserverlivelistdtoview snapshotPolicyId bigint 19  √  null
vserverlivelistdtoview snapshotPolicyName varchar 255  √  null A human readable string describing the name of the snapshot scheduling policy.
vserverlivelistdtoview state varchar 255  √  null
vserverlivelistdtoview subType enum 16  √  null Subtype of Vserver.
vserverlivelistdtoview versionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
vserverlivelistdtoview versionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
vserverlivelistdtoview versionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
vserverlivelistdtoview volumeCount bigint 19  √  null
wafldisk cluster_id bigint 19  √  null
wafldisk healthStatus int 10
wafldisk id bigint 19
wafldisk lastFailedTime bigint 19 0
wafldisk lastKnownEffectiveInterfaceTypeRaw varchar 255  √  null
wafldisk lastKnownRaidGroupId bigint 19  √  null
wafldisk lastSync bigint 19
wafldisk raidState varchar 40  √  null
wafldisk role varchar 40  √  null