View ocum.portlivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventoryport`.`objid` AS `objectId`,`inventoryport`.`objid` AS `id`,`inventoryport`.`name` AS `name`,`ocum`.`networkport`.`healthStatus` AS `healthStatus`,`inventoryport`.`linkStatusRaw` AS `state`,`inventorynode`.`objid` AS `nodeId`,`inventorynode`.`name` AS `nodeName`,`ocum`.`clusternode`.`healthStatus` AS `nodeHealthStatus`,'ethernet' AS `portType`,`inventoryport`.`roleRaw` AS `role`,((select count(`inventorylif`.`objid`) from `netapp_model_view`.`network_lif` `inventorylif` where ((`inventorylif`.`homePortId` = `inventoryport`.`objid`) and (`inventorylif`.`roleRaw` <> 'data'))) + (select count(`inventorylif`.`objid`) from ((`netapp_model_view`.`network_lif` `inventorylif` straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventorylif`.`vserverId` = `inventoryvserver`.`objid`))) straight_join `ocum`.`vserver` on((`inventoryvserver`.`objid` = `ocum`.`vserver`.`id`))) where ((`inventorylif`.`homePortId` = `inventoryport`.`objid`) and (`inventorylif`.`roleRaw` = 'data')))) AS `lifCount` from (((`netapp_model_view`.`network_port` `inventoryport` straight_join `ocum`.`networkport` on((`ocum`.`networkport`.`id` = `inventoryport`.`objid`))) left join `netapp_model_view`.`node` `inventorynode` on((`inventorynode`.`objid` = `inventoryport`.`nodeId`))) left join `ocum`.`clusternode` on((`ocum`.`clusternode`.`id` = `inventorynode`.`objid`))) union select `inventoryfcport`.`objid` AS `objectId`,`inventoryfcport`.`objid` AS `id`,`inventoryfcport`.`portName` AS `name`,`ocum`.`fcptarget`.`healthStatus` AS `healthStatus`,(case when (lower(`inventoryfcport`.`stateRaw`) = 'online') then 'up' else 'down' end) AS `state`,`inventorynode`.`objid` AS `nodeId`,`inventorynode`.`name` AS `nodeName`,`ocum`.`clusternode`.`healthStatus` AS `nodeHealthStatus`,(case when (lower(`inventoryfcport`.`physicalProtocolRaw`) = 'ethernet') then 'FCoE' else `inventoryfcport`.`physicalProtocolRaw` end) AS `portType`,'data' AS `role`,((select count(`inventoryfcplif`.`objid`) from `netapp_model_view`.`fcp_lif` `inventoryfcplif` where ((`inventoryfcplif`.`homePortId` = `inventoryfcport`.`objid`) and (`inventoryfcplif`.`roleRaw` <> 'data'))) + (select count(`inventoryfcplif`.`objid`) from ((`netapp_model_view`.`fcp_lif` `inventoryfcplif` straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryfcplif`.`vserverId` = `inventoryvserver`.`objid`))) straight_join `ocum`.`vserver` on((`inventoryvserver`.`objid` = `ocum`.`vserver`.`id`))) where ((`inventoryfcplif`.`homePortId` = `inventoryfcport`.`objid`) and (`inventoryfcplif`.`roleRaw` = 'data')))) AS `lifCount` from (((`netapp_model_view`.`fcp_port` `inventoryfcport` straight_join `ocum`.`fcptarget` on((`ocum`.`fcptarget`.`id` = `inventoryfcport`.`objid`))) left join `netapp_model_view`.`node` `inventorynode` on((`inventorynode`.`objid` = `inventoryfcport`.`nodeId`))) left join `ocum`.`clusternode` on((`ocum`.`clusternode`.`id` = `inventorynode`.`objid`)))
Possibly Referenced Tables/Views: