Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1747)

Brocade Network Advisor IP User Manual 1693
53-1002947-01
Views
I
PHYSICAL_DEVICE_INFO
create or replace view PHYSICAL_DEVICE_INFO as
select
PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID as PD_PHYSICAL_DEVICE_ID,
PHYSICAL_DEVICE.DEVICE_ID,
PHYSICAL_DEVICE.DESCRIPTION,
PHYSICAL_DEVICE.NUM_SLOTS,
PHYSICAL_DEVICE.TABLE_SUBTYPE,
PHYSICAL_DEVICE.UNIT_NUMBER,
PHYSICAL_DEVICE.UNIT_NEIGHBOR1,
PHYSICAL_DEVICE.UNIT_NEIGHBOR2,
PHYSICAL_DEVICE.UNIT_PRESENT,
FOUNDRY_PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID as FPD_PHYSICAL_DEVICE_ID,
FOUNDRY_PHYSICAL_DEVICE.SERIAL_NUMBER,
FOUNDRY_PHYSICAL_DEVICE.PRODUCT_TYPE,
DEVICE.IP_ADDRESS
from
PHYSICAL_DEVICE,
FOUNDRY_PHYSICAL_DEVICE,
DEVICE
where
DEVICE.DEVICE_ID = PHYSICAL_DEVICE.DEVICE_ID
and PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID =
FOUNDRY_PHYSICAL_DEVICE.PHYSICAL_DEVICE_ID;
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,