SchemaSpy Analysis of ocum_report_birt - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Apr 23 04:53 EDT 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ocum_report_birt contains 518 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
daywiseeventstatustrendchart ackCount decimal 43  √  null
eventstatecharthelper ackCount bigint 19  √  null
storagesystemhealthtable acknowledgedBy varchar 128  √  null
basicevents acknowledgedTimestamp timestamp 19  √  null
storagesystemhealthtable acknowledgedTimestamp timestamp 19  √  null
eventstatecharthelper ackToResolvedAndObsoleteCount bigint 19  √  null
clusterlicenseview actionCode varchar 255  √  null
clusterlicenseview actionDecription varchar 255  √  null
svminventoryreport activeNisDomainName varchar 255  √  null DERIVED. Domain name of the active NIS server - NULL if none is active.
volumerelationshiphistorydayview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistorymonthview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistoryview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistoryweekview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistoryyearview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
halevelmapping aggregateBytesTotal decimal 41  √  null
nodelevelcapacitymapping aggregateBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
halevelmapping aggregateBytesUsed decimal 41  √  null
nodelevelcapacitymapping aggregateBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
storagesummary aggregateCapacity decimal 10,3  √  null
aggregatecapacityutilization aggregateType enum 17  √  null Aggregate Derived Type.
storagesummary aggregateUsedCapacity decimal 10,3  √  null
volumerelationshiphistoryaggweekhourview aggTransferSize decimal 41  √  null
storagesummary allocatedLunCapacity decimal 10,3  √  null
svminventoryreport allowedProtocols varchar 255  √  null Ordered list of allowed protocols. List of: cifs, nfs, iscsi, and fcp
halevelmapping assignedLunCapacity decimal 65  √  null
lunnodecapacitymapping assignedLunCapacity decimal 41  √  null
nodelevelcapacitymapping assignedLunCapacity decimal 63  √  null
storagesystemhealthtable assignedTimestamp timestamp 19  √  null
storagesystemhealthtable assignedTo varchar 128  √  null
unprotectvolumeview autogrow varchar 1024  √  null
volumecapacityutilization autoGrowState varchar 1024  √  null
aggregatecapacityutilization availableDataCapacity bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-space-attributes size-available
unprotectvolumeview availableDataCapacity bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
volumecapacityutilization availableDataCapacity bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
aggregatecapacityutilization bytesUsedPerDay double 22  √  0
unprotectvolumeview bytesUsedPerDay double 22  √  0
volumecapacityutilization bytesUsedPerDay double 22  √  0
volumecapacityutilization cacheRetentionPriority varchar 255  √  null raw cache retention priority associated with volumes
volumecapacityutilization cachingPolicy varchar 255  √  null raw cache policy associated with volumes
halevelmapping clusterId bigint 19  √  null
unprotectvolumeview clusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
aggregatecapacityutilization clusterName varchar 255  √  null
svminventoryreport clusterName varchar 255  √  null
unprotectvolumeview clusterName varchar 255  √  null Textual name
volumecapacityutilization clusterName varchar 255  √  null
protectunprotectvolumeview clusternodeName varchar 255  √  null Textual name
unprotectvolumeview compressionEnabled varchar 1024  √  null
volumecapacityutilization compressionSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
unprotectvolumeview compressionSpaceSavings bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
volumecapacityutilization compressionState varchar 1024  √  null
volumerelationshipinventoryview controlPlane varchar 255  √  null The type of the control plane used for the relationship.
clusterinventoryreport cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
nodelevelcapacitymapping cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
eventseveritytrendchart criticalCount bigint unsigned 20  √  null
storagesystemhealthtable dataPriority varchar 255  √  null
volumerelationshiphistoryaggweekhourview day varchar 9  √  null
volumerelationshiphistoryaggweekhourview dayCount int 10  √  null
aggregatecapacityutilization daysToFull bigint unsigned 20  √  null
unprotectvolumeview daysToFull bigint unsigned 20  √  null
volumecapacityutilization daysToFull bigint unsigned 20  √  null
aggregatecapacityutilization daysUntilFullThreshold varchar 255  √  null
volumecapacityutilization daysUntilFullThreshold varchar 255  √  null
volumecapacityutilization dedupeEnabled varchar 1024  √  null
unprotectvolumeview deduplicationEnabled varchar 1024  √  null
volumecapacityutilization deduplicationSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
unprotectvolumeview dedupSpaceSavings bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
volumerelationshipinventoryview destinationClusterNodeHealthStatus int 10  √  null
volumerelationshipinventoryview destinationClusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
volumerelationshipinventoryview destinationClusterNodeName varchar 255  √  null Textual name
volumerelationshipinventoryview destinationClusterVersion varchar 1024  √  null
volumerelationshipinventoryview destinationClusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshipinventoryview destinationClusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshipinventoryview destinationClusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshipinventoryview destinationPath text 65535  √  null
volumerelationshipinventoryview destinationVolumeState varchar 255  √  null
volumerelationshipinventoryview destinationVolumeType varchar 255  √  null
clusterinventoryreport diskCount bigint 19  √  null
qtreecapacityutilization diskLimit bigint 19  √  null
qtreecapacityutilization diskLimitUnlimited tinyint 3  √  null
clusterinventoryreport diskshelveCount bigint 19  √  null
qtreecapacityutilization diskUsed bigint 19  √  null
svminventoryreport dnsDomainNames varchar 255  √  null List of DNS domains. The first domain is the one that the Vserver belongs to
volumerelationshiphistoryaggweekhourview endDate date 10  √  null
volumerelationshiphistoryaggweekhourview endTime varchar 13  √  null
volumerelationshiphistorydayview endTime datetime 19  √  null
volumerelationshiphistorymonthview endTime datetime 19  √  null
volumerelationshiphistoryview endTime datetime 19  √  null
volumerelationshiphistoryweekview endTime datetime 19  √  null
volumerelationshiphistoryyearview endTime datetime 19  √  null
eventseveritytrendchart errorCount bigint unsigned 20  √  null
clusterinventoryreport ethernetPortCount bigint 19  √  null
storagesystemhealthtable event varchar 236  √  null
unprotectvolumeview expiryDate varchar 64  √  null
volumecapacityutilization expiryDate varchar 64  √  null
nfsexport exportPolicyName varchar 255  √  null
nfsexport exportPolicyRuleIndex int 10  √  null
nfsexport exportPolicyRuleRoRule varchar 255  √  null
nfsexport exportPolicyRuleRwRule varchar 255  √  null
volumerelationshiphistorychartview failCount decimal 32  √  null
clusterinventoryreport fcoePortCount bigint 19  √  null
clusterinventoryreport fcpPortCount bigint 19  √  null
qtreecapacityutilization fileLimit bigint 19  √  null
qtreecapacityutilization fileLimitUnlimited tinyint 3  √  null
qtreecapacityutilization fileUsed bigint 19  √  null
clusterinventoryreport flashCardCount bigint 19  √  null
clusterinventoryreport flashCardSize decimal 32  √  null
aggregatecapacityutilization growthRateSensitivityThreshold varchar 255  √  null
volumecapacityutilization growthRateSensitivityThreshold varchar 255  √  null
aggregatecapacityutilization growthRateThreshold varchar 255  √  null
unprotectvolumeview growthRateThreshold varchar 255  √  null
volumecapacityutilization growthRateThreshold varchar 255  √  null
aggregatecapacityutilization haPair varchar 255  √  null
storagesummary haPair varchar 255  √  null
aggregatecapacityutilization haPairId bigint 19  √  null Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
clusterinventoryreport haPairName varchar 255  √  null
halevelmapping haPairName varchar 511  √  null
hapairview haPairName varchar 255  √  null
storagesystemhealthtable impactArea varchar 60  √  null
volumecapacityutilization inodesFullThreshold varchar 255  √  null
volumecapacityutilization inodesNearlyFullThreshold varchar 255  √  null
unprotectvolumeview inodeutilization 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
clusterlicenseview inUsage varchar 4  √  null
clusterinventoryreport isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
halevelmapping isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
nodelevelcapacitymapping isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
volumerelationshipinventoryview 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
nfsexport isJunctionPathActive text 65535  √  null
lunnodecapacitymapping isLunMapped int 10  √  null
volumecapacityutilization isSnapshotAutoDeleteEnabled varchar 1024  √  null
volumecapacityutilization isThinProvisioned varchar 1024  √  null
nfsexport junctionPath varchar 511  √  null
volumerelationshipinventoryview lagDuration bigint 19  √  null
volumerelationshipinventoryview lagStatus enum 7  √  null
volumerelationshipinventoryview lastSuccessfulUpdateTime timestamp 19  √  null
volumerelationshipinventoryview lastTransferDuration bigint 19  √  null
volumerelationshipinventoryview lastTransferEndTime timestamp 19  √  null The Timestamp of the end of the last transfer
volumerelationshipinventoryview lastTransferSize bigint 19  √  null The total number of bytes transferred as part of the last transfer. ZAPI: snapmirror-info.last-transfer-size
ackevents lastUpdatedTime date 10  √  null
acktoresolvedandobsoleteevents lastUpdatedTime date 10  √  null
daywiseeventstatustrendchart lastUpdatedTime date 10  √  null
eventstatecharthelper lastUpdatedTime date 10  √  null
eventupdatedates lastUpdatedTime date 10  √  null
newevents lastUpdatedTime date 10  √  null
newtoresolvedandobsoleteevents lastUpdatedTime date 10  √  null
svminventoryreport ldapClientEnabled bit 0  √  null If true, the corresponding Lightweight Directory Access Protocol (LDAP) configuration is enabled for this Vserver.
clusterlicenseview licenseDecription varchar 255  √  null
clusterlicenseview licenseExpirationTime timestamp 19  √  null
clusterlicenseview licensePackage varchar 255  √  null
clusterlicenseview licenseSerialNumber varchar 255  √  null
clusterlicenseview licenseType varchar 255  √  null
svminventoryreport maximumVolumes int 10  √  null Maximum number of volumes that can be created on the Vserver
clusterinventoryreport model varchar 255  √  null Hardware model of this node.
halevelmapping model varchar 255  √  null Hardware model of this node.
nodelevelcapacitymapping model varchar 255  √  null Hardware model of this node.
storagesummary model varchar 255  √  null Hardware model of this node.
svminventoryreport nameServerSwitch varchar 255  √  null Name Server switch configuration details for the Vserver.Multiple values will be ordered comma separated
aggregatecapacityutilization nearlyOvercommittedThreshold varchar 255  √  null
daywiseeventstatustrendchart newCount decimal 44  √  null
eventstatecharthelper newCount bigint 19  √  null
eventstatecharthelper newToResolvedAndObsoleteCount bigint 19  √  null
halevelmapping nodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
lunnodecapacitymapping nodeId bigint 19  √  null
volumenodecapacitymapping nodeId bigint 19  √  null
clusterlicenseview nodeLockedLicense varchar 4  √  null
clusterlicenseview nodeName varchar 255  √  null
clusterlicenseview nodeSerialNumber varchar 255  √  null
clusterlicenseview nodeUsageuuid varchar 255  √  null
unprotectvolumeview noofinodes 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
volumecapacityutilization numberOfInodes 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
volumecapacityutilization 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
storagesystemhealthtable numberOfNotes bigint 19  √  null
aggregatecapacityutilization objectStoreName varchar 255  √  null
daywiseeventstatustrendchart obsoleteCount bigint 19  √  null
basicevents obsoleteTimestamp timestamp 19  √  null
storagesystemhealthtable obsoleteTimestamp timestamp 19  √  null
clusterinventoryreport ontapVersion varchar 1024  √  null
halevelmapping ontapVersion varchar 1024  √  null
nodelevelcapacitymapping ontapVersion varchar 1024  √  null
storagesummary ontapVersion varchar 1024  √  null
volumerelationshiphistorydayview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistorymonthview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistoryview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistoryweekview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistoryyearview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistorydayview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistorymonthview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistoryview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistoryweekview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistoryyearview operationType varchar 255  √  null The type of the operation happened on the relationship.
storagesystemhealthtable outstandingDays int 10  √  null
volumerelationshipinventoryview overallStatus enum 7  √  null
aggregatecapacityutilization overcommittedThreshold varchar 255  √  null
clusterlicenseview ownerName varchar 255  √  null
clusterlicenseview ownerType varchar 7  √  null
halevelmapping partnerNodeId bigint 19  √  null
nodelevelcapacitymapping partnerNodeId bigint 19  √  null
protectunprotectvolumeview protectionrole varchar 52  √  null
nfsexport qtreeName varchar 255  √  null
qtreecapacityutilization qtreeName varchar 255  √  null
volumecapacityutilization quotaCommitted bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
unprotectvolumeview quotaCommittedCapacity bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
qtreecapacityutilization quotaId bigint 19  √  null
volumecapacityutilization quotaNearlyOvercommittedThreshold varchar 255  √  null
volumecapacityutilization quotaOverCommitted bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
unprotectvolumeview quotaOvercommittedCapacity bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
volumecapacityutilization quotaOvercommittedThreshold varchar 255  √  null
qtreecapacityutilization quotaType varchar 10  √  null
qtreecapacityutilization quotaUserName varchar 255  √  null
aggregatecapacityutilization raidType varchar 255  √  null
storagesummary rawCapacity decimal 10,3  √  null
halevelmapping rawDiskBytesTotal decimal 41  √  null
nodelevelcapacitymapping rawDiskBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
volumerelationshiphistorydayview readableCreateTime datetime 19  √  null
volumerelationshiphistorymonthview readableCreateTime datetime 19  √  null
volumerelationshiphistoryview readableCreateTime datetime 19  √  null
volumerelationshiphistoryweekview Readablecreatetime datetime 19  √  null
volumerelationshiphistoryyearview readableCreateTime datetime 19  √  null
volumerelationshiphistorydayview readableUpdateTime datetime 19  √  null
volumerelationshiphistorymonthview readableUpdateTime datetime 19  √  null
volumerelationshiphistoryview readableUpdateTime datetime 19  √  null
volumerelationshiphistoryweekview Readableupdatetime datetime 19  √  null
volumerelationshiphistoryyearview readableUpdateTime datetime 19  √  null
volumerelationshipinventoryview relationshipState varchar 255  √  null Raw mirror state enum value
volumerelationshipinventoryview relationshipStatus varchar 255  √  null Raw relationship status enum value
volumerelationshipinventoryview relationshipType varchar 255  √  null Raw relationship status enum value
storagesystemhealthtable resolvedBy varchar 128  √  null
daywiseeventstatustrendchart resolvedCount bigint 19  √  null
basicevents resolvedTimestamp timestamp 19  √  null
storagesystemhealthtable resolvedTimestamp timestamp 19  √  null
clusterlicenseview risk varchar 10  √  null
clusterlicenseview riskObjid bigint 19  √  null
svminventoryreport rootVolume varchar 255  √  null
volumerelationshipinventoryview scheduleId bigint 19  √  null
volumerelationshipinventoryview scheduleName varchar 255  √  null The name of the job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-name
nfsexport securityPermission varchar 256  √  null
nfsexport securityStyle varchar 255  √  null
clusterinventoryreport serialNumber varchar 255  √  null Serial number
nodelevelcapacitymapping serialNumber varchar 255  √  null Serial number
aggregatecapacityutilization snapLockType varchar 255  √  null
unprotectvolumeview snapLockType varchar 255  √  null
volumecapacityutilization snapLockType varchar 255  √  null
volumerelationshipinventoryview snapMirrorPolicyId bigint 19  √  null
volumerelationshipinventoryview snapMirrorPolicyName varchar 255  √  null The name of the policy.
volumerelationshipinventoryview snapMirrorPolicyType enum 18  √  null The type of the Snapmirror policy - "vault" , "async_mirror" , "mirror_vault" ,"sync_mirror", "strict_sync_mirror"
unprotectvolumeview snapshotAutodelete varchar 1024  √  null
unprotectvolumeview snapshotAvailableCapacity double 22  √  null
volumecapacityutilization snapshotAvailableCapacity double 22  √  null
volumecapacityutilization snapshotCountThreshold varchar 255  √  null
aggregatecapacityutilization snapshotFullThreshold varchar 255  √  null
volumecapacityutilization SnapshotFullThreshold varchar 255  √  null
aggregatecapacityutilization snapshotReserveAvailCapacity bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-snapshot-attributes size-available
volumecapacityutilization snapshotReserveDaysUntilFullThreshold varchar 255  √  null
aggregatecapacityutilization snapshotReserveTotalCapacity bigint 19  √  null Total size (in bytes) of the referenced file system. If the referenced file system is restricted or offline, a value 0 is returned
aggregatecapacityutilization snapshotReserveUsedCapacity 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
unprotectvolumeview snapshotTotalCapacity bigint 19  √  null The size (in bytes) in the volume that has been set aside as reserve for snapshot usage
volumecapacityutilization snapshotTotalCapacity bigint 19  √  null The size (in bytes) in the volume that has been set aside as reserve for snapshot usage
unprotectvolumeview snapshotUsedCapacity double 22  √  null
volumecapacityutilization snapshotUsedCapacity double 22  √  null
qtreecapacityutilization softDiskLimit bigint 19  √  null
qtreecapacityutilization softDiskLimitUnlimited tinyint 3  √  null
qtreecapacityutilization softFileLimit bigint 19  √  null
qtreecapacityutilization softFileLimitUnlimited tinyint 3  √  null
volumerelationshipinventoryview sourceAggregateHealthStatus int 10  √  null
volumerelationshipinventoryview sourceAggregateId bigint 19  √  null Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
volumerelationshipinventoryview sourceAggregateName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceClusterHealthStatus int 10  √  null
volumerelationshiphistorydayview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorymonthview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryweekview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryyearview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshipinventoryview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorydayview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistorymonthview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistoryview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistoryweekview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistoryyearview sourceClusterName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceClusterName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceClusterNodeHealthStatus int 10  √  null
volumerelationshipinventoryview sourceClusterNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
volumerelationshipinventoryview sourceClusterNodeName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceClusterVersion varchar 1024  √  null
volumerelationshipinventoryview sourceClusterVersionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshipinventoryview sourceClusterVersionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshipinventoryview sourceClusterVersionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
volumerelationshipinventoryview sourcePath text 65535  √  null
volumerelationshipinventoryview sourceVolumeHealthStatus int 10  √  null
volumerelationshiphistorydayview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorymonthview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryweekview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryyearview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshipinventoryview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorydayview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistorymonthview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistoryview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistoryweekview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistoryyearview sourceVolumeName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceVolumeName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceVolumeState varchar 255  √  null
volumerelationshipinventoryview sourceVolumeType varchar 255  √  null
volumerelationshipinventoryview sourceVserverHealthStatus int 10  √  null
volumerelationshiphistorydayview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorymonthview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryweekview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryyearview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshipinventoryview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorydayview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistorymonthview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistoryview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistoryweekview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistoryyearview sourceVserverName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceVserverName varchar 255  √  null Textual name
aggregatecapacityutilization spaceFullThreshold varchar 255  √  null
unprotectvolumeview spaceFullThreshold varchar 255  √  null
volumecapacityutilization spaceFullThreshold varchar 255  √  null
unprotectvolumeview spaceGuarantee varchar 255  √  null
volumecapacityutilization spaceGuarantee varchar 255  √  null
aggregatecapacityutilization spaceNearlyFullThreshold varchar 255  √  null
unprotectvolumeview spaceNearlyFullThreshold varchar 255  √  null
volumecapacityutilization spaceNearlyFullThreshold varchar 255  √  null
volumerelationshiphistorydayview startTime datetime 19  √  null
volumerelationshiphistorymonthview startTime datetime 19  √  null
volumerelationshiphistoryview startTime datetime 19  √  null
volumerelationshiphistoryweekview startTime datetime 19  √  null
volumerelationshiphistoryyearview startTime datetime 19  √  null
aggregatecapacityutilization state varchar 255  √  null
svminventoryreport state enum 12  √  null Data serving state of Vserver
volumecapacityutilization state varchar 255  √  null
volumerelationshiphistorychartview successCount decimal 32  √  null
unprotectvolumeview SVM varchar 255  √  null Textual name
unprotectvolumeview thinProvisioning varchar 1024  √  null
volumecapacityutilization tieringPolicy varchar 255  √  null Identifies assicated tiering policy for a volume
storagesummary totalClusterStorageGridCapacitySpaceUsed decimal 10,3  √  null
aggregatecapacityutilization totalCommitted 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.
volumerelationshiphistorychartview totalCount decimal 33  √  null
aggregatecapacityutilization totalDataCapacity 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
unprotectvolumeview totalDataCapacity bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
volumecapacityutilization totalDataCapacity bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
storagesummary totalExternalCapacityTierLicensedSpace decimal 10,3  √  null
storagesummary totalExternalCapacityTierLicensedSpaceUsed decimal 10,3  √  null
halevelmapping totalVolumeCapacity decimal 63  √  null
nodelevelcapacitymapping totalVolumeCapacity decimal 41  √  null
volumenodecapacitymapping totalVolumeCapacity decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapacityTierLicensedSpaceUsed decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapacityTierUnLicensedSpaceUsed decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapaityTierLicensedSpace bigint 19  √  null
volumerelationshiphistorydayview transferDuration bigint 19  √  null
volumerelationshiphistorymonthview transferDuration bigint 19  √  null
volumerelationshiphistoryview transferDuration bigint 19  √  null
volumerelationshiphistoryweekview transferDuration bigint 19  √  null
volumerelationshiphistoryyearview transferDuration bigint 19  √  null
volumerelationshipinventoryview transferPriority varchar 255  √  null
volumerelationshiphistorydayview transfersize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistorymonthview transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistoryview transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistoryweekview transfersize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistoryyearview transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistorychartcountview triggerdDate varchar 10  √  null
volumerelationshiphistorychartview triggerdDate varchar 10  √  null
eventseveritytrendchart triggeredDate date 10  √  null
eventseveritytrendhelper triggeredDate date 10  √  null
basicevents triggeredTime timestamp 19  √  null
storagesystemhealthtable triggeredTime timestamp 19  √  null
storagesummary unallocatedLunCapacity decimal 10,3  √  null
halevelmapping unassignedLunCapacity decimal 65  √  null
lunnodecapacitymapping unassignedLunCapacity decimal 41  √  null
nodelevelcapacitymapping unassignedLunCapacity decimal 63  √  null
clusterunconfiguredcapacitymapping unconfiguredRawCapacity decimal 60  √  null
diskcapacitymapping unconfiguredRawCapacity decimal 60  √  null
storagesummary unconfiguredRawCapacity decimal 10,3  √  null
volumerelationshipinventoryview unhealthyReason varchar 255  √  null The reason the relationship is not healthy
volumerelationshiphistorydayview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistorymonthview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistoryview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistoryweekview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistoryyearview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistorydayview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistorymonthview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistoryview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistoryweekview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistoryyearview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
aggregatecapacityutilization usedDataCapacity 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
unprotectvolumeview usedDataCapacity bigint 19  √  null Used size of the volume in bytes
volumecapacityutilization usedDataCapacity bigint 19  √  null Used size of the volume in bytes
aggregatecapacityutilization usedExternalCapacityTierSpace bigint 19  √  null
storagesummary volumeCapacity decimal 10,3  √  null
svminventoryreport volumeCount bigint 19  √  null
halevelmapping volumeProtectionCapacity decimal 63  √  null
nodelevelcapacitymapping volumeProtectionCapacity decimal 41  √  null
storagesummary volumeProtectionCapacity decimal 10,3  √  null
volumenodecapacitymapping volumeProtectionCapacity decimal 41  √  null
nfsexport volumeState varchar 255  √  null
unprotectvolumeview volumeState varchar 255  √  null
qtreecapacityutilization volumeTotalSize bigint 19  √  null
halevelmapping volumeUsedCapacity decimal 64  √  null
nodelevelcapacitymapping volumeUsedCapacity decimal 42  √  null
storagesummary volumeUsedCapacity decimal 10,3  √  null
volumenodecapacitymapping volumeUsedCapacity decimal 42  √  null
clusterinventoryreport vserverCount bigint 19  √  null
volumecapacityutilization vserverName varchar 255  √  null
eventseveritytrendchart warningCount bigint unsigned 20  √  null
aggregatecapacityutilizationhistory aggregateId bigint 19
aggregatecapacityutilization aggrId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregatecapacityutilization aggrName varchar 255 Textual name
aggregatecapacityutilization clusterId bigint 19
clusterlicenseview clusterid bigint 19 0
diskcapacitymapping clusterId bigint 19
nodelevelcapacitymapping clusterId bigint 19
volumecapacityutilization clusterId bigint 19
clusterlicenseview clusterName varchar 255
clusterunconfiguredcapacitymapping ClusterName varchar 255 Textual name
nfsexport clusterName varchar 255
protectunprotectvolumeview clustername varchar 255 Textual name
qtreecapacityutilization clusterName varchar 255
storagesummary clusterName varchar 255 Textual name
volumerelationshipinventoryview destinationAggregateHealthStatus int 10
volumerelationshipinventoryview destinationAggregateId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
volumerelationshipinventoryview destinationAggregateName varchar 255 Textual name
volumerelationshipinventoryview destinationClusterHealthStatus int 10
volumerelationshiphistorydayview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorymonthview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryweekview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryyearview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshipinventoryview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorydayview destinationClusterName varchar 255 Textual name
volumerelationshiphistorymonthview destinationClusterName varchar 255 Textual name
volumerelationshiphistoryview destinationClusterName varchar 255 Textual name
volumerelationshiphistoryweekview destinationClusterName varchar 255 Textual name
volumerelationshiphistoryyearview destinationClusterName varchar 255 Textual name
volumerelationshipinventoryview destinationClusterName varchar 255 Textual name
volumerelationshipinventoryview destinationVolumeHealthStatus int 10
volumerelationshiphistorydayview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorymonthview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryweekview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryyearview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshipinventoryview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorydayview destinationVolumeName varchar 255 Textual name
volumerelationshiphistorymonthview destinationVolumeName varchar 255 Textual name
volumerelationshiphistoryview destinationVolumeName varchar 255 Textual name
volumerelationshiphistoryweekview destinationVolumeName varchar 255 Textual name
volumerelationshiphistoryyearview destinationVolumeName varchar 255 Textual name
volumerelationshipinventoryview destinationVolumeName varchar 255 Textual name
volumerelationshipinventoryview destinationVserverHealthStatus int 10
volumerelationshiphistorydayview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorymonthview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryweekview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryyearview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshipinventoryview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorydayview destinationVserverName varchar 255 Textual name
volumerelationshiphistorymonthview destinationVserverName varchar 255 Textual name
volumerelationshiphistoryview destinationVserverName varchar 255 Textual name
volumerelationshiphistoryweekview destinationVserverName varchar 255 Textual name
volumerelationshiphistoryyearview destinationVserverName varchar 255 Textual name
volumerelationshipinventoryview destinationVserverName varchar 255 Textual name
aggregatecapacityutilizationhistory dfKBytesUsedSum bigint 19 0
volumecapacityutilizationhistory dfKBytesUsedSum bigint 19 0
ackevents eventsCount bigint 19 0
acktoresolvedandobsoleteevents eventsCount bigint 19 0
newevents eventsCount bigint 19 0
newtoresolvedandobsoleteevents eventsCount bigint 19 0
nfsexport exportPolicyRuleAccessProtocol varchar 255
nfsexport exportPolicyRuleClientMatch varchar 255
volumerelationshiphistorychartcountview failCount int 10 0
halevelmapping haPairId bigint 19 Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
volumerelationshipinventoryview healthStatus int 10
volumerelationshipinventoryview id bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
storagesystemhealthtable impactLevel varchar 8
clusterinventoryreport name varchar 255 Textual name
protectunprotectvolumeview name varchar 255 Textual name
volumerelationshipinventoryview name varchar 2048
hapairview node1Id bigint 19 The objid of node1 in this ha_pair.
hapairview node2Id bigint 19 The objid of node2 in this ha_pair.
aggregatecapacityutilization nodeId bigint 19
clusterinventoryreport nodeId bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
nodelevelcapacitymapping nodeId bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
clusterinventoryreport nodeName varchar 255 Textual name
nodelevelcapacitymapping nodeName varchar 255 Textual name
eventseveritytrendhelper numberOfEvents bigint 19 0
volumerelationshipinventoryview objectId bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
clusterinventoryreport objid bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterunconfiguredcapacitymapping objid bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
hapairview objid bigint 19 Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
nodelevelcapacitymapping partnerNodeName varchar 255 Textual name
aggregatecapacityutilizationhistory periodEndTime timestamp 19 0000-00-00 00:00:00
volumecapacityutilizationhistory periodEndTime timestamp 19 0000-00-00 00:00:00
unprotectvolumeview protectionRole varchar 13
qtreecapacityutilization qtreeId bigint 19 0
basicevents severity int 10
eventseveritytrendhelper severity int 10
storagesystemhealthtable severity varchar 11
storagesystemhealthtable sourceFullName varchar 2000
storagesystemhealthtable sourceId bigint 19
storagesystemhealthtable sourceResourceType varchar 40
ackevents state varchar 12
acktoresolvedandobsoleteevents state varchar 11
basicevents state varchar 16
newevents state varchar 3
newtoresolvedandobsoleteevents state varchar 11
storagesystemhealthtable state varchar 16
volumerelationshiphistorychartcountview successCount int 10 0
volumerelationshipinventoryview versionFlexibleReplication enum 15 none
unprotectvolumeview volume varchar 255 Textual name
qtreecapacityutilization volumeId bigint 19 0
volumecapacityutilization volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumecapacityutilizationhistory volumeId bigint 19
nfsexport volumeName varchar 255
qtreecapacityutilization VolumeName varchar 255
volumecapacityutilization volumeName varchar 255 Textual name
svminventoryreport vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumecapacityutilization vserverId bigint 19
nfsexport vserverName varchar 255
qtreecapacityutilization VserverName varchar 255
svminventoryreport vserverName varchar 255 Textual name