Brocade Communications Systems IP250 user manual Vmdatastoredetailsinfo, Vmeemonitorinfo

Views I

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, DEST_NODE.WWN as DEST_DEVICE_WWN, DEST_PORT.WWN as DEST_PORT_WWN, SOURCE_NODE.FABRIC_ID as SOURCE_FABRIC_ID, DEST_NODE.FABRIC_ID as DEST_FABRIC_ID,

SOURCE_PORT.DOMAIN_ID as SOURCE_SWITCH_DOMAIN_ID, DEST_PORT.DOMAIN_ID as DEST_SWITCH_DOMAIN_ID,

VM_VIRTUAL_MACHINE.HYPERVISOR_VM_ID, VM_VIRTUAL_MACHINE.NAME as VM_NAME

from

VM_PATH,

VM_VIRTUAL_MACHINE,

DEVICE_PORT as SOURCE_PORT, DEVICE_PORT as DEST_PORT, DEVICE_NODE as DEST_NODE, DEVICE_NODE as SOURCE_NODE,

EE_MONITOR,

EE_MONITOR_STATS where

VM_PATH.HBA_PORT::BPCHAR = SOURCE_PORT.WWN

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