Brocade Communications Systems IP250 user manual Portbottleneckconfinfo, Portbottleneckstatinfo

I Views

PORT_BOTTLENECK_CONF_INFO

This view provides combine port bottleneck configuration and enough information from switch port for the client to identify the port.

create or replace view PORT_BOTTLENECK_CONF_INFO as select

PORT_BOTTLENECK_CONFIG.SWITCH_PORT_ID,

PORT_BOTTLENECK_CONFIG.BOTTLENECK_DETECT_ENABLED, PORT_BOTTLENECK_CONFIG.ALERTS_ENABLED, PORT_BOTTLENECK_CONFIG.CONGESTION_THRESHOLD, PORT_BOTTLENECK_CONFIG.LATENCY_THRESHOLD, PORT_BOTTLENECK_CONFIG.WINDOW_, PORT_BOTTLENECK_CONFIG.QUIET_TIME, PORT_BOTTLENECK_CONFIG.CREATION_TIME, PORT_BOTTLENECK_CONFIG.LAST_UPDATE_TIME, PORT_BOTTLENECK_CONFIG.LATENCY_SEVERITY, PORT_BOTTLENECK_CONFIG.LATENCY_TIME, SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.TYPE,

SWITCH_PORT.WWN from

PORT_BOTTLENECK_CONFIG

left outer join SWITCH_PORT

on PORT_BOTTLENECK_CONFIG.SWITCH_PORT_ID = SWITCH_PORT.ID;

comment on view PORT_BOTTLENECK_CONF_INFO is

Combine port bottleneck configuration and enough info from switch port for the client to identify the port.;

PORT_BOTTLENECK_STAT_INFO

This view provides combine port bottleneck status and enough information from the switch port for the client to identify the port.

create or replace view PORT_BOTTLENECK_STAT_INFO as select

PORT_BOTTLENECK_STATUS.SWITCH_PORT_ID, PORT_BOTTLENECK_STATUS.STATUS, SWITCH_PORT.VIRTUAL_SWITCH_ID, SWITCH_PORT.USER_PORT_NUMBER, SWITCH_PORT.TYPE

from

PORT_BOTTLENECK_STATUS

left outer join SWITCH_PORT

on PORT_BOTTLENECK_STATUS.SWITCH_PORT_ID = SWITCH_PORT.ID;

PORT_GROUP_INFO

create or replace view PORT_GROUP_INFO as select

SWITCH_PORT.ID as PORT_ID,

SWITCH_PORT.NAME as SWITCH_PORT_NAME,

SWITCH_PORT.WWN, SWITCH_PORT.HEALTH, SWITCH_PORT.STATUS,

1642	Brocade Network Advisor IP User Manual
	53-1003056-01