View netapp_model_view.disk_full 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
objid bigint 19 Locally unique object identifier. ZAPIs: storage-disk-get-iter.storage-disk-info
uuid varchar 255 Globally unique ID of the disk
resourceKey varchar 512
name varchar 255 Textual name
uid varchar 255  √  null Disk unique identifier. Maximum length of 90 characters. ZAPIs: storage-disk-get-iter storage-disk-info disk-uid
clusterId bigint 19
homeNodeId bigint 19  √  null
homeNodeName varchar 255  √  null Show homeNodeName so that homeNodeId can be found for home node in remote cluster.
ownerNodeId bigint 19  √  null
ownerNodeName varchar 255  √  null Show ownerNodeName so that ownerNodeId can be found for owner node in remote cluster.
activeNodeId bigint 19  √  null
activeNodeName varchar 255  √  null Show activeNodeName so that activeNodeId can be found for active node in remote cluster.
raidGroupId bigint 19  √  null
storagePoolId bigint 19  √  null
partitioningType enum 12  √  null Disk partitioning Type.
partitioningTypeRaw varchar 255  √  null Raw disk partitioning type.
interfaceType enum 11  √  null Type of disk
interfaceTypeRaw varchar 255  √  null
effectiveInterfaceType enum 11  √  null Effective Type of disk
effectiveInterfaceTypeRaw 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
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 enum 11  √  null Type of overlying disk container
containerTypeRaw varchar 255  √  null
isFailed bit 0  √  null Disk failed
physicalBlocks bigint 19  √  null RAID recorded disk capacity expressed in units of 4096-byte blocks
raidPosition enum 11  √  null Position of disk relative to its container-type
raidPositionRaw varchar 255  √  null
isVirtual bit 0  √  null To determine if disk is virtual
usableDataSize bigint 19  √  null If non-zero, indicates amount of usable space for a disk partition.
usableRootSize bigint 19  √  null If non-zero, indicates amount of usable space for a root partition.
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.
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.
isZeroed bit 0  √  null True if disk is in pre-zeroed state. ZAPIs: storage-disk-get-iter disk-aggregate-info is-zeroed
isZeroing bit 0  √  null True only if disk position is 'pending' and disk is in process of being zeroed. ZAPIs: storage-disk-get-iter disk-aggregate-info is-zeroing
zeroingPercent int 10  √  null Percent completion of disk zeroing. ZAPIs: storage-disk-get-iter disk-aggregate-info zeroing-percent-complete
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.
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
isShared bit 0  √  null
isLocalAttach bit 0  √  null Indicator if the disk is locally attached.
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
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
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
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
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

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`