Brocade Communications Systems IP250 user manual Resetvcslicensed, $Body$, Trilltrunkgroup

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

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