View ocum.clusternodelivelistdtoview 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
healthStatus int 10
downTimestamp timestamp 19  √  null
clusterName varchar 255 Textual name
clusterHealthStatus int 10
haState varchar 14  √ 
haStateErrorReason text 65535  √  null
haStatus varchar 21  √ 
rawBytesSpare decimal 65  √  null
rawBytesDedicatedSpare decimal 41  √  null
rawBytesSharedDataSpare decimal 42  √  null
rawBytesSharedCacheSpare decimal 41  √  null
isSfoPairInterconnectUp int 10  √  null
clusterId bigint 19
clusterFqdn varchar 255  √  null
location varchar 255  √  null Location of the node.
aggrBytesUsed bigint 19  √  null DERIVED. Sum of bytes used (including snapshot) on all aggregates in the Node.
aggrBytesTotal bigint 19  √  null DERIVED. Sum of bytes total (including snapshot) on all aggregates in the Node.
rawBytesTotal bigint 19  √  null DERIVED.Sum of all disks size total
rawBytesUsed bigint 19  √  null DERIVED.Sum of all disks size used
id bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
haPairName varchar 255  √  null
name varchar 255 Textual name
isUp bit 0  √  null The RDB health of the node. True means the node is in quorum. ZAPI: system-node-get-iter is-node-healthy
model varchar 255  √  null Hardware model of this node.
isAllFlashOptimized bit 0  √  null Is this node configured to only support SSD drives. If true, no HDDs are allowed on this node.
shortOSVersion varchar 1024  √  null
serialNumber varchar 255  √  null Serial number
firmwareVersion varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
contact varchar 255  √  null The owner of the Node. ZAPI: system-node-get-iter node-owner
ethernetPortCount bigint 19  √  null
fcPortCount bigint 19  √  null
fcoePortCount bigint 19  √  null
diskCount bigint 19  √  null
diskShelveCount bigint 19  √  null
svmCount bigint 19  √  null
flashCardCount bigint 19  √  null
flashCardSize decimal 44  √  null
version varchar 255  √  null Version of the cluster
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

Analyzed at Tue Apr 23 05:29 EDT 2019

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`)))
 
Possibly Referenced Tables/Views: