View netapp_model_view.fcp_lif_derived | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`fcp_lif`.`objid` AS `objid`,`netapp_model`.`fcp_lif`.`uuid` AS `uuid`,`netapp_model`.`fcp_lif`.`resourceKey` AS `resourcekey`,`netapp_model`.`fcp_lif`.`clusterId` AS `clusterId`,`netapp_model`.`fcp_lif`.`vserverId` AS `vserverId`,`netapp_model`.`fcp_lif`.`currentPortId` AS `currentPortId`,`netapp_model`.`fcp_lif`.`homePortId` AS `homePortId`,`netapp_model`.`fcp_lif`.`nodeName` AS `nodeName`,`netapp_model`.`fcp_lif`.`portName` AS `portName`,`netapp_model`.`fcp_lif`.`createtime` AS `createTime`,`netapp_model`.`fcp_lif`.`updatetime` AS `updateTime` from `netapp_model`.`fcp_lif` where (`netapp_model`.`fcp_lif`.`objState` = 'LIVE')