Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1392 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
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,
SWITCH_PORT.PORT_NUMBER,
SWITCH_PORT.SLOT_NUMBER,
SWITCH_PORT.FICON_SUPPORTED,
SWITCH_PORT.STATE,
SWITCH_PORT.USER_PORT_NUMBER,
VIRTUAL_SWITCH.NAME as VIRTUAL_SWITCH_NAME,
VIRTUAL_SWITCH.ID as SWITCH_ID,
FABRIC.NAME as FABRIC_NAME,
FABRIC.MANAGED as FABRIC_MANAGED,
PORT_GROUP.ID as PORT_GROUP_ID,
PORT_GROUP_MEMBER.ID as PORT_GROUP_MEMBER_ID
from