where
clause are substituted with appropriate values for your environment.
SELECT vm_name FROM v3_0_latest_vm_configuration_view inner join v3_0_latest_tag_relations_history_view on (v3_0_latest_vm_configuration_view.vm_id = v3_0_latest_tag_relations_history_view.entity_id) inner join v3_0_latest_tag_details_view on (v3_0_latest_tag_details_view.tag_id = v3_0_latest_tag_relations_history_view.parent_id) WHERE getpathinnames(v3_0_latest_tag_details_view.history_id) like '/root/tlv%'
vm_name |
---|
RHEL6-Pool-67 |
RHEL6-Pool-5 |
RHEL6-Pool-6 |
RHEL6-23 |