View ocum.logicalinterfacelivelistdtoview | Generated by SchemaSpy |
View Definition:
select `inventorylif`.`objid` AS `id`,`inventorylif`.`name` AS `name`,`ocum`.`logicalinterface`.`healthStatus` AS `healthStatus`,`inventorylif`.`operationalStatusRaw` AS `status`,`inventorylif`.`administrativeStatusRaw` AS `adminStatus`,`inventorylif`.`dataProtocols` AS `dataProtocols`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `inventorynetworklif`.`address` when (`inventorylif`.`lifType` = 'FCP_LIF') then `inventoryfcplif`.`portName` else `inventorynvmffclif`.`portName` end) AS `address`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `inventoryhomenetworkport`.`objid` when (`inventorylif`.`lifType` = 'FCP_LIF') then `inventoryhomefcpport`.`objid` else `inventoryhomenvmffcport`.`objid` end) AS `homePortId`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then concat(`inventoryhomenode`.`name`,':',`inventoryhomenetworkport`.`name`) when (`inventorylif`.`lifType` = 'FCP_LIF') then concat(`inventoryhomenode`.`name`,':',`inventoryhomefcpport`.`adapter`) else concat(`inventoryhomenode`.`name`,':',`inventoryhomenvmffcport`.`adapter`) end) AS `homePortName`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `homenetworkport`.`healthStatus` when (`inventorylif`.`lifType` = 'FCP_LIF') then `homefcpport`.`healthStatus` else `homenvmffcport`.`healthStatus` end) AS `homePortHealthStatus`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `inventorycurrentnetworkport`.`objid` when (`inventorylif`.`lifType` = 'FCP_LIF') then `inventorycurrentfcpport`.`objid` else `inventorycurrentnvmffcport`.`objid` end) AS `currentPortId`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then concat(`inventorycurrentnode`.`name`,':',`inventorycurrentnetworkport`.`name`) when (`inventorylif`.`lifType` = 'FCP_LIF') then concat(`inventorycurrentnode`.`name`,':',`inventorycurrentfcpport`.`adapter`) else concat(`inventorycurrentnode`.`name`,':',`inventorycurrentnvmffcport`.`adapter`) end) AS `currentPortName`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `currentnetworkport`.`healthStatus` when (`inventorylif`.`lifType` = 'FCP_LIF') then `currentfcpport`.`healthStatus` else `currentnvmffcport`.`healthStatus` end) AS `currentPortHealthStatus`,`inventorylif`.`roleRaw` AS `role`,`inventorynetworkfailovergroup`.`name` AS `failoverGroup`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `inventorynetworklif`.`failoverPolicyRaw` else NULL end) AS `failoverPolicy`,`ocum`.`logicalinterface`.`owner_id` AS `ownerId`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then (case when (`ocum`.`logicalinterface`.`owner_type` = 'inventory.ontap.fas.Vserver') then `inventoryvserver`.`name` when (`ocum`.`logicalinterface`.`owner_type` = 'inventory.ontap.fas.Cluster') then `inventorycluster`.`name` when (`ocum`.`logicalinterface`.`owner_type` = 'inventory.ontap.fas.ClusterNode') then `inventorycurrentnode`.`name` else NULL end) else `inventoryvserver`.`name` end) AS `ownerName`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then (case when (`ocum`.`logicalinterface`.`owner_type` = 'inventory.ontap.fas.Vserver') then `ocum`.`vserver`.`healthStatus` when (`ocum`.`logicalinterface`.`owner_type` = 'inventory.ontap.fas.Cluster') then `ocum`.`cluster`.`healthStatus` when (`ocum`.`logicalinterface`.`owner_type` = 'inventory.ontap.fas.ClusterNode') then `currentclusternode`.`healthStatus` else NULL end) else `ocum`.`vserver`.`healthStatus` end) AS `ownerHealthStatus`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `inventorynetworklif`.`routingGroupId` else NULL end) AS `routingGroupId`,(case when (`inventorylif`.`lifType` = 'NETWORK_LIF') then `inventoryroutinggroup`.`routingGroupName` else NULL end) AS `routingGroupName`,`inventorylif`.`clusterId` AS `clusterId`,`inventorylif`.`name` AS `clusterName`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`portsetnamesperlogicalinterfacedtoview`.`portSetNames` AS `portsetNames` from (((((((((((((((((((((((((((`netapp_model_view`.`lif` `inventorylif` left join `ocum`.`logicalinterface` on((`ocum`.`logicalinterface`.`id` = `inventorylif`.`objid`))) left join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventorylif`.`clusterId`))) left join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) left join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryvserver`.`objid` = `inventorylif`.`vserverId`))) left join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`))) left join `netapp_model_view`.`network_lif` `inventorynetworklif` on((`inventorynetworklif`.`objid` = `inventorylif`.`objid`))) left join `netapp_model_view`.`fcp_lif` `inventoryfcplif` on((`inventoryfcplif`.`objid` = `inventorylif`.`objid`))) left join `netapp_model_view`.`nvmf_fc_lif` `inventorynvmffclif` on((`inventorynvmffclif`.`objid` = `inventorylif`.`objid`))) left join `netapp_model_view`.`node` `inventorycurrentnode` on((`inventorycurrentnode`.`objid` = `inventorylif`.`currentNodeId`))) left join `ocum`.`clusternode` `currentclusternode` on((`currentclusternode`.`id` = `inventorycurrentnode`.`objid`))) left join `netapp_model_view`.`node` `inventoryhomenode` on((`inventoryhomenode`.`objid` = `inventorylif`.`homeNodeId`))) left join `ocum`.`clusternode` `homeclusternode` on((`homeclusternode`.`id` = `inventoryhomenode`.`objid`))) left join `netapp_model_view`.`network_port` `inventoryhomenetworkport` on((`inventoryhomenetworkport`.`objid` = `inventorynetworklif`.`homePortId`))) left join `ocum`.`networkport` `homenetworkport` on((`homenetworkport`.`id` = `inventoryhomenetworkport`.`objid`))) left join `netapp_model_view`.`network_port` `inventorycurrentnetworkport` on((`inventorycurrentnetworkport`.`objid` = `inventorynetworklif`.`currentPortId`))) left join `ocum`.`networkport` `currentnetworkport` on((`currentnetworkport`.`id` = `inventorycurrentnetworkport`.`objid`))) left join `netapp_model_view`.`fcp_port` `inventoryhomefcpport` on((`inventoryhomefcpport`.`objid` = `inventoryfcplif`.`homePortId`))) left join `ocum`.`fcptarget` `homefcpport` on((`homefcpport`.`id` = `inventoryhomefcpport`.`objid`))) left join `netapp_model_view`.`fcp_port` `inventoryhomenvmffcport` on((`inventoryhomenvmffcport`.`objid` = `inventorynvmffclif`.`homePortId`))) left join `ocum`.`fcptarget` `homenvmffcport` on((`homenvmffcport`.`id` = `inventoryhomenvmffcport`.`objid`))) left join `netapp_model_view`.`network_failover_group` `inventorynetworkfailovergroup` on((`inventorynetworkfailovergroup`.`objid` = `inventorylif`.`failoverGroupId`))) left join `netapp_model_view`.`fcp_port` `inventorycurrentfcpport` on((`inventorycurrentfcpport`.`objid` = `inventoryfcplif`.`currentPortId`))) left join `ocum`.`fcptarget` `currentfcpport` on((`currentfcpport`.`id` = `inventorycurrentfcpport`.`objid`))) left join `netapp_model_view`.`fcp_port` `inventorycurrentnvmffcport` on((`inventorycurrentnvmffcport`.`objid` = `inventorynvmffclif`.`currentPortId`))) left join `ocum`.`fcptarget` `currentnvmffcport` on((`currentnvmffcport`.`id` = `inventorycurrentnvmffcport`.`objid`))) left join `netapp_model_view`.`routing_group` `inventoryroutinggroup` on((`inventoryroutinggroup`.`objid` = `inventorynetworklif`.`routingGroupId`))) left join `ocum`.`portsetnamesperlogicalinterfacedtoview` on((((`inventorylif`.`dataProtocols` = 'iscsi') or (`inventorylif`.`dataProtocols` = 'fcp')) and (`portsetnamesperlogicalinterfacedtoview`.`lifId` = `ocum`.`logicalinterface`.`id`))))
Possibly Referenced Tables/Views: