View netapp_model_view.node_full | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`node`.`objid` AS `objid`,`netapp_model`.`node`.`uuid` AS `uuid`,`netapp_model`.`node`.`resourceKey` AS `resourceKey`,`netapp_model`.`node`.`name` AS `name`,`netapp_model`.`node`.`clusterId` AS `clusterId`,`netapp_model`.`node`.`partnerNodeId` AS `partnerNodeId`,`netapp_model`.`node`.`mtDrPartnerNodeUUID` AS `mtDrPartnerNodeUUID`,`netapp_model`.`node`.`mtDrPartnerNodeId` AS `mtDrPartnerNodeId`,`netapp_model`.`node`.`mtDrOperationState` AS `mtDrOperationState`,`netapp_model`.`node`.`mtDrOperationStateRaw` AS `mtDrOperationStateRaw`,`netapp_model`.`node`.`mtAutomaticUso` AS `mtAutomaticUso`,`netapp_model`.`node`.`serialNumber` AS `serialNumber`,`netapp_model`.`node`.`nodeStorageConfiguration` AS `nodeStorageConfiguration`,`netapp_model`.`node`.`nodeStorageConfigurationRaw` AS `nodeStorageConfigurationRaw`,`netapp_model`.`node`.`version` AS `version`,`netapp_model`.`node`.`model` AS `model`,`netapp_model`.`node`.`uptime` AS `uptime`,`netapp_model`.`node`.`vendor` AS `vendor`,`netapp_model`.`node`.`location` AS `location`,`netapp_model`.`node`.`failoverState` AS `failoverState`,`netapp_model`.`node`.`cpuProcessorType` AS `cpuProcessorType`,`netapp_model`.`node`.`cpuProcessorId` AS `cpuProcessorId`,`netapp_model`.`node`.`numberOfProcessors` AS `numberOfProcessors`,`netapp_model`.`node`.`memorySizeMB` AS `memorySizeMB`,`netapp_model`.`node`.`productType` AS `productType`,`netapp_model`.`node`.`boardType` AS `boardType`,`netapp_model`.`node`.`nvramId` AS `nvramId`,`netapp_model`.`node`.`cpuFirmwareRelease` AS `cpuFirmwareRelease`,`netapp_model`.`node`.`isOverTemperature` AS `isOverTemperature`,`netapp_model`.`node`.`failedFanCount` AS `failedFanCount`,`netapp_model`.`node`.`failedPowerSupplyCount` AS `failedPowerSupplyCount`,`netapp_model`.`node`.`nvramBatteryStatus` AS `nvramBatteryStatus`,`netapp_model`.`node`.`nvramBatteryStatusRaw` AS `nvramBatteryStatusRaw`,`netapp_model`.`node`.`rawDiskBytesTotal` AS `rawDiskBytesTotal`,`netapp_model`.`node`.`rawDiskBytesUsed` AS `rawDiskBytesUsed`,`netapp_model`.`node`.`aggregateBytesTotal` AS `aggregateBytesTotal`,`netapp_model`.`node`.`aggregateBytesUsed` AS `aggregateBytesUsed`,`netapp_model`.`node`.`isFailoverEnabled` AS `isFailoverEnabled`,`netapp_model`.`node`.`isTakeOverPossible` AS `isTakeOverPossible`,`netapp_model`.`node`.`partnerFirmwareState` AS `partnerFirmwareState`,`netapp_model`.`node`.`localFirmwareState` AS `localFirmwareState`,`netapp_model`.`node`.`isInterconnectUp` AS `isInterconnectUp`,`netapp_model`.`node`.`interconnectLinks` AS `interconnectLinks`,`netapp_model`.`node`.`interconnectType` AS `interconnectType`,`netapp_model`.`node`.`versionGeneration` AS `versionGeneration`,`netapp_model`.`node`.`versionMajor` AS `versionMajor`,`netapp_model`.`node`.`versionMinor` AS `versionMinor`,`netapp_model`.`node`.`owner` AS `owner`,`netapp_model`.`node`.`isNodeHealthy` AS `isNodeHealthy`,`netapp_model`.`node`.`isEpsilonNode` AS `isEpsilonNode`,`netapp_model`.`node`.`isAllFlashOptimized` AS `isAllFlashOptimized`,`netapp_model`.`node`.`envFailedFanMessage` AS `envFailedFanMessage`,`netapp_model`.`node`.`envFailedPowerSupplyMessage` AS `envFailedPowerSupplyMessage`,`netapp_model`.`node`.`giveBackState` AS `giveBackState`,`netapp_model`.`node`.`currentMode` AS `currentMode`,`netapp_model`.`node`.`takeoverByPartnerNotPossibleReason` AS `takeoverByPartnerNotPossibleReason`,`netapp_model`.`node`.`takeoverOfPartnerNotPossibleReason` AS `takeoverOfPartnerNotPossibleReason`,`netapp_model`.`node`.`takeoverFailureReason` AS `takeoverFailureReason`,`netapp_model`.`node`.`createtime` AS `createTime`,`netapp_model`.`node`.`updatetime` AS `updateTime`,`netapp_model`.`node`.`objState` AS `objState` from `netapp_model`.`node`