Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1809 / 1940

Brocade Network Advisor SAN User Manual 1757
53-1003154-01
Views
H
Views
ADAPTER_PORT_CONFIG_INFO
create or replace view ADAPTER_PORT_CONFIG_INFO as
select
ADAPTER_PORT_CONFIG.ID,
ADAPTER_PORT_CONFIG.NAME as CONFIG_NAME,
ADAPTER_PORT_CONFIG.TYPE as TYPE,
ADAPTER_PORT_CONFIG_PROPERTY.NAME as PROPERTY_NAME,
ADAPTER_PORT_CONFIG_DETAILS.VALUE as PROPERTY_VALUE
from
ADAPTER_PORT_CONFIG,
ADAPTER_PORT_CONFIG_DETAILS,
ADAPTER_PORT_CONFIG_PROPERTY
where
ADAPTER_PORT_CONFIG.ID = ADAPTER_PORT_CONFIG_DETAILS.CONFIG_ID
and ADAPTER_PORT_CONFIG_PROPERTY.ID= ADAPTER_PORT_CONFIG_DETAILS.PROPERTY_ID;
AG_CONNECTION_INFO
create or replace view AG_CONNECTION_INFO as
select
AG_N_PORT.VIRTUAL_SWITCH_ID as SOURCE_SWITCH_ID,
AG_N_PORT.ID as SOURCE_PORT_ID,
AG_N_PORT.WWN as SOURCE_PORT_WWN,
AG_N_PORT.TYPE as SOURCE_PORT_TYPE,
AG_N_PORT.USER_PORT_NUMBER as SOURCE_USER_PORT_NUMBER,
EDGE_F_PORT.VIRTUAL_SWITCH_ID as DESTINATION_SWITCH_ID,
EDGE_F_PORT.ID as DESTINATION_PORT_ID,
EDGE_F_PORT.WWN as DESTINATION_PORT_WWN,
EDGE_F_PORT.TYPE as DESTINATION_PORT_TYPE,
EDGE_F_PORT.USER_PORT_NUMBER as DESTINATION_USER_PORT_NUMBER
from
SWITCH_PORT AG_N_PORT,
SWITCH_PORT EDGE_F_PORT
where
((AG_N_PORT.REMOTE_PORT_WWN = EDGE_F_PORT.WWN)
or (AG_N_PORT.REMOTE_PORT_WWN = EDGE_F_PORT.LOGICAL_PORT_WWN
and EDGE_F_PORT.TRUNK_MASTER = 1))
and AG_N_PORT.TYPE = 'N-Port';
TABLE 525 ZONE_SET
Field Definition Format Size
ID* Unique generated database identifier. int
ZONE_DB_ID PK of owning zone DB. int
NAME Zone set name. varchar 64
ACTIVE 1 = active zone set
0 = otherwise. smallint