View ocum.disklivelistdtoview | Generated by SchemaSpy |
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: