View ocum_report.aggregate | Generated by SchemaSpy |
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: