View ocum.lifcountperigrouplistdtoview | Generated by SchemaSpy |
View Definition:
select `inventoryporsettoigroup`.`igroupId` AS `igroupId`,count(`inventoryporsetport`.`objid`) AS `LIFMappingCount`,`inventoryportset`.`name` AS `portSetName` from ((`netapp_model_view`.`portset_to_igroup` `inventoryporsettoigroup` left join `netapp_model_view`.`portset_to_port` `inventoryporsetport` on((`inventoryporsettoigroup`.`portsetId` = `inventoryporsetport`.`portsetId`))) straight_join `netapp_model_view`.`portset` `inventoryportset` on((`inventoryportset`.`objid` = `inventoryporsetport`.`portsetId`))) group by `inventoryporsettoigroup`.`igroupId`