Brocade Communications Systems IP250 user manual Slotinfo, Managedelementinfo, Snmpdatainfo

I Views

SLOT_INFO

create or replace view SLOT_INFO as select

SLOT.*,

PHYSICAL_DEVICE.UNIT_NUMBER, DEVICE.IP_ADDRESS

from

PHYSICAL_DEVICE, SLOT,

DEVICE where

DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID

and SLOT.PHYSICAL_DEVICE_ID = PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID;

MANAGED_ELEMENT_INFO

Common managed element data used by custom DTO methods to identify the managed element type, and provide a link to the details table for the managed element. Some common managed element fields are included in this view so Fault Management can use this view to identify the managed element ID for an event source.

create or replace view MANAGED_ELEMENT_INFO as select

MANAGED_ELEMENT.ID as MANAGED_ELEMENT_ID, DEVICE.DEVICE_ID as IP_DEVICE_ID, coalesce(CS_ME.ID, CS_VS.ID) as CORE_SWITCH_ID, VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID, DEVICE_ENCLOSURE.ID as DEVICE_ENCLOSURE_ID, DEVICE.IP_ADDRESS as LAN_IP_ADDRESS,

coalesce (CS_VS.IP_ADDRESS, CS_ME.IP_ADDRESS, DEVICE_ENCLOSURE.IP_ADDRESS) as SAN_IP_ADDRESS,

VIRTUAL_SWITCH.VIRTUAL_FABRIC_ID,

coalesce (VIRTUAL_SWITCH.WWN, CS_ME.WWN, DEVICE.NODE_WWN) as NODE_WWN

from

MANAGED_ELEMENT

left outer join VIRTUAL_SWITCH on MANAGED_ELEMENT.ID =

VIRTUAL_SWITCH.MANAGED_ELEMENT_ID

left outer join CORE_SWITCH CS_ME on (MANAGED_ELEMENT.ID = CS_ME.MANAGED_ELEMENT_ID)

left outer join CORE_SWITCH CS_VS on (CS_VS.ID =

VIRTUAL_SWITCH.CORE_SWITCH_ID)

left outer join DEVICE on MANAGED_ELEMENT.ID = DEVICE.MANAGED_ELEMENT_ID left outer join DEVICE_ENCLOSURE on MANAGED_ELEMENT.ID =

DEVICE_ENCLOSURE.MANAGED_ELEMENT_ID;

SNMP_DATA_INFO

create or replace view SNMP_DATA_INFO as select * from SNMP_DATA

union all

select * from SNMP_DATA_30MIN union all

select * from SNMP_DATA_2HOUR union all

select * from SNMP_DATA_1DAY;

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