View ocum_report.disk | Generated by SchemaSpy |
View Definition:
select `disk`.`objid` AS `id`,`disk`.`uuid` AS `uuid`,`disk`.`name` AS `name`,`disk`.`clusterId` AS `clusterId`,`disk`.`homeNodeId` AS `homeNodeId`,`disk`.`ownerNodeId` AS `ownerNodeId`,`disk`.`activeNodeId` AS `activeNodeId`,`disk`.`raidGroupId` AS `raidGroupId`,`disk`.`interfaceTypeRaw` AS `interfaceType`,`disk`.`effectiveInterfaceTypeRaw` AS `effectiveInterfaceType`,`disk`.`model` AS `model`,`disk`.`firmwareRevision` AS `firmwareRevision`,`disk`.`rpm` AS `rpm`,`disk`.`serialNumber` AS `serialNumber`,`disk`.`pool` AS `pool`,`disk`.`checksumCompatibility` AS `checksumCompatibility`,`disk`.`shelf` AS `shelf`,`disk`.`shelfBay` AS `shelfBay`,`disk`.`vendor` AS `vendor`,`disk`.`containerTypeRaw` AS `containerType`,`disk`.`isFailed` AS `isFailed`,`disk`.`physicalBlocks` AS `physicalBlocks`,`disk`.`usedBlocks` AS `usedBlocks`,`disk`.`usedBytes` AS `usedBytes`,`disk`.`totalBytes` AS `totalBytes`,`disk`.`bytesPerSector` AS `bytesPerSector`,`disk`.`raidPositionRaw` AS `raidPosition`,`disk`.`isVirtual` AS `isVirtual`,`disk`.`isZeroed` AS `isZeroed`,`disk`.`isMediaScrubbing` AS `isMediaScrubbing`,`disk`.`isOffline` AS `isOffline`,`disk`.`isPrefailed` AS `isPrefailed`,`disk`.`isReconstructing` AS `isReconstructing`,`disk`.`isReplacing` AS `isReplacing`,`disk`.`capacitySectors` AS `capacitySectors`,`disk`.`percentSparesConsumed` AS `percentSparesConsumed`,`disk`.`percentRatedLifeUsed` AS `percentRatedLifeUsed`,`disk`.`rightSizeSectors` AS `rightSizeSectors`,`disk`.`createTime` AS `createtime`,`disk`.`isInFdr` AS `isInFdr`,`disk`.`failedReason` AS `failedReason` from `netapp_model_view`.`disk`
Possibly Referenced Tables/Views: