Filter
Top Products
Brocade Network Advisor IP User Manual 1667
53-1003056-01
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