View netapp_model_view.aggregate Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19 Locally unique object identifier. ZAPIs: aggr-get-iter.aggr-attributes
uuid varchar 255 Globally unique ID of the aggregate
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
nodeId bigint 19
type varchar 255  √  null The type of aggregate. Possible values: aggr, trad "aggr" (for aggregates that can contain flexible volumes) "trad" (for aggregates embedded in traditional volumes)
isHybrid bit 0  √  null If true, aggregate currently contains both SSD and non-SSD RAID groups
isHybridEnabled bit 0  √  null If true, aggregate is eligible to contain both SSD and non-SSD RAID groups
usesSharedDisks bit 0  √  null
state enum 15  √  null State of aggregatha_paire
stateRaw varchar 255  √  null
aggregateType enum 11  √  null Aggregate Type.
aggregateTypeRaw varchar 255  √  null Raw aggregate type.
aggregateDerivedType enum 17  √  null Aggregate Derived Type.
snapshotSizeTotal 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
snapshotSizeUsed 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
snapshotSizeAvail bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-snapshot-attributes size-available
hybridCacheSizeTotal bigint 19  √  null Total cache size (in bytes) in a hybrid aggregate. If the referenced aggregate is restricted or offline, or if it is not a hybrid aggregate, a value of 0 is returned
sizeTotal 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
sizeUsed 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
sizeUsedPercent int 10  √  null Size used on aggregate as a percentage of total. ZAPIs: aggr-get-iter aggr-space-attributes percent-used-capacity
sizeAvail bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-space-attributes size-available
sizeAvailPercent int 10  √  null DERIVED. Size available on aggregate as a percentage of total.
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.
totalReservedSpace bigint 19  √  null The total disk space in bytes that is reserved on the referenced file system. The reserved space is already counted in the used space, so this element can be used to see what portion of the used space represents space reserved for future use
isInactiveDataReportingEnabled bit 0  √  null If true, then this aggregate and the volumes on this aggregate will have their inactive data reported after the default time
raidStatus varchar 255  √  null RAID status as string
raidType enum 15  √  null
raidTypeRaw varchar 255  √  null
mirrorStatus enum 26  √  null Aggregate's mirror status, ZAPIs: aggr-get-iter mirror-status
mirrorStatusRaw varchar 255  √  null
blockType enum 10  √  null The indirect block format that the aggregate can have. ZAPIs: aggr-get-iter block-type
blockTypeRaw varchar 255  √  null
is64BitUpgradeInProgress bit 0  √  null True if the 64-bit upgrade is in progress. ZAPIs: aggr-get-iter is-64-bit-upgrade-in-progress
volumeDedupeSpaceSavings bigint 19  √  null [DERVIED] Sum of dedupe savings on SIS enabled Volumes residing on this Aggregate. In bytes.
volumeCompressionSpaceSavings bigint 19  √  null [DERVIED] Sum of compression savings on SIS enabled Volumes residing on this Aggregate. In bytes.
raidSize bigint 19  √  null Specifies the maximum number of disks in each RAID group in the aggregate. The maximum value for this parameter is 28. ZAPIs: aggr-get-iter raid-size
isRootAggregate bit 0  √  null this indicates if this aggregate is a root aggregate.
hasLocalRoot bit 0  √  null Whether the aggregate contains the local root volume. ZAPIs: aggr-get-iter has-local-root.
hasPartnerRoot bit 0  √  null Whether the aggregate contains the partner's root volume. ZAPIs: aggr-get-iter has-partner-root.
isCftPreCommit bit 0  √  null Indicates whether the aggregate is a 7-mode transitioned aggregate in pre-commit phase
isSnapLock bit 0  √  null Indicates whether or not its a SnapLock aggregate
snapLockType enum 11  √  null type of the snaplock aggregate
snapLockTypeRaw varchar 255  √  null raw type of the snaplock aggregate
totalStorageEfficiencyRatio varchar 20  √  null Indicates the total storage efficiency ratio of an aggregate
isComposite bit 0  √  null Indicates whether or not its a Composite aggregate
totalUsedExternalLicensedSpace bigint 19  √  null
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`aggregate`.`objid` AS `objid`,`netapp_model`.`aggregate`.`uuid` AS `uuid`,`netapp_model`.`aggregate`.`resourceKey` AS `resourceKey`,`netapp_model`.`aggregate`.`name` AS `name`,`netapp_model`.`aggregate`.`clusterId` AS `clusterId`,`netapp_model`.`aggregate`.`nodeId` AS `nodeId`,`netapp_model`.`aggregate`.`type` AS `type`,`netapp_model`.`aggregate`.`isHybrid` AS `isHybrid`,`netapp_model`.`aggregate`.`isHybridEnabled` AS `isHybridEnabled`,`netapp_model`.`aggregate`.`usesSharedDisks` AS `usesSharedDisks`,`netapp_model`.`aggregate`.`state` AS `state`,`netapp_model`.`aggregate`.`stateRaw` AS `stateRaw`,`netapp_model`.`aggregate`.`aggregateType` AS `aggregateType`,`netapp_model`.`aggregate`.`aggregateTypeRaw` AS `aggregateTypeRaw`,`netapp_model`.`aggregate`.`aggregateDerivedType` AS `aggregateDerivedType`,`netapp_model`.`aggregate`.`snapshotSizeTotal` AS `snapshotSizeTotal`,`netapp_model`.`aggregate`.`snapshotSizeUsed` AS `snapshotSizeUsed`,`netapp_model`.`aggregate`.`snapshotSizeAvail` AS `snapshotSizeAvail`,`netapp_model`.`aggregate`.`hybridCacheSizeTotal` AS `hybridCacheSizeTotal`,`netapp_model`.`aggregate`.`sizeTotal` AS `sizeTotal`,`netapp_model`.`aggregate`.`sizeUsed` AS `sizeUsed`,`netapp_model`.`aggregate`.`sizeUsedPercent` AS `sizeUsedPercent`,`netapp_model`.`aggregate`.`sizeAvail` AS `sizeAvail`,`netapp_model`.`aggregate`.`sizeAvailPercent` AS `sizeAvailPercent`,`netapp_model`.`aggregate`.`totalCommitted` AS `totalCommitted`,`netapp_model`.`aggregate`.`totalReservedSpace` AS `totalReservedSpace`,`netapp_model`.`aggregate`.`isInactiveDataReportingEnabled` AS `isInactiveDataReportingEnabled`,`netapp_model`.`aggregate`.`raidStatus` AS `raidStatus`,`netapp_model`.`aggregate`.`raidType` AS `raidType`,`netapp_model`.`aggregate`.`raidTypeRaw` AS `raidTypeRaw`,`netapp_model`.`aggregate`.`mirrorStatus` AS `mirrorStatus`,`netapp_model`.`aggregate`.`mirrorStatusRaw` AS `mirrorStatusRaw`,`netapp_model`.`aggregate`.`blockType` AS `blockType`,`netapp_model`.`aggregate`.`blockTypeRaw` AS `blockTypeRaw`,`netapp_model`.`aggregate`.`is64BitUpgradeInProgress` AS `is64BitUpgradeInProgress`,`netapp_model`.`aggregate`.`volumeDedupeSpaceSavings` AS `volumeDedupeSpaceSavings`,`netapp_model`.`aggregate`.`volumeCompressionSpaceSavings` AS `volumeCompressionSpaceSavings`,`netapp_model`.`aggregate`.`raidSize` AS `raidSize`,`netapp_model`.`aggregate`.`isRootAggregate` AS `isRootAggregate`,`netapp_model`.`aggregate`.`hasLocalRoot` AS `hasLocalRoot`,`netapp_model`.`aggregate`.`hasPartnerRoot` AS `hasPartnerRoot`,`netapp_model`.`aggregate`.`isCftPreCommit` AS `isCftPreCommit`,`netapp_model`.`aggregate`.`isSnapLock` AS `isSnapLock`,`netapp_model`.`aggregate`.`snapLockType` AS `snapLockType`,`netapp_model`.`aggregate`.`snapLockTypeRaw` AS `snapLockTypeRaw`,`netapp_model`.`aggregate`.`totalStorageEfficiencyRatio` AS `totalStorageEfficiencyRatio`,`netapp_model`.`aggregate`.`isComposite` AS `isComposite`,`netapp_model`.`aggregate`.`totalUsedExternalLicensedSpace` AS `totalUsedExternalLicensedSpace`,`netapp_model`.`aggregate`.`createtime` AS `createTime`,`netapp_model`.`aggregate`.`updatetime` AS `updateTime` from `netapp_model`.`aggregate` where (`netapp_model`.`aggregate`.`objState` = 'LIVE')