Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1578 Brocade Network Advisor SAN User Manual
53-1002948-01
Views
H
VM_VIRTUAL_ETHERNET_ADAPTER.DISPLAY_LABEL,
VM_VIRTUAL_ETHERNET_ADAPTER.PORT_GROUP_NAME,
VM_VIRTUAL_MACHINE.NAME as VIRTUAL_MACHINE_NAME,
VM_VCENTER_MEMBER.HOST_NAME,
VM_VCENTER.NAME as VCENTER_NAME
From
VM_VIRTUAL_ETHERNET_ADAPTER,
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;
-- Name: ap_usage; Type: VIEW; Schema: dcm; Owner: dcmadmin
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;
-- Name: events; Type: VIEW; Schema: dcm; Owner: dcmadmin
CREATE VIEW events AS