View netapp_model_view.portset_to_igroup | Generated by SchemaSpy |
View Definition:
select `p2g`.`objid` AS `objid`,`ps`.`objid` AS `portsetId`,`ps`.`uuid` AS `portsetUUID`,`g`.`objid` AS `igroupId`,`g`.`uuid` AS `igroupUUID`,`ps`.`clusterId` AS `clusterId`,`ps`.`vserverId` AS `vserverId`,`g`.`createtime` AS `createTime`,`g`.`updatetime` AS `updateTime` from ((`netapp_model`.`portset` `ps` join `netapp_model`.`portset_to_igroup` `p2g` on((`ps`.`objid` = `p2g`.`portsetId`))) join `netapp_model`.`igroup` `g` on((`p2g`.`igroupId` = `g`.`objid`))) where (`p2g`.`objState` = 'LIVE')