Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1482 / 1505

1434 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
VCS_MEMBER.MISSING,
VCS_MEMBER.MISSING_TIME
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
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