Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1730)

1676 Brocade Network Advisor IP User Manual
53-1002947-01
Views
I
ROLE.ID ROLE_ID,
ROLE.NAME ROLE_NAME,
USER_.NAME USER_NAME
from
USER_,
RESOURCE_GROUP,
ROLE,
USER_RESOURCE_MAP,
USER_ROLE_MAP
where
USER_ROLE_MAP.USER_NAME = USER_.NAME
and USER_ROLE_MAP.ROLE_ID = ROLE.ID
and USER_RESOURCE_MAP.RESOURCE_GROUP_ID = RESOURCE_GROUP.ID
and USER_RESOURCE_MAP.USER_NAME = USER_.NAME;
VIRTUAL_FCOE_PORT_INFO
create or replace view VIRTUAL_FCOE_PORT_INFO as
select
VIRTUAL_FCOE_PORT.ID,
VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID,
VIRTUAL_FCOE_PORT.PORT_WWN,
VIRTUAL_FCOE_PORT.PORT_SPEED,
VIRTUAL_FCOE_PORT.PORT_TYPE,
VIRTUAL_FCOE_PORT.ENABLED,
VIRTUAL_FCOE_PORT.STATUS,
VIRTUAL_FCOE_PORT.TRUNK_INDEX,
VIRTUAL_FCOE_PORT.PORT_NUMBER,
VIRTUAL_FCOE_PORT.NAME,
VIRTUAL_FCOE_PORT.SLOT_NUMBER,
VIRTUAL_FCOE_PORT.VLAN_ID,
VIRTUAL_FCOE_PORT.DEVICE_COUNT,
VIRTUAL_FCOE_PORT.PEER_MAC,
VIRTUAL_SWITCH.WWN as VIRTUAL_SWITCH_WWN,
VIRTUAL_SWITCH.ROLE as SWITCH_ROLE,
VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID as VIRTUAL_FABRIC_ID,
VIRTUAL_SWITCH.DOMAIN_ID as DOMAIN_ID,
VIRTUAL_SWITCH.INTEROP_MODE as INTEROP_MODE,
VIRTUAL_SWITCH.MANAGEMENT_STATE,
VIRTUAL_SWITCH.MONITORED,
CORE_SWITCH.TYPE as SWITCH_TYPE,
CORE_SWITCH.FIRMWARE_VERSION as FIRMWARE_VERSION,
CORE_SWITCH.IP_ADDRESS as IP_ADDRESS,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,
CORE_SWITCH.MODEL as SWITCH_MODEL,
CORE_SWITCH_DETAILS.MODEL_NUMBER as SWITCH_MODEL_NUMBER
from
VIRTUAL_FCOE_PORT, CORE_SWITCH, VIRTUAL_SWITCH, CORE_SWITCH_DETAILS
where
VIRTUAL_FCOE_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID and
VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID and
CORE_SWITCH_DETAILS.CORE_SWITCH_ID = CORE_SWITCH.ID;
VIRTUAL_PORT_WWN_DETAILS_INFO
create or replace view VIRTUAL_PORT_WWN_DETAILS_INFO as
select distinct
VIRTUAL_PORT_WWN_DETAILS.SWITCH_ID,