Brocade Network Advisor IP User Manual 1683
53-1003056-01
Views I
VCS_DEVICE.MANAGED_ELEMENT_ID as VCS_ME_ID,
MEMBER_DEVICE.DEVICE_ID as MEMBER_DEVICE_ID,
MEMBER_DEVICE.MANAGED_ELEMENT_ID as MEMBER_ME_ID,
VCS_MEMBER.CREATION_TIME,
VCS_MEMBER.TRUSTED,
VCS_MEMBER.MISSING,
VCS_MEMBER.MISSING_TIME,
VCS_MEMBER.STATE,
VCS_MEMBER.FABRIC_STATUS
from
device VCS_DEVICE,
device MEMBER_DEVICE,
VCS_CLUSTER_MEMBER VCS_MEMBER
where
VCS_MEMBER.CLUSTER_ME_ID = VCS_DEVICE.MANAGED_ELEMENT_ID AND
VCS_MEMBER.MEMBER_ME_ID = MEMBER_DEVICE.MANAGED_ELEMENT_ID;
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