View netapp_model_view.node 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
objid bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
uuid varchar 255 Globally unique ID of the node
resourceKey varchar 512
name varchar 255 Textual name
clusterId bigint 19
partnerNodeId bigint 19  √  null
mtDrPartnerNodeUUID varchar 45  √  null The partner node UUID on the MetroCluster
mtDrPartnerNodeId bigint 19  √  null
mtDrOperationState enum 22  √  null The operation state of partner node on metrocluster.
mtDrOperationStateRaw varchar 255  √  null The operation state of partner node on metrocluster. Raw enum value from ZAPI
mtAutomaticUso bit 0  √  null Flag whether automatic switchover is enabled
serialNumber varchar 255  √  null Serial number
nodeStorageConfiguration enum 14  √  null
nodeStorageConfigurationRaw varchar 255  √  null The storage configuration in the system raw value.
version varchar 255  √  null Version of the cluster
model varchar 255  √  null Hardware model of this node.
uptime bigint 19  √  null The uptime of this node, in seconds.
vendor varchar 255  √  null Hardware vendor of the node.
location varchar 255  √  null Location of the node.
failoverState varchar 255  √  null Failover state. See ZAPI documentation on cf-status for more information.
cpuProcessorType varchar 255  √  null Processor type (defined by CPU manufacturer).
cpuProcessorId varchar 255  √  null Processor ID (defined by CPU manufacturer).
numberOfProcessors int 10  √  null Number of processors on Node.
memorySizeMB bigint 19  √  null Size of system memory in MB.
productType varchar 255  √  null Will be set to "V-Series" to indicate a v-series system for NetApp filers. For IBM filers, "gateway" will used.
boardType varchar 100  √  null Type of system board in the node
nvramId varchar 255  √  null Vendor specific NVRAM ID of the node. ZAPI: system-node-get-iter node-nvram-id
cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
isOverTemperature bit 0  √  null An indication of whether the hardware is currently operating outside of its recommended temperature range. ZAPI: system-node-get-iter env-over-temperature
failedFanCount int 10  √  null Number of failed fans. ZAPI: system-node-get-iter env-failed-fan-count
failedPowerSupplyCount int 10  √  null Number of failed power supply units. ZAPI: system-node-get-iter env-failed-power-supply-count
nvramBatteryStatus enum 28  √  null NVRAM Battery Attributes. ZAPI: system-node-get-iter nvram-battery-status
nvramBatteryStatusRaw varchar 255  √  null
rawDiskBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
rawDiskBytesUsed bigint 19  √  null DERIVED.Sum of all disks size used
aggregateBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
aggregateBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
isFailoverEnabled bit 0  √  null True, if the storage failover facility is enabled, false otherwise. ZAPI: cf-status is-enabled
isTakeOverPossible bit 0  √  null True, if storage failover takeover is currently possible, false otherwise. ZAPI: cf-status takeover-possible
partnerFirmwareState varchar 255  √  null Partner firmware state as communicated by the partner through interconnect. ZAPI: cf-status partner-firmware-state
localFirmwareState varchar 255  √  null Local firmware state that will be communicated through interconnect to the partner. ZAPI: cf-status local-firmware-state
isInterconnectUp bit 0  √  null True, if high availability interconnect is up. ZAPI: cf-status is-interconnect-up
interconnectLinks varchar 255  √  null States of the individual interconnect links. ZAPI: cf-status interconnect-links
interconnectType varchar 255  √  null Type and Vendor of the interconnect. ZAPI: cf-status interconnect-type
versionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to this Node.
versionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to this Node
versionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to this Node
owner varchar 255  √  null The owner of the Node. ZAPI: system-node-get-iter node-owner
isNodeHealthy bit 0  √  null The RDB health of the node. True means the node is in quorum. ZAPI: system-node-get-iter is-node-healthy
isEpsilonNode bit 0  √  null You can designate a node as epsilon to add weight to its voting in a cluster with an even number of nodes. In a cluster, only one node can be designated as epsilon at any given time. A boolean value of true means the node is epsilon. Attributes: non-creatable, modifiable.
isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
envFailedFanMessage varchar 255  √  null Text message describing the current condition of chassis fans. This is useful only if env-failed-fan-count is not zero. ZAPI: system-node-get-iter.env-failed-fan-message
envFailedPowerSupplyMessage varchar 255  √  null Text message describing the state of any power supplies which are currently degraded. This is useful only if env-failed-power-supply-count is not zero. ZAPI: system-node-get-iter.env-failed-power-supply-message
giveBackState varchar 255  √  null Giveback state of the node. ZAPI: cf-status.giveback-state
currentMode varchar 255  √  null Current HA mode
takeoverByPartnerNotPossibleReason varchar 512  √  null If takeover by the partner is not possible, list of one or more reasons why. Translated to a comma separated, lexiographically sorted, list of reasons
takeoverOfPartnerNotPossibleReason varchar 512  √  null If is-enabled is false, list of one or more reasons why. Translated to a comma separated, lexiographically sorted, list of reasons
takeoverFailureReason varchar 255  √  null If is-enabled is false, list of one or more reasons why. If state == takeover_failed, this is the reason for the takeover failure
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

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` from `netapp_model`.`node` where (`netapp_model`.`node`.`objState` = 'LIVE')