Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1398 Brocade Network Advisor SAN User Manual
53-1002696-01
Views
H
LEFT JOIN VM_ADDRESS_INFO VM2 ON SFLOW_MINUTE_MAC.DEST_MAC = VM2.MAC_ADDRESS
WHERE SFLOW_MINUTE_MAC.SLNUM <= (( SELECT SFLOW_MINUTE_MAC_SLNUM.MAX_SLNUM
FROM SFLOW_MINUTE_MAC_SLNUM
LIMIT 1))
union all
select
SFLOW_STAGING.DEVICE_ID,
SFLOW_STAGING.TIME_IN_SECONDS,
SFLOW_STAGING.SRC_MAC,
SFLOW_STAGING.DEST_MAC,
SFLOW_STAGING.IN_VLAN,
SFLOW_STAGING.OUT_VLAN,
SFLOW_STAGING.FRAMES,
SFLOW_STAGING.BYTES,
VM1.VM_NAME AS SRC_VM_NAME,
VM2.VM_NAME AS DEST_VM_NAME,
VM1.VM_ADDRESS AS SRC_VM_ADDRESS,
VM2.VM_ADDRESS AS DEST_VM_ADDRESS,
VM1.VM_HOST_NAME AS SRC_VM_HOST_NAME,
VM2.VM_HOST_NAME AS DEST_VM_HOST_NAME,
VM1.VM_HOST_ADDRESS AS SRC_VM_HOST_ADDRESS,
VM2.VM_HOST_ADDRESS AS DEST_VM_HOST_ADDRESS,
VM1.VM_ID AS SRC_VM_ID,
VM2.VM_ID AS DEST_VM_ID,
VM1.VM_HOST_ID AS SRC_VM_HOST_ID,
VM2.VM_HOST_ID AS DEST_VM_HOST_ID
FROM
SFLOW_STAGING
LEFT JOIN VM_ADDRESS_INFO VM1 ON SFLOW_STAGING.SRC_MAC = VM1.MAC_ADDRESS
LEFT JOIN VM_ADDRESS_INFO VM2 ON SFLOW_STAGING.DEST_MAC = VM2.MAC_ADDRESS
WHERE
SFLOW_STAGING.SLNUM >= (( SELECT SFLOW_STAGING_SLNUM.MIN_SLNUM
FROM SFLOW_STAGING_SLNUM
LIMIT 1));
SCOM_EE_MONITOR_INFO
This view provides combined ee_monitor, ee_monitor_stats, device_port and device_node tables to
get the EE Monitor information for SCOM plug-in.
create or replace view SCOM_EE_MONITOR_INFO as
select distinct
EE_MONITOR.NAME,
EE_MONITOR.SWITCH_PORT_ID,
EE_MONITOR.SOURCE_PORT_ID,
EE_MONITOR.DEST_PORT_ID,
EE_MONITOR_STATS.TX,
EE_MONITOR_STATS.RX,
EE_MONITOR_STATS.CRCERRORS,
EE_MONITOR_STATS.CREATION_TIME,
SOURCE_PORT.PORT_ID as SID,
DEST_PORT.PORT_ID as DID,
SOURCE_NODE.WWN as SOURCE_DEVICE_WWN,
SOURCE_PORT.WWN as SOURCE_PORT_WWN,
DEST_NODE.WWN as DEST_DEVICE_WWN,
DEST_PORT.WWN as DEST_PORT_WWN,
SOURCE_NODE.FABRIC_ID as SOURCE_FABRIC_ID,
DEST_NODE.FABRIC_ID as DEST_FABRIC_ID,
SOURCE_PORT.DOMAIN_ID as SOURCE_SWITCH_DOMAIN_ID,