Brocade Communications Systems IP250 Trilltrunkinfo, Userroleresourceinfo, Virtualfcoeportinfo

Views I

TRILL_TRUNK_INFO

create or replace view TRILL_TRUNK_INFO as select

TRILL_TRUNK_GROUP.ID, TRILL_TRUNK_GROUP.ME_ID,

TRILL_TRUNK_GROUP.MASTER_PORT_NUMBER,

TRILL_TRUNK_MEMBER.PORT_NUMBER as MEMBER_PORT_NUMBER, MEMBER_DEVICE.DEVICE_ID, INTERFACE.INTERFACE_ID, VCS_CLUSTER_MEMBER.CLUSTER_ME_ID, CLUSTER_DEVICE.DEVICE_ID as CLUSTER_DEVICE_ID

from

TRILL_TRUNK_GROUP 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,

Brocade Network Advisor IP User Manual	1659
53-1003056-01