Brocade Communications Systems IP250 user manual Zonedbinfo, Apusage, Events

I Views

VM_VIRTUAL_MACHINE,

VM_VCENTER_MEMBER,

VM_VCENTER

Where

VM_VIRTUAL_ETHERNET_ADAPTER.VIRTUAL_MACHINE_ID = VM_VIRTUAL_MACHINE.ID

And VM_VIRTUAL_MACHINE.HOST_ID = VM_VCENTER_MEMBER.VM_HOST_ID

And VM_VCENTER_MEMBER.VM_VCENTER_ID = VM_VCENTER.ID;

ZONE_DB_INFO

create or replace view ZONE_DB_INFO as select

ZONE_DB.ID,

ZONE_DB.FABRIC_ID,

ZONE_DB.OFFLINE, ZONE_DB.NAME,

ZONE_DB.CREATED, ZONE_DB.CREATED_BY,

ZONE_DB.LAST_MODIFIED, ZONE_DB.LAST_MODIFIED_BY, ZONE_DB.LAST_APPLIED, ZONE_DB.LAST_APPLIED_BY,

ZONE_DB.DEFAULT_ZONE_STATUS,

ZONE_DB.MCDATA_DEFAULT_ZONE, ZONE_DB.MCDATA_SAFE_ZONE,

ZONE_DB.ZONE_TXN_SUPPORTED, ZONE_DB.ZONE_CONFIG_SIZE,

ZONE_DB.ZONE_AVAILABLE_SIZE, ZONE_DB_CONFIG.ID AS CONFIG_ID, ZONE_DB_CONFIG.DEFINED_CONTENT, ZONE_DB_CONFIG.ACTIVE_CONTENT, ZONE_DB_CONFIG.TI_ZONE_CONTENT

from

ZONE_DB, ZONE_DB_CONFIG where

ZONE_DB.ID = ZONE_DB_CONFIG.ZONE_DB_ID;

AP_USAGE

CREATE VIEW ap_usage AS

SELECT ap_station.device_id, ap_station.time_stamp, count(*) AS num_clients FROM ap_station WHERE (ap_station.radio > 0) GROUP BY ap_station.device_id, ap_station.time_stamp;

EVENTS

CREATE VIEW events AS

SELECT emain.trap_log_id, emain.trap_sender, emain."timestamp", emain.severity, emsgs.messages, emain.is_ack, emain.log_type, emain.slot, emain.port, emain.device_id, emain.event_action_id, emain.device_group_id, emain.port_group_id, emain.trap_device_ip, emain.log_sub_type, emain.unit FROM (events_main emain LEFT JOIN events_messages emsgs ON ((emain.messages_id = emsgs.messages_id)));

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