View netapp_model_view.network_lif_derived 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
objid bigint 19 Locally unique object identifier. ZAPIs: net-interface-get-iter.net-interface-info
uuid varchar 255 Globally unique ID of this LIF. For ONTAP 8.2 and later ZAPI: net-interface-get-iter net-interface-info.lif-uuid. For ONTAP 8.1: Not available in ZAPI. Uses {VserverUUID}.{LIFName}
resourceKey varchar 512
clusterId bigint 19
vserverId bigint 19
currentPortId bigint 19  √  null
homePortId bigint 19  √  null
routingGroupId bigint 19  √  null
address varchar 255  √  null LIFs IP address. THis element is valid for all data prtocols except FCP
netmask varchar 255  √  null Specifies the LIFs netmask. This element is valid for all data protocols except FCP
netmaskLength int 10  √  null Specifies the number of bits in the netmask
dnsDomainName varchar 255  √  null Specifies the unique, fully qualified domain name of the DNS zone of this LIF
failoverPolicy enum 21  √  null Specifies the failover policy for the LIF
failoverPolicyRaw varchar 255  √  null
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`network_lif`.`objid` AS `objid`,`netapp_model`.`network_lif`.`uuid` AS `uuid`,`netapp_model`.`network_lif`.`resourceKey` AS `resourceKey`,`netapp_model`.`network_lif`.`clusterId` AS `clusterId`,`netapp_model`.`network_lif`.`vserverId` AS `vserverId`,`netapp_model`.`network_lif`.`currentPortId` AS `currentPortId`,`netapp_model`.`network_lif`.`homePortId` AS `homePortId`,`netapp_model`.`network_lif`.`routingGroupId` AS `routingGroupId`,`netapp_model`.`network_lif`.`address` AS `address`,`netapp_model`.`network_lif`.`netmask` AS `netmask`,`netapp_model`.`network_lif`.`netmaskLength` AS `netmaskLength`,`netapp_model`.`network_lif`.`dnsDomainName` AS `dnsDomainName`,`netapp_model`.`network_lif`.`failoverPolicy` AS `failoverPolicy`,`netapp_model`.`network_lif`.`failoverPolicyRaw` AS `failoverPolicyRaw`,`netapp_model`.`network_lif`.`createtime` AS `createTime`,`netapp_model`.`network_lif`.`updatetime` AS `updateTime` from `netapp_model`.`network_lif` where (`netapp_model`.`network_lif`.`objState` = 'LIVE')