Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2364)

Brocade Network Advisor SAN + IP User Manual 2327
53-1002949-01
Views
I
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION reset_vcs_licensed(integer)
OWNER TO dcmadmin;
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,
MASTER_INTERFACE.INTERFACE_ID as MASTER_INTERFACE_ID,
MASTER_INTERFACE.IF_NAME as MASTER_IF_NAME,
MEMBER_INTERFACE.INTERFACE_ID as MEMBER_INTERFACE_ID,
MEMBER_INTERFACE.IF_NAME as MEMBER_IF_NAME,
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 MEMBER_DEVICE on
MEMBER_DEVICE.MANAGED_ELEMENT_ID = TRILL_TRUNK_GROUP.ME_ID
left outer join INTERFACE MASTER_INTERFACE on
MASTER_INTERFACE.DEVICE_ID = MEMBER_DEVICE.DEVICE_ID and
MASTER_INTERFACE.IDENTIFIER = TRILL_TRUNK_GROUP.MASTER_PORT_NUMBER
left outer join INTERFACE MEMBER_INTERFACE on
MEMBER_INTERFACE.DEVICE_ID = MEMBER_DEVICE.DEVICE_ID and
MEMBER_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 CLUSTER_DEVICE on
CLUSTER_DEVICE.MANAGED_ELEMENT_ID = VCS_CLUSTER_MEMBER.CLUSTER_ME_ID;
WIRELESS_INTERFACE
create or replace view wireless_interface as
SELECT
l2.device_id,
l2.device_ip_address,
l2.physical_device_id,
l2.unit_number,
l2.slot_id,
l2.slot_num,
l2.module_id,
l2.physical_port_id,
l2.port_num,
l2.interface_id,
l2.name,
l2.if_name,
l2.identifier,