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
ackevents eventsCount bigint 19 0
ackevents lastUpdatedTime date 10  √  null
ackevents state varchar 12
acktoresolvedandobsoleteevents eventsCount bigint 19 0
acktoresolvedandobsoleteevents lastUpdatedTime date 10  √  null
acktoresolvedandobsoleteevents state varchar 11
aggregatecapacityutilization aggregateType enum 17  √  null Aggregate Derived Type.
aggregatecapacityutilization aggrId bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
aggregatecapacityutilization aggrName varchar 255 Textual name
aggregatecapacityutilization availableDataCapacity bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-space-attributes size-available
aggregatecapacityutilization bytesUsedPerDay double 22  √  0
aggregatecapacityutilization clusterId bigint 19
aggregatecapacityutilization clusterName varchar 255  √  null
aggregatecapacityutilization daysToFull bigint unsigned 20  √  null
aggregatecapacityutilization daysUntilFullThreshold varchar 255  √  null
aggregatecapacityutilization growthRateSensitivityThreshold varchar 255  √  null
aggregatecapacityutilization growthRateThreshold varchar 255  √  null
aggregatecapacityutilization haPair varchar 255  √  null
aggregatecapacityutilization haPairId bigint 19  √  null Locally unique object identifier. ZAPIs: cf-get-iter.storage-failover-info
aggregatecapacityutilization nearlyOvercommittedThreshold varchar 255  √  null
aggregatecapacityutilization nodeId bigint 19
aggregatecapacityutilization objectStoreName varchar 255  √  null
aggregatecapacityutilization overcommittedThreshold varchar 255  √  null
aggregatecapacityutilization raidType varchar 255  √  null
aggregatecapacityutilization snapLockType varchar 255  √  null
aggregatecapacityutilization 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
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
aggregatecapacityutilization spaceFullThreshold varchar 255  √  null
aggregatecapacityutilization spaceNearlyFullThreshold varchar 255  √  null
aggregatecapacityutilization state varchar 255  √  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.
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
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
aggregatecapacityutilization usedExternalCapacityTierSpace bigint 19  √  null
aggregatecapacityutilizationhistory aggregateId bigint 19
aggregatecapacityutilizationhistory dfKBytesUsedSum bigint 19 0
aggregatecapacityutilizationhistory periodEndTime timestamp 19 0000-00-00 00:00:00
basicevents acknowledgedTimestamp timestamp 19  √  null
basicevents obsoleteTimestamp timestamp 19  √  null
basicevents resolvedTimestamp timestamp 19  √  null
basicevents severity int 10
basicevents state varchar 16
basicevents triggeredTime timestamp 19  √  null
clusterinventoryreport cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
clusterinventoryreport diskCount bigint 19  √  null
clusterinventoryreport diskshelveCount bigint 19  √  null
clusterinventoryreport ethernetPortCount bigint 19  √  null
clusterinventoryreport fcoePortCount bigint 19  √  null
clusterinventoryreport fcpPortCount bigint 19  √  null
clusterinventoryreport flashCardCount bigint 19  √  null
clusterinventoryreport flashCardSize decimal 32  √  null
clusterinventoryreport haPairName varchar 255  √  null
clusterinventoryreport isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
clusterinventoryreport model varchar 255  √  null Hardware model of this node.
clusterinventoryreport name varchar 255 Textual name
clusterinventoryreport 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
clusterinventoryreport objid bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterinventoryreport ontapVersion varchar 1024  √  null
clusterinventoryreport serialNumber varchar 255  √  null Serial number
clusterinventoryreport vserverCount bigint 19  √  null
clusterlicenseview actionCode varchar 255  √  null
clusterlicenseview actionDecription varchar 255  √  null
clusterlicenseview clusterid bigint 19 0
clusterlicenseview clusterName varchar 255
clusterlicenseview inUsage varchar 4  √  null
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
clusterlicenseview nodeLockedLicense varchar 4  √  null
clusterlicenseview nodeName varchar 255  √  null
clusterlicenseview nodeSerialNumber varchar 255  √  null
clusterlicenseview nodeUsageuuid varchar 255  √  null
clusterlicenseview ownerName varchar 255  √  null
clusterlicenseview ownerType varchar 7  √  null
clusterlicenseview risk varchar 10  √  null
clusterlicenseview riskObjid bigint 19  √  null
clusterunconfiguredcapacitymapping ClusterName varchar 255 Textual name
clusterunconfiguredcapacitymapping objid bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterunconfiguredcapacitymapping TotExternalCapacityTierLicensedSpaceUsed decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapacityTierUnLicensedSpaceUsed decimal 41  √  null
clusterunconfiguredcapacitymapping TotExternalCapaityTierLicensedSpace bigint 19  √  null
clusterunconfiguredcapacitymapping unconfiguredRawCapacity decimal 60  √  null
daywiseeventstatustrendchart ackCount decimal 43  √  null
daywiseeventstatustrendchart lastUpdatedTime date 10  √  null
daywiseeventstatustrendchart newCount decimal 44  √  null
daywiseeventstatustrendchart obsoleteCount bigint 19  √  null
daywiseeventstatustrendchart resolvedCount bigint 19  √  null
diskcapacitymapping clusterId bigint 19
diskcapacitymapping unconfiguredRawCapacity decimal 60  √  null
eventseveritytrendchart criticalCount bigint unsigned 20  √  null
eventseveritytrendchart errorCount bigint unsigned 20  √  null
eventseveritytrendchart triggeredDate date 10  √  null
eventseveritytrendchart warningCount bigint unsigned 20  √  null
eventseveritytrendhelper numberOfEvents bigint 19 0
eventseveritytrendhelper severity int 10
eventseveritytrendhelper triggeredDate date 10  √  null
eventstatecharthelper ackCount bigint 19  √  null
eventstatecharthelper ackToResolvedAndObsoleteCount bigint 19  √  null
eventstatecharthelper lastUpdatedTime date 10  √  null
eventstatecharthelper newCount bigint 19  √  null
eventstatecharthelper newToResolvedAndObsoleteCount bigint 19  √  null
eventupdatedates lastUpdatedTime date 10  √  null
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
lunnodecapacitymapping assignedLunCapacity decimal 41  √  null
lunnodecapacitymapping isLunMapped int 10  √  null
lunnodecapacitymapping nodeId bigint 19  √  null
lunnodecapacitymapping unassignedLunCapacity decimal 41  √  null
newevents eventsCount bigint 19 0
newevents lastUpdatedTime date 10  √  null
newevents state varchar 3
newtoresolvedandobsoleteevents eventsCount bigint 19 0
newtoresolvedandobsoleteevents lastUpdatedTime date 10  √  null
newtoresolvedandobsoleteevents state varchar 11
nfsexport clusterName varchar 255
nfsexport exportPolicyName varchar 255  √  null
nfsexport exportPolicyRuleAccessProtocol varchar 255
nfsexport exportPolicyRuleClientMatch varchar 255
nfsexport exportPolicyRuleIndex int 10  √  null
nfsexport exportPolicyRuleRoRule varchar 255  √  null
nfsexport exportPolicyRuleRwRule varchar 255  √  null
nfsexport isJunctionPathActive text 65535  √  null
nfsexport junctionPath varchar 511  √  null
nfsexport qtreeName varchar 255  √  null
nfsexport securityPermission varchar 256  √  null
nfsexport securityStyle varchar 255  √  null
nfsexport volumeName varchar 255
nfsexport volumeState varchar 255  √  null
nfsexport vserverName varchar 255
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
protectunprotectvolumeview clustername varchar 255 Textual name
protectunprotectvolumeview clusternodeName varchar 255  √  null Textual name
protectunprotectvolumeview name varchar 255 Textual name
protectunprotectvolumeview protectionrole varchar 52  √  null
qtreecapacityutilization clusterName varchar 255
qtreecapacityutilization diskLimit bigint 19  √  null
qtreecapacityutilization diskLimitUnlimited tinyint 3  √  null
qtreecapacityutilization diskUsed bigint 19  √  null
qtreecapacityutilization fileLimit bigint 19  √  null
qtreecapacityutilization fileLimitUnlimited tinyint 3  √  null
qtreecapacityutilization fileUsed bigint 19  √  null
qtreecapacityutilization qtreeId bigint 19 0
qtreecapacityutilization qtreeName varchar 255  √  null
qtreecapacityutilization quotaId bigint 19  √  null
qtreecapacityutilization quotaType varchar 10  √  null
qtreecapacityutilization quotaUserName varchar 255  √  null
qtreecapacityutilization softDiskLimit bigint 19  √  null
qtreecapacityutilization softDiskLimitUnlimited tinyint 3  √  null
qtreecapacityutilization softFileLimit bigint 19  √  null
qtreecapacityutilization softFileLimitUnlimited tinyint 3  √  null
qtreecapacityutilization volumeId bigint 19 0
qtreecapacityutilization VolumeName varchar 255
qtreecapacityutilization volumeTotalSize bigint 19  √  null
qtreecapacityutilization VserverName varchar 255
storagesummary aggregateCapacity decimal 10,3  √  null
storagesummary aggregateUsedCapacity decimal 10,3  √  null
storagesummary allocatedLunCapacity decimal 10,3  √  null
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 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
storagesystemhealthtable acknowledgedBy varchar 128  √  null
storagesystemhealthtable acknowledgedTimestamp timestamp 19  √  null
storagesystemhealthtable assignedTimestamp timestamp 19  √  null
storagesystemhealthtable assignedTo varchar 128  √  null
storagesystemhealthtable dataPriority varchar 255  √  null
storagesystemhealthtable event varchar 236  √  null
storagesystemhealthtable impactArea varchar 60  √  null
storagesystemhealthtable impactLevel varchar 8
storagesystemhealthtable numberOfNotes bigint 19  √  null
storagesystemhealthtable obsoleteTimestamp timestamp 19  √  null
storagesystemhealthtable outstandingDays int 10  √  null
storagesystemhealthtable resolvedBy varchar 128  √  null
storagesystemhealthtable resolvedTimestamp timestamp 19  √  null
storagesystemhealthtable severity varchar 11
storagesystemhealthtable sourceFullName varchar 2000
storagesystemhealthtable sourceId bigint 19
storagesystemhealthtable sourceResourceType varchar 40
storagesystemhealthtable state varchar 16
storagesystemhealthtable triggeredTime timestamp 19  √  null
svminventoryreport activeNisDomainName varchar 255  √  null DERIVED. Domain name of the active NIS server - NULL if none is active.
svminventoryreport allowedProtocols varchar 255  √  null Ordered list of allowed protocols. List of: cifs, nfs, iscsi, and fcp
svminventoryreport clusterName varchar 255  √  null
svminventoryreport dnsDomainNames varchar 255  √  null List of DNS domains. The first domain is the one that the Vserver belongs to
svminventoryreport ldapClientEnabled bit 0  √  null If true, the corresponding Lightweight Directory Access Protocol (LDAP) configuration is enabled for this Vserver.
svminventoryreport maximumVolumes int 10  √  null Maximum number of volumes that can be created on the Vserver
svminventoryreport nameServerSwitch varchar 255  √  null Name Server switch configuration details for the Vserver.Multiple values will be ordered comma separated
svminventoryreport rootVolume varchar 255  √  null
svminventoryreport state enum 12  √  null Data serving state of Vserver
svminventoryreport volumeCount bigint 19  √  null
svminventoryreport vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
svminventoryreport vserverName varchar 255 Textual name
unprotectvolumeview autogrow varchar 1024  √  null
unprotectvolumeview availableDataCapacity bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
unprotectvolumeview bytesUsedPerDay double 22  √  0
unprotectvolumeview clusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
unprotectvolumeview clusterName varchar 255  √  null Textual name
unprotectvolumeview compressionEnabled varchar 1024  √  null
unprotectvolumeview compressionSpaceSavings bigint 19  √  null The total disk space (in bytes) that is saved by compressing blocks on the referenced file system
unprotectvolumeview daysToFull bigint unsigned 20  √  null
unprotectvolumeview deduplicationEnabled varchar 1024  √  null
unprotectvolumeview dedupSpaceSavings bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
unprotectvolumeview expiryDate varchar 64  √  null
unprotectvolumeview growthRateThreshold 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
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
unprotectvolumeview protectionRole varchar 13
unprotectvolumeview quotaCommittedCapacity bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
unprotectvolumeview quotaOvercommittedCapacity bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
unprotectvolumeview snapLockType varchar 255  √  null
unprotectvolumeview snapshotAutodelete varchar 1024  √  null
unprotectvolumeview snapshotAvailableCapacity double 22  √  null
unprotectvolumeview 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
unprotectvolumeview spaceFullThreshold varchar 255  √  null
unprotectvolumeview spaceGuarantee varchar 255  √  null
unprotectvolumeview spaceNearlyFullThreshold varchar 255  √  null
unprotectvolumeview SVM varchar 255  √  null Textual name
unprotectvolumeview thinProvisioning varchar 1024  √  null
unprotectvolumeview totalDataCapacity bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
unprotectvolumeview usedDataCapacity bigint 19  √  null Used size of the volume in bytes
unprotectvolumeview volume varchar 255 Textual name
unprotectvolumeview volumeState varchar 255  √  null
volumecapacityutilization autoGrowState varchar 1024  √  null
volumecapacityutilization availableDataCapacity bigint 19  √  null DERIVED. Difference between sizeTotal and sizeUsed.
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
volumecapacityutilization clusterId bigint 19
volumecapacityutilization clusterName varchar 255  √  null
volumecapacityutilization compressionSpaceSaved 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
volumecapacityutilization daysToFull bigint unsigned 20  √  null
volumecapacityutilization daysUntilFullThreshold varchar 255  √  null
volumecapacityutilization dedupeEnabled varchar 1024  √  null
volumecapacityutilization deduplicationSpaceSaved bigint 19  √  null The total disk space (in bytes) that is saved by deduplication
volumecapacityutilization expiryDate varchar 64  √  null
volumecapacityutilization growthRateSensitivityThreshold varchar 255  √  null
volumecapacityutilization growthRateThreshold varchar 255  √  null
volumecapacityutilization inodesFullThreshold varchar 255  √  null
volumecapacityutilization inodesNearlyFullThreshold varchar 255  √  null
volumecapacityutilization isSnapshotAutoDeleteEnabled varchar 1024  √  null
volumecapacityutilization isThinProvisioned varchar 1024  √  null
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
volumecapacityutilization quotaCommitted bigint 19  √  null DERIVED. Sum of quota limits on all Qtrees on this Volume.
volumecapacityutilization quotaNearlyOvercommittedThreshold varchar 255  √  null
volumecapacityutilization quotaOverCommitted bigint 19  √  null DERIVED. QuotaCommitted bytes adjusted by the volume size and snapshot size.
volumecapacityutilization quotaOvercommittedThreshold varchar 255  √  null
volumecapacityutilization snapLockType varchar 255  √  null
volumecapacityutilization snapshotAvailableCapacity double 22  √  null
volumecapacityutilization snapshotCountThreshold varchar 255  √  null
volumecapacityutilization SnapshotFullThreshold varchar 255  √  null
volumecapacityutilization snapshotReserveDaysUntilFullThreshold varchar 255  √  null
volumecapacityutilization snapshotTotalCapacity bigint 19  √  null The size (in bytes) in the volume that has been set aside as reserve for snapshot usage
volumecapacityutilization snapshotUsedCapacity double 22  √  null
volumecapacityutilization spaceFullThreshold varchar 255  √  null
volumecapacityutilization spaceGuarantee varchar 255  √  null
volumecapacityutilization spaceNearlyFullThreshold varchar 255  √  null
volumecapacityutilization state varchar 255  √  null
volumecapacityutilization tieringPolicy varchar 255  √  null Identifies assicated tiering policy for a volume
volumecapacityutilization totalDataCapacity bigint 19  √  null Usable size of volume in bytes for data (not including WAFL reserve or snapshot reserve)
volumecapacityutilization usedDataCapacity bigint 19  √  null Used size of the volume in bytes
volumecapacityutilization volumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumecapacityutilization volumeName varchar 255 Textual name
volumecapacityutilization vserverId bigint 19
volumecapacityutilization vserverName varchar 255  √  null
volumecapacityutilizationhistory dfKBytesUsedSum bigint 19 0
volumecapacityutilizationhistory periodEndTime timestamp 19 0000-00-00 00:00:00
volumecapacityutilizationhistory volumeId bigint 19
volumenodecapacitymapping nodeId bigint 19  √  null
volumenodecapacitymapping totalVolumeCapacity decimal 41  √  null
volumenodecapacitymapping volumeProtectionCapacity decimal 41  √  null
volumenodecapacitymapping volumeUsedCapacity decimal 42  √  null
volumerelationshiphistoryaggweekhourview aggTransferSize decimal 41  √  null
volumerelationshiphistoryaggweekhourview day varchar 9  √  null
volumerelationshiphistoryaggweekhourview dayCount int 10  √  null
volumerelationshiphistoryaggweekhourview endDate date 10  √  null
volumerelationshiphistoryaggweekhourview endTime varchar 13  √  null
volumerelationshiphistorychartcountview failCount int 10 0
volumerelationshiphistorychartcountview successCount int 10 0
volumerelationshiphistorychartcountview triggerdDate varchar 10  √  null
volumerelationshiphistorychartview failCount decimal 32  √  null
volumerelationshiphistorychartview successCount decimal 32  √  null
volumerelationshiphistorychartview totalCount decimal 33  √  null
volumerelationshiphistorychartview triggerdDate varchar 10  √  null
volumerelationshiphistorydayview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistorydayview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorydayview destinationClusterName varchar 255 Textual name
volumerelationshiphistorydayview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorydayview destinationVolumeName varchar 255 Textual name
volumerelationshiphistorydayview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorydayview destinationVserverName varchar 255 Textual name
volumerelationshiphistorydayview endTime datetime 19  √  null
volumerelationshiphistorydayview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistorydayview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistorydayview readableCreateTime datetime 19  √  null
volumerelationshiphistorydayview readableUpdateTime datetime 19  √  null
volumerelationshiphistorydayview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorydayview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistorydayview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorydayview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistorydayview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorydayview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistorydayview startTime datetime 19  √  null
volumerelationshiphistorydayview transferDuration bigint 19  √  null
volumerelationshiphistorydayview transfersize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistorydayview 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 additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistorymonthview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorymonthview destinationClusterName varchar 255 Textual name
volumerelationshiphistorymonthview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorymonthview destinationVolumeName varchar 255 Textual name
volumerelationshiphistorymonthview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorymonthview destinationVserverName varchar 255 Textual name
volumerelationshiphistorymonthview endTime datetime 19  √  null
volumerelationshiphistorymonthview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistorymonthview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistorymonthview readableCreateTime datetime 19  √  null
volumerelationshiphistorymonthview readableUpdateTime datetime 19  √  null
volumerelationshiphistorymonthview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistorymonthview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistorymonthview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistorymonthview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistorymonthview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistorymonthview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistorymonthview startTime datetime 19  √  null
volumerelationshiphistorymonthview transferDuration bigint 19  √  null
volumerelationshiphistorymonthview transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistorymonthview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistorymonthview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistoryview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistoryview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryview destinationClusterName varchar 255 Textual name
volumerelationshiphistoryview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryview destinationVolumeName varchar 255 Textual name
volumerelationshiphistoryview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryview destinationVserverName varchar 255 Textual name
volumerelationshiphistoryview endTime datetime 19  √  null
volumerelationshiphistoryview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistoryview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistoryview readableCreateTime datetime 19  √  null
volumerelationshiphistoryview readableUpdateTime datetime 19  √  null
volumerelationshiphistoryview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistoryview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistoryview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistoryview startTime datetime 19  √  null
volumerelationshiphistoryview transferDuration bigint 19  √  null
volumerelationshiphistoryview transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistoryview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistoryview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistoryweekview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistoryweekview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryweekview destinationClusterName varchar 255 Textual name
volumerelationshiphistoryweekview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryweekview destinationVolumeName varchar 255 Textual name
volumerelationshiphistoryweekview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryweekview destinationVserverName varchar 255 Textual name
volumerelationshiphistoryweekview endTime datetime 19  √  null
volumerelationshiphistoryweekview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistoryweekview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistoryweekview Readablecreatetime datetime 19  √  null
volumerelationshiphistoryweekview Readableupdatetime datetime 19  √  null
volumerelationshiphistoryweekview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryweekview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistoryweekview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryweekview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistoryweekview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryweekview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistoryweekview startTime datetime 19  √  null
volumerelationshiphistoryweekview transferDuration bigint 19  √  null
volumerelationshiphistoryweekview transfersize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistoryweekview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistoryweekview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshiphistoryyearview additionalInfo varchar 255  √  null A message describing the cause of the failure or additional information about a successful operation.
volumerelationshiphistoryyearview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryyearview destinationClusterName varchar 255 Textual name
volumerelationshiphistoryyearview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryyearview destinationVolumeName varchar 255 Textual name
volumerelationshiphistoryyearview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryyearview destinationVserverName varchar 255 Textual name
volumerelationshiphistoryyearview endTime datetime 19  √  null
volumerelationshiphistoryyearview operationResult varchar 255  √  null The result of the SnapMirror operation.
volumerelationshiphistoryyearview operationType varchar 255  √  null The type of the operation happened on the relationship.
volumerelationshiphistoryyearview readableCreateTime datetime 19  √  null
volumerelationshiphistoryyearview readableUpdateTime datetime 19  √  null
volumerelationshiphistoryyearview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshiphistoryyearview sourceClusterName varchar 255  √  null Textual name
volumerelationshiphistoryyearview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshiphistoryyearview sourceVolumeName varchar 255  √  null Textual name
volumerelationshiphistoryyearview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshiphistoryyearview sourceVserverName varchar 255  √  null Textual name
volumerelationshiphistoryyearview startTime datetime 19  √  null
volumerelationshiphistoryyearview transferDuration bigint 19  √  null
volumerelationshiphistoryyearview transferSize bigint 19  √  null The total number of bytes transferred as part of the transfer operation.
volumerelationshiphistoryyearview unixformatEndTime bigint 19  √  null The timestamp of the end time of the operation.
volumerelationshiphistoryyearview unixformatStartTime bigint 19  √  null The timestamp of the start time of the operation.
volumerelationshipinventoryview controlPlane varchar 255  √  null The type of the control plane used for the relationship.
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
volumerelationshipinventoryview destinationClusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
volumerelationshipinventoryview destinationClusterName varchar 255 Textual name
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 destinationVolumeHealthStatus int 10
volumerelationshipinventoryview destinationVolumeId bigint 19 Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshipinventoryview destinationVolumeName varchar 255 Textual name
volumerelationshipinventoryview destinationVolumeState varchar 255  √  null
volumerelationshipinventoryview destinationVolumeType varchar 255  √  null
volumerelationshipinventoryview destinationVserverHealthStatus int 10
volumerelationshipinventoryview destinationVserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshipinventoryview destinationVserverName varchar 255 Textual name
volumerelationshipinventoryview healthStatus int 10
volumerelationshipinventoryview id bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
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
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
volumerelationshipinventoryview name varchar 2048
volumerelationshipinventoryview objectId bigint 19 Locally unique object identifier. ZAPIs: snapmirror-get-iter.snapmirror-info
volumerelationshipinventoryview overallStatus enum 7  √  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
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
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"
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
volumerelationshipinventoryview sourceClusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
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
volumerelationshipinventoryview sourceVolumeId bigint 19  √  null Locally unique object identifier. ZAPIs: volume-get-iter.volume-attributes
volumerelationshipinventoryview sourceVolumeName varchar 255  √  null Textual name
volumerelationshipinventoryview sourceVolumeState varchar 255  √  null
volumerelationshipinventoryview sourceVolumeType varchar 255  √  null
volumerelationshipinventoryview sourceVserverHealthStatus int 10  √  null
volumerelationshipinventoryview sourceVserverId bigint 19  √  null Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
volumerelationshipinventoryview sourceVserverName varchar 255  √  null Textual name
volumerelationshipinventoryview transferPriority varchar 255  √  null
volumerelationshipinventoryview unhealthyReason varchar 255  √  null The reason the relationship is not healthy
volumerelationshipinventoryview versionFlexibleReplication enum 15 none