Brocade Communications Systems Network Advisor 12.0.0, User Manual

Page: 1442 / 1505

1394 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
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
select
PORT_PROFILE_MAC_MAP.PROFILE_ID,
PORT_PROFILE_MAC_MAP.MAC,
PORT_PROFILE_MAC_MAP.NAME as MAC_NAME,
VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME,
VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL,
VM_VIRTUAL_MACHINE.NAME as VM_NAME,
VM_VCENTER_MEMBER.HOST_NAME as HOST_NAME,
VM_VCENTER.NAME as VCENTER_NAME,
INTERFACE.IDENTIFIER
from
PORT_PROFILE_MAC_MAP