Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1899)

Brocade Network Advisor SAN User Manual 1847
53-1003154-01
Views
H
left join VCS_CLUSTER_MEMBER on VCS_CLUSTER_MEMBER.MEMBER_ME_ID =
DEVICE.MANAGED_ELEMENT_ID
left join DEVICE as CLUSTER_DEVICE on CLUSTER_DEVICE.MANAGED_ELEMENT_ID =
VCS_CLUSTER_MEMBER.CLUSTER_ME_ID
left join PORT_PROFILE_INTERFACE_MAP on PORT_PROFILE_INTERFACE_MAP.INTERFACE_ID =
INTERFACE.INTERFACE_ID
left join PORT_PROFILE on PORT_PROFILE.ID = PORT_PROFILE_INTERFACE_MAP.PROFILE_ID
left join (select PORT_PROFILE_DOMAIN_MAP.PROFILE_ID,
array_to_string(array_agg(PORT_PROFILE_DOMAIN.NAME), ',') DOMAIN_NAMES from
PORT_PROFILE_DOMAIN_MAP join PORT_PROFILE_DOMAIN on
PORT_PROFILE_DOMAIN_MAP.PROFILE_DOMAIN_ID = PORT_PROFILE_DOMAIN.ID group by
PORT_PROFILE_DOMAIN_MAP.PROFILE_ID) PROFILE_DOMAINS on PROFILE_DOMAINS.PROFILE_ID
= PORT_PROFILE.ID
left join (select PROFILE_ID, array_agg(VLANID)::varchar as VLAN from
PORT_PROFILE_VLAN_MAP group by PROFILE_ID) PROFILE_VLAN_MAP on
PROFILE_VLAN_MAP.PROFILE_ID = PORT_PROFILE.ID
where VNIC_DV_PORT.VM_DV_SWITCH_ID = PNIC_DV_PORT.VM_DV_SWITCH_ID;
VM_DATASTORE_DETAILS_INFO
create or replace view VM_DATASTORE_DETAILS_INFO as
select vm_virtual_machine_datastore_map.virtual_machine_id,
vm_virtual_machine_datastore_map.vm_datastore_details_id,
vm_datastore_details.datacenter_id,
vm_virtual_machine_datastore_map.provisioned_storage,
vm_virtual_machine_datastore_map.not_shared_storage,
vm_virtual_machine_datastore_map.used_storage,
vm_datastore_details.name, vm_datastore_details.accessible,
vm_datastore_details.status, vm_datastore_details.file_system_type,
vm_datastore_details.total_capacity, vm_datastore_details.free_space,
vm_datastore_details.last_update_time, vm_datastore_details.rdm_supported,
vm_datastore_details.perfile_thin_provisioning_supported,
vm_datastore_details.storage_iorm_supported,
vm_datastore_details.directory_hierarchy_supported, vm_datastore_details.location
from vm_virtual_machine_datastore_map, vm_datastore_details
where vm_virtual_machine_datastore_map.vm_datastore_details_id =
vm_datastore_details.id;
VM_EE_MONITOR_INFO
This view provides combined ee_monitor, ee_monitor_stats, device_port and device_node tables to
get the EE Monitor information for vmplug-in.
create or replace view VM_EE_MONITOR_INFO as
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,