View ocum_report.clusternode | Generated by SchemaSpy |
View Definition:
select `node`.`objid` AS `id`,`node`.`uuid` AS `uuid`,`node`.`name` AS `name`,`node`.`clusterId` AS `clusterId`,`node`.`partnerNodeId` AS `partnerNodeId`,`node`.`serialNumber` AS `serialNumber`,`node`.`version` AS `version`,`node`.`model` AS `model`,`node`.`uptime` AS `uptime`,`node`.`vendor` AS `vendor`,`node`.`location` AS `location`,`node`.`failoverState` AS `failoverState`,`node`.`cpuProcessorType` AS `cpuProcessorType`,`node`.`cpuProcessorId` AS `cpuProcessorId`,`node`.`numberOfProcessors` AS `numberOfProcessors`,`node`.`memorySizeMB` AS `memorySizeMB`,`node`.`productType` AS `productType`,`node`.`nvramId` AS `nvramId`,`node`.`cpuFirmwareRelease` AS `cpuFirmwareRelease`,`node`.`isOverTemperature` AS `isOverTemperature`,`node`.`failedFanCount` AS `failedFanCount`,`node`.`failedPowerSupplyCount` AS `failedPowerSupplyCount`,`node`.`nvramBatteryStatusRaw` AS `nvramBatteryStatus`,`node`.`rawDiskBytesTotal` AS `rawDiskBytesTotal`,`node`.`rawDiskBytesUsed` AS `rawDiskBytesUsed`,`node`.`aggregateBytesTotal` AS `aggregateBytesTotal`,`node`.`aggregateBytesUsed` AS `aggregateBytesUsed`,`node`.`isFailoverEnabled` AS `isFailoverEnabled`,`node`.`isTakeOverPossible` AS `isTakeOverPossible`,`node`.`partnerFirmwareState` AS `partnerFirmwareState`,`node`.`localFirmwareState` AS `localFirmwareState`,`node`.`isInterconnectUp` AS `isInterconnectUp`,`node`.`interconnectLinks` AS `interconnectLinks`,`node`.`interconnectType` AS `interconnectType`,`node`.`versionGeneration` AS `versionGeneration`,`node`.`versionMajor` AS `versionMajor`,`node`.`versionMinor` AS `versionMinor`,`node`.`owner` AS `owner`,`node`.`isNodeHealthy` AS `isNodeHealthy`,`node`.`isEpsilonNode` AS `isEpsilonNode`,`node`.`envFailedFanMessage` AS `envFailedFanMessage`,`node`.`envFailedPowerSupplyMessage` AS `envFailedPowerSupplyMessage`,`node`.`giveBackState` AS `giveBackState`,`node`.`currentMode` AS `currentMode`,`node`.`takeoverByPartnerNotPossibleReason` AS `takeoverByPartnerNotPossibleReason`,`node`.`takeoverOfPartnerNotPossibleReason` AS `takeoverOfPartnerNotPossibleReason`,`node`.`takeoverFailureReason` AS `takeoverFailureReason`,`node`.`isAllFlashOptimized` AS `isAllFlashOptimized` from `netapp_model_view`.`node`