Select Your Language

Infrastructure and Management

Cloud Computing

Storage

Runtimes

Integration and Automation

  • Comments
  • Export a list of virtual machines to a spreadsheet with full column header

    Posted on

    From https://access.redhat.com/solutions/1987863 I learned that I can export a list of virtual machines to a spreadsheet by doing:

    /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "copy (select vm_name, vm_guid, cluster_name, storage_pool_name from server_vms order by storage_pool_name, cluster_name, vm_name) to stdout with csv;"
    

    and also tried:

    /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "copy (select * from server_vms) to stdout with csv;"
    

    and got a huge list of columns without the hearder so I don't really know what each column means.

    Is there a way to also export the column header or better yet, find out what the server_vms table contains?

    by

    points

    Responses

    Red Hat LinkedIn YouTube Facebook X, formerly Twitter

    Quick Links

    Help

    Site Info

    Related Sites

    © 2025 Red Hat