View netapp_model_view.network_lif_full | Generated by SchemaSpy |
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`)))