View netapp_model_view.fcp_lif | Generated by SchemaSpy |
View Definition:
select `fl`.`objid` AS `objid`,`fl`.`uuid` AS `uuid`,`fl`.`resourceKey` AS `resourceKey`,`l`.`name` AS `name`,`fl`.`clusterId` AS `clusterId`,`fl`.`vserverId` AS `vserverId`,`l`.`currentNodeId` AS `currentNodeId`,`fl`.`currentPortId` AS `currentPortId`,`l`.`homeNodeId` AS `homeNodeId`,`fl`.`homePortId` AS `homePortId`,`l`.`isAutoRevert` AS `isAutoRevert`,`l`.`isHome` AS `isHome`,`fl`.`nodeName` AS `nodeName`,`fl`.`portName` AS `portName`,`l`.`operationalStatus` AS `operationalStatus`,`l`.`operationalStatusRaw` AS `operationalStatusRaw`,`l`.`administrativeStatus` AS `administrativeStatus`,`l`.`administrativeStatusRaw` AS `administrativeStatusRaw`,`l`.`role` AS `role`,`l`.`roleRaw` AS `roleRaw`,`l`.`dataProtocols` AS `dataProtocols`,`l`.`failoverGroupId` AS `failoverGroupId`,`fl`.`createtime` AS `createTime`,`fl`.`updatetime` AS `updateTime` from (`netapp_model`.`fcp_lif` `fl` join `netapp_model`.`lif` `l` on((`fl`.`objid` = `l`.`objid`))) where (`fl`.`objState` = 'LIVE')