Views, Adapter_port_config_info, Ag_connection_info – Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2280

Advertising
background image

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

Advertising