View ocum.clusternodelivelistdtoview | Generated by SchemaSpy |
View Definition:
select `ocum`.`clusternode`.`healthStatus` AS `healthStatus`,`clusternodedowneventsview`.`downTimestamp` AS `downTimestamp`,`inventorycluster`.`name` AS `clusterName`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`clusternodehighavailabilitystateview`.`haState` AS `haState`,`clusternodehighavailabilitystateview`.`haStateErrorReason` AS `haStateErrorReason`,`clusternodehighavailabilitystateview`.`haStatus` AS `haStatus`,`clusternoderawsparecapacityview`.`rawBytesSpare` AS `rawBytesSpare`,`clusternodededicatesparecapacityview`.`rawBytesDedicatedSpare` AS `rawBytesDedicatedSpare`,`clusternoderawspareshareddatacapacityview`.`rawBytesSharedDataSpare` AS `rawBytesSharedDataSpare`,`clusternoderawsparesharedcachecapacityview`.`rawBytesSharedCacheSpare` AS `rawBytesSharedCacheSpare`,`clusternodehighavailabilitystateview`.`isSfoPairInterconnectUp` AS `isSfoPairInterconnectUp`,`inventoryclusternode`.`clusterId` AS `clusterId`,`ocumschemacluster`.`fqdn` AS `clusterFqdn`,`inventoryclusternode`.`location` AS `location`,`inventoryclusternode`.`aggregateBytesUsed` AS `aggrBytesUsed`,`inventoryclusternode`.`aggregateBytesTotal` AS `aggrBytesTotal`,`inventoryclusternode`.`rawDiskBytesTotal` AS `rawBytesTotal`,`inventoryclusternode`.`rawDiskBytesUsed` AS `rawBytesUsed`,`inventoryclusternode`.`objid` AS `id`,`hapairview`.`haPairName` AS `haPairName`,`inventoryclusternode`.`name` AS `name`,`inventoryclusternode`.`isNodeHealthy` AS `isUp`,`inventoryclusternode`.`model` AS `model`,`inventoryclusternode`.`isAllFlashOptimized` AS `isAllFlashOptimized`,`ocum`.`na_shortOSVersion`(`inventoryclusternode`.`version`) AS `shortOSVersion`,`inventoryclusternode`.`serialNumber` AS `serialNumber`,`inventoryclusternode`.`cpuFirmwareRelease` AS `firmwareVersion`,`inventoryclusternode`.`owner` AS `contact`,(select count(0) from `netapp_model_view`.`network_port` where (`network_port`.`nodeId` = `inventoryclusternode`.`objid`)) AS `ethernetPortCount`,(select count(0) from `netapp_model_view`.`fcp_port` where ((`fcp_port`.`nodeId` = `inventoryclusternode`.`objid`) and (`fcp_port`.`physicalProtocolRaw` = 'fibre_channel'))) AS `fcPortCount`,(select count(0) from `netapp_model_view`.`fcp_port` where ((`fcp_port`.`nodeId` = `inventoryclusternode`.`objid`) and (`fcp_port`.`physicalProtocolRaw` = 'ethernet'))) AS `fcoePortCount`,(select count(0) from `netapp_model_view`.`disk` where (`disk`.`ownerNodeId` = `inventoryclusternode`.`objid`)) AS `diskCount`,(select count(0) from `netapp_model_view`.`storage_shelf` where (`storage_shelf`.`nodeId` in (`inventoryclusternode`.`objid`,`inventoryclusternode`.`partnerNodeId`))) AS `diskShelveCount`,(select count(0) from `netapp_model_view`.`vserver` where ((`vserver`.`clusterId` = `inventorycluster`.`objid`) and (`vserver`.`typeRaw` = 'data'))) AS `svmCount`,(select count(0) from `netapp_model_view`.`flash_device` where (`flash_device`.`nodeId` = `inventoryclusternode`.`objid`)) AS `flashCardCount`,(select (((sum(`flash_device`.`capacityGB`) * 1024) * 1024) * 1024) from `netapp_model_view`.`flash_device` where (`flash_device`.`nodeId` = `inventoryclusternode`.`objid`)) AS `flashCardSize`,`inventoryclusternode`.`version` AS `version`,`inventoryclusternode`.`versionGeneration` AS `versionGeneration`,`inventoryclusternode`.`versionMajor` AS `versionMajor`,`inventoryclusternode`.`versionMinor` AS `versionMinor` from (((((((((((`netapp_model_view`.`node` `inventoryclusternode` join `netapp_model_view`.`cluster` `inventorycluster` on((`inventoryclusternode`.`clusterId` = `inventorycluster`.`objid`))) straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) join `ocum`.`clusternoderawsparecapacityview` on((`inventoryclusternode`.`objid` = `clusternoderawsparecapacityview`.`node_id`))) join `ocum`.`clusternode` on((`inventoryclusternode`.`objid` = `ocum`.`clusternode`.`id`))) left join `ocum`.`clusternodededicatesparecapacityview` on((`inventoryclusternode`.`objid` = `clusternodededicatesparecapacityview`.`node_id`))) left join `ocum`.`clusternoderawsparesharedcachecapacityview` on((`inventoryclusternode`.`objid` = `clusternoderawsparesharedcachecapacityview`.`node_id`))) left join `ocum`.`clusternoderawspareshareddatacapacityview` on((`inventoryclusternode`.`objid` = `clusternoderawspareshareddatacapacityview`.`node_id`))) left join `ocum`.`clusternodehighavailabilitystateview` on((`inventoryclusternode`.`objid` = `clusternodehighavailabilitystateview`.`node_id`))) left join `ocum`.`hapairview` on(((`inventoryclusternode`.`objid` in (`hapairview`.`node1Id`,`hapairview`.`node2Id`)) and (`inventoryclusternode`.`partnerNodeId` in (`hapairview`.`node1Id`,`hapairview`.`node2Id`))))) left join `ocum`.`clusternodedowneventsview` on((`inventoryclusternode`.`objid` = `clusternodedowneventsview`.`node_id`))) join `ocum`.`cluster` `ocumschemacluster` on((`inventoryclusternode`.`clusterId` = `ocumschemacluster`.`cluster_id`)))