Filter
Top Products
Brocade Network Advisor IP User Manual 1647
53-1003056-01
Views
I
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,
DEST_PORT.DOMAIN_ID as DEST_SWITCH_DOMAIN_ID
from
DEVICE_PORT as SOURCE_PORT,
DEVICE_PORT as DEST_PORT,
DEVICE_NODE as DEST_NODE,
DEVICE_NODE as SOURCE_NODE,
EE_MONITOR,
EE_MONITOR_STATS
where
SOURCE_PORT.ID = EE_MONITOR.SOURCE_PORT_ID
and EE_MONITOR.ID = EE_MONITOR_STATS.EE_MONITOR_ID
and SOURCE_PORT.NODE_ID = SOURCE_NODE.ID
and DEST_PORT.ID = EE_MONITOR.DEST_PORT_ID
and DEST_PORT.NODE_ID = DEST_NODE.ID
and EE_MONITOR_STATS.CREATION_TIME in (
select MAX(CREATION_TIME)
from EE_MONITOR_STATS
group by EE_MONITOR_ID);
SENSOR_INFO
create or replace view SENSOR_INFO as
select
SENSOR.ID,
SENSOR.CORE_SWITCH_ID,
SENSOR.SENSOR_ID,
SENSOR.CURRENT_READING,
SENSOR.TYPE,
SENSOR.SUB_TYPE,
SENSOR.DESCRIPTION,
SENSOR.STATUS,
SENSOR.OPERATIONAL_STATUS,
SENSOR.PART_NUMBER,
SENSOR.SERIAL_NUMBER,
SENSOR.VERSION,
SENSOR.CREATION_TIME,
SENSOR.LAST_UPDATE_TIME,
SENSOR.FRU_TYPE,
SENSOR.UNIT_NUMBER,
SENSOR.STATE,
CORE_SWITCH.WWN as PHYSICAL_SWITCH_WWN,