HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 203

Views E 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; Brocade Network Advisor Documentation Updates 195 53-1002363-02