Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Brocade Network Advisor SAN User Manual 1511
53-1002948-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';
BOOT_IMAGE_FILE_DETAILS_INFO
create or replace view BOOT_IMAGE_FILE_DETAILS_INFO as
select
BOOT_IMAGE_FILE_DETAILS.BOOT_IMAGE_NAME,
BOOT_IMAGE_FILE_DETAILS.MAJOR_VERSION,
BOOT_IMAGE_FILE_DETAILS.MINOR_VERSION,
BOOT_IMAGE_FILE_DETAILS.MAINTENANCE,
BOOT_IMAGE_FILE_DETAILS.PATCH,
BOOT_IMAGE_FILE_DETAILS.IMPORTED_DATE,
BOOT_IMAGE_FILE_DETAILS.RELEASE_DATE,
BOOT_IMAGE_FILE_DETAILS.RELEASE_NOTES_LOCATION,
BOOT_IMAGE_FILE_DETAILS.LOCATION,