View netapp_model_view.disk_full | Generated by SchemaSpy |
View Definition:
select `d`.`objid` AS `objid`,`d`.`uuid` AS `uuid`,`d`.`resourceKey` AS `resourceKey`,`d`.`name` AS `name`,`d`.`uid` AS `uid`,`d`.`clusterId` AS `clusterId`,`d`.`homeNodeId` AS `homeNodeId`,`d`.`homeNodeName` AS `homeNodeName`,`d`.`ownerNodeId` AS `ownerNodeId`,`d`.`ownerNodeName` AS `ownerNodeName`,`d`.`activeNodeId` AS `activeNodeId`,`d`.`activeNodeName` AS `activeNodeName`,`d`.`raidGroupId` AS `raidGroupId`,`d`.`storagePoolId` AS `storagePoolId`,`d`.`partitioningType` AS `partitioningType`,`d`.`partitioningTypeRaw` AS `partitioningTypeRaw`,`d`.`interfaceType` AS `interfaceType`,`d`.`interfaceTypeRaw` AS `interfaceTypeRaw`,`d`.`effectiveInterfaceType` AS `effectiveInterfaceType`,`d`.`effectiveInterfaceTypeRaw` AS `effectiveInterfaceTypeRaw`,`d`.`model` AS `model`,`d`.`firmwareRevision` AS `firmwareRevision`,`d`.`rpm` AS `rpm`,`d`.`serialNumber` AS `serialNumber`,`d`.`shelf` AS `shelf`,`d`.`shelfBay` AS `shelfBay`,`d`.`vendor` AS `vendor`,`d`.`containerType` AS `containerType`,`d`.`containerTypeRaw` AS `containerTypeRaw`,`d`.`isFailed` AS `isFailed`,`d`.`physicalBlocks` AS `physicalBlocks`,`d`.`raidPosition` AS `raidPosition`,`d`.`raidPositionRaw` AS `raidPositionRaw`,`d`.`isVirtual` AS `isVirtual`,`d`.`usableDataSize` AS `usableDataSize`,`d`.`usableRootSize` AS `usableRootSize`,`d`.`bytesPerSector` AS `bytesPerSector`,`d`.`usedBlocks` AS `usedBlocks`,`d`.`usedBytes` AS `usedBytes`,`d`.`totalBytes` AS `totalBytes`,`d`.`isZeroed` AS `isZeroed`,`d`.`isZeroing` AS `isZeroing`,`d`.`zeroingPercent` AS `zeroingPercent`,`d`.`pool` AS `pool`,`d`.`checksumCompatibility` AS `checksumCompatibility`,`d`.`isMediaScrubbing` AS `isMediaScrubbing`,`d`.`isOffline` AS `isOffline`,`d`.`isPrefailed` AS `isPrefailed`,`d`.`isReconstructing` AS `isReconstructing`,`d`.`isReplacing` AS `isReplacing`,`d`.`isShared` AS `isShared`,`d`.`isLocalAttach` AS `isLocalAttach`,`d`.`capacitySectors` AS `capacitySectors`,`d`.`rightSizeSectors` AS `rightSizeSectors`,`d`.`percentSparesConsumed` AS `percentSparesConsumed`,`d`.`percentRatedLifeUsed` AS `percentRatedLifeUsed`,`d`.`isInFdr` AS `isInFdr`,`d`.`failedReason` AS `failedReason`,`d`.`createtime` AS `createTime`,`d`.`updatetime` AS `updateTime`,`d`.`objState` AS `objState` from `netapp_model`.`disk` `d`