View ocum.portsetnamesperlogicalinterfacedtoview 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
lifId bigint 19 Locally unique object identifier. ZAPIs: net-interface-get-iter.net-interface-info
portSetNames text 65535  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorylif`.`objid` AS `lifId`,group_concat(`inventoryportset`.`name` separator ',') AS `portSetNames` from ((`netapp_model_view`.`lif` `inventorylif` left join `netapp_model_view`.`portset_to_port` `inventoryportsetport` on(((`inventoryportsetport`.`portName` = `inventorylif`.`name`) and (`inventoryportsetport`.`vserverId` = `inventorylif`.`vserverId`)))) left join `netapp_model_view`.`portset` `inventoryportset` on((`inventoryportset`.`objid` = `inventoryportsetport`.`portsetId`))) group by `inventorylif`.`objid`