View ocum.lifcountperigrouplistdtoview Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
igroupId bigint 19 Locally unique object identifier. ZAPIs: igroup-get-iter.initiator-group-info
LIFMappingCount bigint 19 0
portSetName varchar 255 Textual name

Analyzed at Tue Apr 23 05:29 EDT 2019

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`