Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2345)

2308 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Views
I
CORE_SWITCH,
SWITCH_PORT,
VIRTUAL_SWITCH,
DEVICE_NODE,
FABRIC,
DEVICE_PORT_MAC_ADDRESS_MAP,
GIGE_PORT,
VM_STORAGE,
VM_PATH,
DEVICE_ENCLOSURE,
VM_VIRTUAL_MACHINE,
VM_VCENTER,
VM_DATA_CENTER,
VM_HOST
where
VM_PATH.HBA_PORT = DEVICE_PORT.WWN
and VM_PATH.VM_ID = VM_VIRTUAL_MACHINE.ID
and VM_PATH.STORAGE_ID = VM_STORAGE.ID
and VM_STORAGE.HOST_ID = DEVICE_ENCLOSURE.ID
and DEVICE_ENCLOSURE.ID = VM_HOST.DEVICE_ENCLOSURE_ID
and DEVICE_ENCLOSURE.ID = VM_VIRTUAL_MACHINE.HOST_ID
and VM_HOST.VM_DATACENTER_ID = VM_DATA_CENTER.ID
and VM_DATA_CENTER.VCENTER_ID = VM_VCENTER.ID
and DEVICE_PORT.ID = DEVICE_PORT_MAC_ADDRESS_MAP.DEVICE_PORT_ID
and DEVICE_PORT_MAC_ADDRESS_MAP.MAC_ADDRESS::TEXT =
GIGE_PORT.REMOTE_MAC_ADDRESS::TEXT
and GIGE_PORT.SWITCH_PORT_ID = SWITCH_PORT.ID
and SWITCH_PORT.VIRTUAL_SWITCH_ID = VIRTUAL_SWITCH.ID
and VIRTUAL_SWITCH.CORE_SWITCH_ID = CORE_SWITCH.ID
and DEVICE_PORT.NODE_ID = DEVICE_NODE.ID
and DEVICE_NODE.FABRIC_ID = FABRIC.ID;
comment on view VM_CONNECTIVITY_INFO is
'Combine fabric and VM info to derive end to end connectivity information for the
VM';
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;