SELECT vm_name, vm_type_value.value as vm_type, os_value.value as operating_system FROM v3_0_latest_vm_configuration_view inner join v3_0_enum_translator_view as vm_type_value on (vm_type_value.enum_type = 'VM_TYPE' and v3_0_latest_vm_configuration_view.vm_type = vm_type_value.enum_key) inner join v3_0_enum_translator_view as os_value on (os_value.enum_type = 'OS_TYPE' and v3_0_latest_vm_configuration_view.operating_system = os_value.enum_key)
vm_name | vm_type | operating_system |
---|---|---|
RHEL6-Pool-2 | Desktop | RHEL 6 x64 |
RHEL6-Pool-1 | Desktop | RHEL 6 x64 |
RHEL6-Pool-3 | Desktop | RHEL 6 x64 |
RHEL6-Pool-4 | Desktop | RHEL 6 x64 |
RHEL6-Pool-5 | Desktop | RHEL 6 x64 |