Brocade Network Advisor SAN + IP User Manual v12.3.0 - Manual (Page 2631)

Brocade Network Advisor SAN + IP User Manual 2559
53-1003155-01
Views
I
PORT_PROFILE_INFO
create or replace view PORT_PROFILE_INFO as
select
PORT_PROFILE.ID,
PORT_PROFILE.SWITCH_ME_ID,
PORT_PROFILE.NAME,
PORT_PROFILE.STATE,
PORT_PROFILE.SWITCH_PORT_MODE,
PORT_PROFILE.ACL_PROFILE,
PORT_PROFILE.QOS_PROFILE,
PORT_PROFILE.FCOE_PROFILE,
PORT_PROFILE.VLAN_PROFILE,
PORT_PROFILE.VLAN_DETAILS,
PORT_PROFILE.DEFAULT_PROFILE,
PORT_PROFILE.ACL_NAME,
PORT_PROFILE.FCOE_MAP_NAME,
PORT_PROFILE.ACTIVATED,
PORT_PROFILE_QOS_MAP.DCB_MODE,
PORT_PROFILE_QOS_MAP.ETHERNET_MODE,
PORT_PROFILE_QOS_MAP.PAUSE_TX,
PORT_PROFILE_QOS_MAP.PAUSE_RX,
PORT_PROFILE_QOS_MAP.COS_COS,
PORT_PROFILE_QOS_MAP.TRAFFIC_CLASS,
PORT_PROFILE_QOS_MAP.COS,
PORT_PROFILE_QOS_MAP.CEE_MAP,
PORT_PROFILE_QOS_PFC_MAP.COS0_TX,
PORT_PROFILE_QOS_PFC_MAP.COS0_RX,
PORT_PROFILE_QOS_PFC_MAP.COS1_TX,
PORT_PROFILE_QOS_PFC_MAP.COS1_RX,
PORT_PROFILE_QOS_PFC_MAP.COS2_TX,
PORT_PROFILE_QOS_PFC_MAP.COS2_RX,
PORT_PROFILE_QOS_PFC_MAP.COS3_TX,
PORT_PROFILE_QOS_PFC_MAP.COS3_RX,
PORT_PROFILE_QOS_PFC_MAP.COS4_TX,
PORT_PROFILE_QOS_PFC_MAP.COS4_RX,
PORT_PROFILE_QOS_PFC_MAP.COS5_TX,
PORT_PROFILE_QOS_PFC_MAP.COS5_RX,
PORT_PROFILE_QOS_PFC_MAP.COS6_TX,
PORT_PROFILE_QOS_PFC_MAP.COS6_RX,
PORT_PROFILE_QOS_PFC_MAP.COS7_TX,
PORT_PROFILE_QOS_PFC_MAP.COS7_RX,
PORT_PROFILE_QOS_MAP.TRUST_COS
from PORT_PROFILE
left join PORT_PROFILE_QOS_MAP
on PORT_PROFILE.ID = PORT_PROFILE_QOS_MAP.PROFILE_ID
left join PORT_PROFILE_QOS_PFC_MAP
on PORT_PROFILE.ID = PORT_PROFILE_QOS_PFC_MAP.PROFILE_ID;
PORT_PROFILE_INTERFACE_INFO
create or replace view PORT_PROFILE_INTERFACE_INFO as
select
PORT_PROFILE.ID,
PORT_PROFILE.SWITCH_ME_ID,
PORT_PROFILE.NAME,
PORT_PROFILE.ACL_PROFILE,
PORT_PROFILE.QOS_PROFILE,