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

Brocade Network Advisor SAN User Manual 1411
53-1002696-01
Views
H
inner join
TRILL_TRUNK_MEMBER on
TRILL_TRUNK_MEMBER.GROUP_ID = TRILL_TRUNK_GROUP.ID
inner join
DEVICE as MEMBER_DEVICE on
MEMBER_DEVICE.MANAGED_ELEMENT_ID = TRILL_TRUNK_GROUP.ME_ID
left outer join
INTERFACE on
INTERFACE.DEVICE_ID = MEMBER_DEVICE.DEVICE_ID and
INTERFACE.IDENTIFIER = TRILL_TRUNK_MEMBER.PORT_NUMBER
left outer join
VCS_CLUSTER_MEMBER on
VCS_CLUSTER_MEMBER.MEMBER_ME_ID = TRILL_TRUNK_GROUP.ME_ID
left outer join
DEVICE as CLUSTER_DEVICE on
CLUSTER_DEVICE.MANAGED_ELEMENT_ID = VCS_CLUSTER_MEMBER.CLUSTER_ME_ID;
USER_ROLE_RESOURCE_INFO
create or replace view USER_ROLE_RESOURCE_INFO as
select
RESOURCE_GROUP.ID RESOURCE_GROUP_ID,
RESOURCE_GROUP.NAME RESOURCE_GROUP_NAME,
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,