View ocum_report.disk 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 Locally unique object identifier. ZAPIs: storage-disk-get-iter.storage-disk-info
uuid varchar 255 Globally unique ID of the disk
name varchar 255 Textual name
clusterId bigint 19
homeNodeId bigint 19  √  null
ownerNodeId bigint 19  √  null
activeNodeId bigint 19  √  null
raidGroupId bigint 19  √  null
interfaceType varchar 255  √  null
effectiveInterfaceType varchar 255  √  null
model varchar 255  √  null Disk model string
firmwareRevision varchar 255  √  null Firmware revision of disk. The format of the firmware revision will vary depending on the type of disk and its vendor
rpm int 10  √  null Disk RPM
serialNumber varchar 255  √  null Disk serial number
pool int 10  √  null Pool to which disk is assigned. ZAPIs: storage-disk-get-iter disk-ownership-info pool
checksumCompatibility varchar 255  √  null An indication of the checksum types that this disk is capable of supporting. ZAPIs: storage-disk-get-iter disk-inventory-info checksum-compatability.
shelf varchar 255  √  null Disk shelf, if it can be determined
shelfBay varchar 255  √  null Disk shelf bay, if it can be determined
vendor varchar 255  √  null Disk vendor
containerType varchar 255  √  null
isFailed bit 0  √  null Disk failed
physicalBlocks bigint 19  √  null RAID recorded disk capacity expressed in units of 4096-byte blocks
usedBlocks bigint 19  √  null RAID recorded size of file system region on this disk, given in units of 4096-byte blocks.
usedBytes bigint 19  √  null DERIVED from usedBlocks * 4096 bytes/block.
totalBytes bigint 19  √  null DERIVED from totalBlocks * 4096 bytes/block.
bytesPerSector bigint 19  √  null Number of bytes per disk sector. A sector count element, such as `capacity-sectors` and `right-size-sectors`, may be multiplied by this value to convert to a byte count.
raidPosition varchar 255  √  null
isVirtual bit 0  √  null To determine if disk is virtual
isZeroed bit 0  √  null True if disk is in pre-zeroed state. ZAPIs: storage-disk-get-iter disk-aggregate-info is-zeroed
isMediaScrubbing bit 0  √  null True if media scrub is currently active for this disk. ZAPIs: storage-disk-get-iter disk-aggregate-info is-media-scrubbing
isOffline bit 0  √  null True if disk is offline. ZAPIs: storage-disk-get-iter disk-aggregate-info is-offline
isPrefailed bit 0  √  null True if the admin issued a 'disk fail' or if the the system marked this disk for Rapid RAID Recovery. ZAPIs: storage-disk-get-iter disk-aggregate-info is-prefailed
isReconstructing bit 0  √  null True if disk is in process of being reconstructed. ZAPIs: storage-disk-get-iter disk-aggregate-info is-reconstructing
isReplacing bit 0  √  null True if the admin issued 'disk replace' to replace this disk with a specified replacement disk. ZAPIs: storage-disk-get-iter disk-aggregate-info is-replacing
capacitySectors bigint 19  √  null Total number of disk sectors on this disk, given in units of 'bytes-per-sector'. ZAPI: disk-inventory-info.capacity-sectors
percentSparesConsumed int 10  √  null Percentage of device spare blocks that have been used.
percentRatedLifeUsed int 10  √  null An estimate of the percentage of device life that has been used
rightSizeSectors bigint 19  √  null Number of usable disk sectors that remain after subtracting the right-size adjustment for this disk. Given in units of 'bytes-per-sector'. ZAPI: disk-inventory-info.right-size-sectors
createtime bigint 19
isInFdr bit 0  √  null True if disk has entry in the persistent Failed Disk Registry. ZAPI: storage-disk-get-iter.disk-raid-info.disk-outage-info.is-in-fdr
failedReason varchar 255  √  null Reason disk is not in service. ZAPI: storage-disk-get-iter.disk-raid-info.disk-outage-info.reason

Analyzed at Tue Apr 23 04:52 EDT 2019

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:
disk