List all VM info in a csv

[SCOTT FARWELL]

I'd like to list all of the VM params I specify (or all params) in a 1 line per VM CSV output I can then put into excel. (don't care what delimiter is used)

 

At a minimum I want to use "name-label, power-state, memory-static-max, VCPUs-max, os-version, disks, networks" but I need to output this info for 385 VMs so I am looking for a way to grab this information without trying to build my own parser using awk/perl/python. (I have limited experience with each)

 

Maybe someone has already done this and would be willing to share their parser.

 

"xe vm-list is-control-domain=false params=name-label,power-state,memory-static-max,VCPUs-max,os-version,disks,networks" gives me that base info I need but it is output on 7 lines per VM separated by a blank line like this:

 

name-label ( RW)           : krtb7
          power-state ( RO): running
    memory-static-max ( RW): 3221225472
            VCPUs-max ( RW): 2
           os-version (MRO): name: CentOS Linux release 7.2.1511 (Core); uname: 3.10.0-327.el7.x86_64; distro: centos; major: 7; minor: 2
                disks (MRO):
             networks (MRO): 0/ip: 10.10.40.63

I would like to have something more like :

"name-label ( RW):krtb7,power-state ( RO):running,memory-static-max ( RW):3221225472,VCPUs-max ( RW):2, os-version (MRO): CentOS Linux release 7.2.1511, disks (MRO):,networks (MRO):0/ip: 10.10.40.63"

or 

"krtb7,running,3221225472,2, CentOS Linux release 7.2.1511,,10.10.40.63"

Unfortunately --minimal appears to be the only output modifier I have found and that takes it down to just the VM name.

 

I am basically wanting a full inventory of my VMs and resource usage.  Not sure how to get disk space allocated/used either.

[SCOTT FARWELL]

Nobody ???

 

I figured an awk savvy tech out there had already created a quick parser for the forced output format of the "xe vm-list" command by now.

[Olivier Lambert]

Nice coincidence: this month we are releasing a CSV export for your whole infrastructure via Xen Orchestra Email report (we already have HTML report, but we've been asked recently to add CSV support, see https://xcp-ng.org/forum/topic/2972/xo-report-feature-request

 

Stay tuned, you'll be able to get your CSV report in a simple way from there :)

[SCOTT FARWELL]

I guess in the meantime I will try to build something with awk since I need it for a spreadsheet this week.

[Olivier Lambert]

It will come end of the month for Xen Orchestra :) I'll try to see if I have enough time to give you a shell command to put it the way you want before that.