View netapp_model_view.aggregate_full | Generated by SchemaSpy |
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`,`netapp_model`.`aggregate`.`objState` AS `objState` from `netapp_model`.`aggregate`