Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1870 / 1940

1818 Brocade Network Advisor SAN User Manual
53-1003154-01
Views
H
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
SWITCH_PORT, VIRTUAL_SWITCH, FABRIC, FABRIC_MEMBER, PORT_GROUP_MEMBER,
PORT_GROUP
where
VIRTUAL_SWITCH .ID = SWITCH_PORT.VIRTUAL_SWITCH_ID and
FABRIC_MEMBER.VIRTUAL_SWITCH_ID = SWITCH_PORT.VIRTUAL_SWITCH_ID and
FABRIC_MEMBER.FABRIC_ID = FABRIC.ID and
SWITCH_PORT.ID = PORT_GROUP_MEMBER.SWITCH_PORT_ID and
PORT_GROUP_MEMBER.PORT_GROUP_ID = PORT_GROUP.ID;
ROLE_PRIVILEGE_INFO
create or replace view ROLE_PRIVILEGE_INFO as
select
ROLE.ID,
ROLE.NAME as ROLE_NAME,
ROLE.DESCRIPTION as ROLE_DESCRIPTION,
ROLE.HIDDEN as ROLE_HIDDEN,
PRIVILEGE.ID as PRIVILEGE_ID,
PRIVILEGE.NAME as PRIVILEGE_NAME,
PRIVILEGE.AREA as PRIVILEGE_AREA,
ROLE_PRIVILEGE_MAP.PERMISSION
from
ROLE,
ROLE_PRIVILEGE_MAP,
PRIVILEGE
where
ROLE.ID = ROLE_PRIVILEGE_MAP.ROLE_ID and
PRIVILEGE.ID = ROLE_PRIVILEGE_MAP.PRIVILEGE_ID;