View ocum_report.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
id bigint 19
uuid varchar 255 Globally unique ID of the aggregate
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
isComposite bit 0  √  null Indicates whether or not its a Composite aggregate
aggregateTypeRaw varchar 255  √  null Raw aggregate type.
state varchar 255  √  null
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
raidStatus varchar 255  √  null RAID status as string
raidType varchar 255  √  null
mirrorStatus varchar 255  √  null
blockType varchar 255  √  null
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
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.
daysUntilFull double 22  √  null
usedExternalCapacityTierSpace bigint 19  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `ocumaggregate`.`id` AS `id`,`aggregate`.`uuid` AS `uuid`,`aggregate`.`name` AS `name`,`aggregate`.`clusterId` AS `clusterId`,`aggregate`.`nodeId` AS `nodeId`,`aggregate`.`type` AS `type`,`aggregate`.`isHybrid` AS `isHybrid`,`aggregate`.`isHybridEnabled` AS `isHybridEnabled`,`aggregate`.`isComposite` AS `isComposite`,`aggregate`.`aggregateTypeRaw` AS `aggregateTypeRaw`,`aggregate`.`stateRaw` AS `state`,`aggregate`.`snapshotSizeTotal` AS `snapshotSizeTotal`,`aggregate`.`snapshotSizeUsed` AS `snapshotSizeUsed`,`aggregate`.`snapshotSizeAvail` AS `snapshotSizeAvail`,`aggregate`.`hybridCacheSizeTotal` AS `hybridCacheSizeTotal`,`aggregate`.`sizeTotal` AS `sizeTotal`,`aggregate`.`sizeUsed` AS `sizeUsed`,`aggregate`.`sizeUsedPercent` AS `sizeUsedPercent`,`aggregate`.`sizeAvail` AS `sizeAvail`,`aggregate`.`sizeAvailPercent` AS `sizeAvailPercent`,`aggregate`.`totalCommitted` AS `totalCommitted`,`aggregate`.`totalReservedSpace` AS `totalReservedSpace`,`aggregate`.`raidStatus` AS `raidStatus`,`aggregate`.`raidTypeRaw` AS `raidType`,`aggregate`.`mirrorStatusRaw` AS `mirrorStatus`,`aggregate`.`blockTypeRaw` AS `blockType`,`aggregate`.`volumeDedupeSpaceSavings` AS `volumeDedupeSpaceSavings`,`aggregate`.`volumeCompressionSpaceSavings` AS `volumeCompressionSpaceSavings`,`aggregate`.`raidSize` AS `raidSize`,`aggregate`.`hasLocalRoot` AS `hasLocalRoot`,`aggregate`.`hasPartnerRoot` AS `hasPartnerRoot`,`ocumaggregate`.`daysUntilFull` AS `daysUntilFull`,`aggregate`.`totalUsedExternalLicensedSpace` AS `usedExternalCapacityTierSpace` from (`netapp_model_view`.`aggregate` join `ocum`.`aggregate` `ocumaggregate` on((`ocumaggregate`.`id` = `aggregate`.`objid`)))
 
Possibly Referenced Tables/Views: