Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2676)

2604 Brocade Network Advisor SAN + IP User Manual
53-1003155-01
Views
I
RESET_VCS_LICENSED
CREATE OR REPLACE FUNCTION reset_vcs_licensed(no_of_licenses integer)
RETURNS void AS
$BODY$
begin
UPDATE fabric set vcs_licensed = 0;
UPDATE device set vcs_licensed = 0;
UPDATE fabric set vcs_licensed = 1 WHERE fabric.id in (SELECT id FROM fabric
ORDER BY creation_time LIMIT no_of_licenses);
UPDATE device set vcs_licensed = 1 WHERE device.managed_element_id in (SELECT
vcs_cluster_me_id FROM fabric_vcs_cluster_map WHERE fabric_id in (SELECT id FROM
fabric WHERE vcs_licensed=1));
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