Brocade Communications Systems IP250 user manual Sensorinfo, Eemonitor

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,

Brocade Network Advisor IP User Manual	1647
53-1003056-01