View netapp_model_view.network_lif_full 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
name varchar 255 Textual name
clusterId bigint 19
vserverId bigint 19
currentNodeId bigint 19  √  null
currentPortId bigint 19  √  null
homeNodeId bigint 19  √  null
homePortId bigint 19  √  null
routingGroupId bigint 19  √  null
firewallPolicyId bigint 19  √  null Specifies the firewall policy for the LIF.
isAutoRevert bit 0  √  null If true, data LIF will revert to its home node under certain circumstances such as startup, and load balancing migration is disabled automatically
isHome bit 0  √  null True if LIF is currently on home node and home port
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
operationalStatus enum 10  √  null State of aggregate
operationalStatusRaw varchar 255  √  null
administrativeStatus enum 10  √  null State of aggregate
administrativeStatusRaw varchar 255  √  null
role enum 12  √  null Specifies the role associated with the LIF
roleRaw varchar 255  √  null
dataProtocols varchar 255  √  null Specifies the list of data protocols configured on the LIF. This can be comma separated. Possible values: nfs, cifs, iscsi, fcp, fc_nvme, fcache, none
failoverGroupId bigint 19  √  null failover group for this lif
failoverPolicy enum 21  √  null Specifies the failover policy for the LIF
failoverPolicyRaw varchar 255  √  null
isdnsupdateenabled bit 0  √  null True if DNS update is enabled for this LIF
listenfordnsquery bit 0  √  null True if the IP address will listen for DNS queries for the dns-zone specified
createTime bigint 19
updateTime bigint 19
objState enum 5 LIVE Internal object state

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `nl`.`objid` AS `objid`,`nl`.`uuid` AS `uuid`,`nl`.`resourceKey` AS `resourceKey`,`l`.`name` AS `name`,`nl`.`clusterId` AS `clusterId`,`nl`.`vserverId` AS `vserverId`,`l`.`currentNodeId` AS `currentNodeId`,`nl`.`currentPortId` AS `currentPortId`,`l`.`homeNodeId` AS `homeNodeId`,`nl`.`homePortId` AS `homePortId`,`nl`.`routingGroupId` AS `routingGroupId`,`nl`.`firewallPolicyId` AS `firewallPolicyId`,`l`.`isAutoRevert` AS `isAutoRevert`,`l`.`isHome` AS `isHome`,`nl`.`address` AS `address`,`nl`.`netmask` AS `netmask`,`nl`.`netmaskLength` AS `netmaskLength`,`nl`.`dnsDomainName` AS `dnsDomainName`,`l`.`operationalStatus` AS `operationalStatus`,`l`.`operationalStatusRaw` AS `operationalStatusRaw`,`l`.`administrativeStatus` AS `administrativeStatus`,`l`.`administrativeStatusRaw` AS `administrativeStatusRaw`,`l`.`role` AS `role`,`l`.`roleRaw` AS `roleRaw`,`l`.`dataProtocols` AS `dataProtocols`,`l`.`failoverGroupId` AS `failoverGroupId`,`nl`.`failoverPolicy` AS `failoverPolicy`,`nl`.`failoverPolicyRaw` AS `failoverPolicyRaw`,`nl`.`isDNSUpdateEnabled` AS `isdnsupdateenabled`,`nl`.`listenForDNSQuery` AS `listenfordnsquery`,`nl`.`createtime` AS `createTime`,`nl`.`updatetime` AS `updateTime`,`nl`.`objState` AS `objState` from (`netapp_model`.`network_lif` `nl` join `netapp_model`.`lif` `l` on((`nl`.`objid` = `l`.`objid`)))