Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2280)

Brocade Network Advisor SAN + IP User Manual 2243
53-1002949-01
Views
I
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
VALUE Member value (D,P or WWN). varchar 256
ZONE_ID PK of owning zone. int
TABLE 536 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
TABLE 535 ZONE_MEMBER (Continued)
Field Definition Format Size