How to identify VMs by Operating System from command line/ database in Red Hat Enterprise Virtualization 3.5?

Solution Verified - Updated 2024-08-02T05:41:25+00:00 -

Issue

How to list VMs in the environment by operating system.
Is it possible to list VMs with a query against the postgresql database rather than going through the web interface?

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Here are the common uses of Markdown.

Code blocks

~~~
Code surrounded in tildes is easier to read
~~~

Links/URLs

[Red Hat Customer Portal](https://access.redhat.com)