View netapp_model_view.fcp_port | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`fcp_port`.`objid` AS `objid`,`netapp_model`.`fcp_port`.`uuid` AS `uuid`,`netapp_model`.`fcp_port`.`resourceKey` AS `resourceKey`,`netapp_model`.`fcp_port`.`clusterId` AS `clusterId`,`netapp_model`.`fcp_port`.`nodeId` AS `nodeId`,`netapp_model`.`fcp_port`.`nodeName` AS `nodeName`,`netapp_model`.`fcp_port`.`portName` AS `portName`,`netapp_model`.`fcp_port`.`adapter` AS `adapter`,`netapp_model`.`fcp_port`.`fabricEstablished` AS `fabricEstablished`,`netapp_model`.`fcp_port`.`firmwareRev` AS `firmwareRev`,`netapp_model`.`fcp_port`.`infoName` AS `infoName`,`netapp_model`.`fcp_port`.`maxSpeed` AS `maxSpeed`,`netapp_model`.`fcp_port`.`speed` AS `speed`,`netapp_model`.`fcp_port`.`SpeedRaw` AS `speedRaw`,`netapp_model`.`fcp_port`.`physicalProtocol` AS `physicalProtocol`,`netapp_model`.`fcp_port`.`PhysicalProtocolRaw` AS `physicalProtocolRaw`,`netapp_model`.`fcp_port`.`state` AS `state`,`netapp_model`.`fcp_port`.`StateRaw` AS `stateRaw`,`netapp_model`.`fcp_port`.`status` AS `status`,`netapp_model`.`fcp_port`.`StatusRaw` AS `statusRaw`,`netapp_model`.`fcp_port`.`switchPort` AS `switchPort`,`netapp_model`.`fcp_port`.`dataLinkRate` AS `dataLinkRate`,`netapp_model`.`fcp_port`.`mediaType` AS `mediaType`,`netapp_model`.`fcp_port`.`MediaTypeRaw` AS `mediaTypeRaw`,`netapp_model`.`fcp_port`.`createtime` AS `createTime`,`netapp_model`.`fcp_port`.`updatetime` AS `updateTime`,`netapp_model`.`fcp_port`.`statusAdmin` AS `statusAdmin`,`netapp_model`.`fcp_port`.`statusAdminRaw` AS `statusAdminRaw` from `netapp_model`.`fcp_port` where (`netapp_model`.`fcp_port`.`objState` = 'LIVE')