View netapp_model_view.network_port_full | Generated by SchemaSpy |
View Definition:
select `np`.`objid` AS `objid`,`np`.`uuid` AS `uuid`,`np`.`resourceKey` AS `resourceKey`,`np`.`name` AS `name`,`np`.`nodeId` AS `nodeId`,`np`.`clusterId` AS `clusterId`,`np`.`macAddress` AS `macAddress`,`np`.`administrativeSpeed` AS `administrativeSpeed`,`np`.`administrativeSpeedRaw` AS `administrativeSpeedRaw`,`np`.`operationalSpeed` AS `operationalSpeed`,`np`.`operationalSpeedRaw` AS `operationalSpeedRaw`,`np`.`linkStatus` AS `linkStatus`,`np`.`linkStatusRaw` AS `linkStatusRaw`,`np`.`role` AS `role`,`np`.`roleRaw` AS `roleRaw`,`np`.`portType` AS `portType`,`np`.`portTypeRaw` AS `portTypeRaw`,`np`.`vlanIdentifier` AS `vlanIdentifier`,`netapp_model`.`network_port_relationship`.`vlanPortId` AS `vlanPortId`,`netapp_model`.`network_port_relationship`.`ifgrpPortId` AS `ifgrpPortId`,`np`.`mtu` AS `mtu`,`np`.`operationalDuplex` AS `operationalDuplex`,`np`.`operationalDuplexRaw` AS `operationalDuplexRaw`,`np`.`networkIpSpaceId` AS `networkIpSpaceId`,`np`.`networkPortBroadcastDomainId` AS `networkPortBroadcastDomainId`,`np`.`healthStatus` AS `healthStatus`,`np`.`healthStatusRaw` AS `healthStatusRaw`,`np`.`ignoreHealthStatus` AS `ignoreHealthStatus`,`np`.`healthDegradedReasons` AS `healthDegradedReasons`,`np`.`healthDegradedReasonsRaw` AS `healthDegradedReasonsRaw`,`np`.`isAdministrativeUp` AS `isAdministrativeUp`,`np`.`createtime` AS `createTime`,`np`.`updatetime` AS `updateTime`,`np`.`objState` AS `objState` from (`netapp_model`.`network_port` `np` left join `netapp_model`.`network_port_relationship` on((`np`.`objid` = `netapp_model`.`network_port_relationship`.`objid`)))