1644 Brocade Network Advisor IP User Manual
53-1003056-01
Views
I
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,
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_INTERFACE_MAP.INTERFACE_ID,
PORT_PROFILE_INTERFACE_MAP.SWITCH_PORT_ID
from
PORT_PROFILE,
PORT_PROFILE_INTERFACE_MAP
where
PORT_PROFILE.ID= PORT_PROFILE_INTERFACE_MAP.PROFILE_ID;
PORT_PROFILE_MAC_INFO
create or replace view PORT_PROFILE_MAC_INFO as