View ocum_report_birt.clusterinventoryreport 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: cluster-identity-get.cluster-identity-info
name varchar 255 Textual name
nodeId 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
nodeName varchar 255 Textual name
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.
ontapVersion varchar 1024  √  null
serialNumber varchar 255  √  null Serial number
cpuFirmwareRelease varchar 255  √  null Firmware release number. ZAPI: system-node-get-iter cpu-firware-relsease
ethernetPortCount bigint 19  √  null
fcpPortCount bigint 19  √  null
fcoePortCount bigint 19  √  null
diskCount bigint 19  √  null
diskshelveCount bigint 19  √  null
vserverCount bigint 19  √  null
flashCardCount bigint 19  √  null
flashCardSize decimal 32  √  null

Analyzed at Tue Apr 23 04:53 EDT 2019

View Definition:
select `cluster`.`objid` AS `objid`,`cluster`.`name` AS `name`,`node`.`objid` AS `nodeId`,`hapairview`.`haPairName` AS `haPairName`,`node`.`name` AS `nodeName`,`node`.`model` AS `model`,`node`.`isAllFlashOptimized` AS `isAllFlashOptimized`,`ocum`.`na_shortOSVersion`(`node`.`version`) AS `ontapVersion`,`node`.`serialNumber` AS `serialNumber`,`node`.`cpuFirmwareRelease` AS `cpuFirmwareRelease`,(select count(0) from `netapp_model_view`.`network_port` where (`network_port`.`nodeId` = `node`.`objid`)) AS `ethernetPortCount`,(select count(0) from `netapp_model_view`.`fcp_port` where ((`fcp_port`.`nodeId` = `node`.`objid`) and (`fcp_port`.`physicalProtocol` = 'FIBRE_CHANNEL'))) AS `fcpPortCount`,(select count(0) from `netapp_model_view`.`fcp_port` where ((`fcp_port`.`nodeId` = `node`.`objid`) and (`fcp_port`.`physicalProtocol` = 'ETHERNET'))) AS `fcoePortCount`,(select count(0) from `netapp_model_view`.`disk` where (`disk`.`ownerNodeId` = `node`.`objid`)) AS `diskCount`,(select count(0) from `netapp_model_view`.`storage_shelf` where (`storage_shelf`.`nodeId` in (`node`.`objid`,`node`.`partnerNodeId`))) AS `diskshelveCount`,(select count(0) from `netapp_model_view`.`vserver` where ((`vserver`.`clusterId` = `cluster`.`objid`) and (`vserver`.`typeRaw` = 'data'))) AS `vserverCount`,(select count(0) from `netapp_model_view`.`flash_device` where (`flash_device`.`nodeId` = `node`.`objid`)) AS `flashCardCount`,(select sum(`flash_device`.`capacityGB`) from `netapp_model_view`.`flash_device` where (`flash_device`.`nodeId` = `node`.`objid`)) AS `flashCardSize` from ((`netapp_model_view`.`cluster` join `netapp_model_view`.`node` on((`node`.`clusterId` = `cluster`.`objid`))) left join `ocum_report_birt`.`hapairview` on(((`node`.`objid` in (`hapairview`.`node1Id`,`hapairview`.`node2Id`)) and (`node`.`partnerNodeId` in (`hapairview`.`node1Id`,`hapairview`.`node2Id`)))))
 
Possibly Referenced Tables/Views: