View ocum.disklivelistdtoview 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
objectId bigint 19 Locally unique object identifier. ZAPIs: storage-disk-get-iter.storage-disk-info
id bigint 19 Locally unique object identifier. ZAPIs: storage-disk-get-iter.storage-disk-info
name varchar 255 Textual name
healthStatus int 10
clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterName varchar 255 Textual name
clusterHealthStatus int 10
ownerNodeId bigint 19  √  null Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
ownerNodeName varchar 255  √  null Textual name
ownerNodeClusterId bigint 19  √  null
ownerNodeHealthStatus int 10  √  null
raidState varchar 40  √  null
containerType varchar 255  √  null
raidType varchar 255  √  null
usedBytes bigint 19  √  null DERIVED from usedBlocks * 4096 bytes/block.
totalBytes bigint 19  √  null DERIVED from totalBlocks * 4096 bytes/block.
diskType varchar 255  √  null
wearLevelPercent 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
effectiveType varchar 255  √  null
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
vendorName varchar 255  √  null Disk vendor
model varchar 255  √  null Disk model string
shelf varchar 255  √  null Disk shelf, if it can be determined
bay varchar 255  √  null Disk shelf bay, if it can be determined
raidGroupName varchar 255  √  null Textual name
isLocalAttach int 10  √  null
storagePoolName varchar 255  √  null The cluster-wide unique name of the storage pool.
storagePoolId bigint 19  √  null Locally unique object identifier. ZAPI: storage-pool-get-iter.storage-pool-info
storagePoolHealthStatus int 10  √  null
impactedAggregateId bigint 19  √  null
impactedAggregateName varchar 255  √  null
impactedAggregateHealthStatus bigint 19  √  null
impactedAggregatesCount bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorydisk`.`objid` AS `objectId`,`inventorydisk`.`objid` AS `id`,`inventorydisk`.`name` AS `name`,`ocum`.`wafldisk`.`healthStatus` AS `healthStatus`,`inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`inventorynode`.`objid` AS `ownerNodeId`,`inventorynode`.`name` AS `ownerNodeName`,`inventorynode`.`clusterId` AS `ownerNodeClusterId`,`ocum`.`clusternode`.`healthStatus` AS `ownerNodeHealthStatus`,`ocum`.`wafldisk`.`raidState` AS `raidState`,`inventorydisk`.`containerTypeRaw` AS `containerType`,`inventorydisk`.`raidPositionRaw` AS `raidType`,`inventorydisk`.`usedBytes` AS `usedBytes`,`inventorydisk`.`totalBytes` AS `totalBytes`,`inventorydisk`.`interfaceTypeRaw` AS `diskType`,`inventorydisk`.`percentSparesConsumed` AS `wearLevelPercent`,`inventorydisk`.`percentRatedLifeUsed` AS `percentRatedLifeUsed`,coalesce(`inventorydisk`.`effectiveInterfaceTypeRaw`,`ocum`.`wafldisk`.`lastKnownEffectiveInterfaceTypeRaw`) AS `effectiveType`,`inventorydisk`.`firmwareRevision` AS `firmwareRevision`,`inventorydisk`.`rpm` AS `rpm`,`inventorydisk`.`vendor` AS `vendorName`,`inventorydisk`.`model` AS `model`,`inventorydisk`.`shelf` AS `shelf`,`inventorydisk`.`shelfBay` AS `bay`,`inventoryraidgroup`.`name` AS `raidGroupName`,coalesce(`inventorydisk`.`isLocalAttach`,1) AS `isLocalAttach`,`inventorystoragepool`.`name` AS `storagePoolName`,`inventorystoragepool`.`objid` AS `storagePoolId`,if(`inventorydisk`.`storagePoolId`,0,NULL) AS `storagePoolHealthStatus`,(case when (lower(`inventorydisk`.`containerTypeRaw`) = 'broken') then `inventoryaggregate`.`objid` else NULL end) AS `impactedAggregateId`,(case when (lower(`inventorydisk`.`containerTypeRaw`) = 'broken') then `inventoryaggregate`.`name` else NULL end) AS `impactedAggregateName`,(case when (lower(`inventorydisk`.`containerTypeRaw`) = 'broken') then `ocum`.`aggregate`.`healthStatus` else NULL end) AS `impactedAggregateHealthStatus`,(case when (lower(`inventorydisk`.`containerTypeRaw`) = 'broken') then `daraggrcountview`.`aggrCount` else NULL end) AS `impactedAggregatesCount` from ((((((((((`netapp_model_view`.`disk` `inventorydisk` straight_join `ocum`.`wafldisk` on((`ocum`.`wafldisk`.`id` = `inventorydisk`.`objid`))) straight_join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventorydisk`.`clusterId`))) straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) left join `netapp_model_view`.`node` `inventorynode` on((`inventorynode`.`objid` = `inventorydisk`.`ownerNodeId`))) left join `ocum`.`clusternode` on((`ocum`.`clusternode`.`id` = `inventorynode`.`objid`))) left join `netapp_model_view`.`raid_group` `inventoryraidgroup` on((`inventoryraidgroup`.`objid` = `ocum`.`wafldisk`.`lastKnownRaidGroupId`))) left join `netapp_model_view`.`aggregate` `inventoryaggregate` on((`inventoryaggregate`.`objid` = `inventoryraidgroup`.`aggregateId`))) left join `ocum`.`diskaggregaterelationshipaggrcountview` `daraggrcountview` on((`daraggrcountview`.`diskId` = `inventorydisk`.`objid`))) left join `ocum`.`aggregate` on((`ocum`.`aggregate`.`id` = `inventoryaggregate`.`objid`))) left join `netapp_model_view`.`storage_pool` `inventorystoragepool` on((`inventorystoragepool`.`objid` = `inventorydisk`.`storagePoolId`))) where (`inventorydisk`.`containerTypeRaw` <> 'mediator')
 
Possibly Referenced Tables/Views: