View netapp_model_view.portset_to_port | Generated by SchemaSpy |
View Definition:
select `p`.`objid` AS `objid`,`ps`.`objid` AS `portsetId`,`ps`.`uuid` AS `portsetUUID`,`ps`.`clusterId` AS `clusterId`,`ps`.`vserverId` AS `vserverId`,`p`.`name` AS `portName`,`p`.`fcpLifId` AS `fcpLifId`,`p`.`iSCSIPortalGroupId` AS `iSCSIPortalGroupId`,`p`.`createtime` AS `createTime`,`p`.`updatetime` AS `updateTime` from (`netapp_model`.`portset` `ps` join `netapp_model`.`portset_port` `p` on((`ps`.`objid` = `p`.`portsetId`))) where (`p`.`objState` = 'LIVE')