VMware Cloud Community
Czernobog
Expert
Expert

vRA 7.6 - bulk import csv generation not working as expected, also using cloudclient

I need to export the CSV file for managed machines. It seems that the ~500 VMs in the environment are too much for the process to handle and I get an error 502.

After that I tried to use the cloudclient 4.7, however, when using the vra machines list command only the resource type and id are exported, like this:

catalogResource.resourceTypeRef.label,catalogResource.id
Virtual Machine,c3d1a38a-f7c0-4b36-a0f4-4e02d94fd979
Virtual Machine,655d16cb-5b60-44f7-8039-ffb8207e2e39

There is no name, blueprint id, resource association etc., only those two columns.

How do I use the cloudclient to receive a vsc file that hase the same content as the export using the GUI?

Edit: Also, is there a way to filter content that will be exported, using the Generate CSV File function in the GUI? I get a Business Group, Blueprint etc. selection after choosing to export Unmanaged Machines, but when I select Managed Machines, all dropdown fields under Default Values are greyed otu (except Component machine). Is this normal, expected behaviour? Shouldn't it be the other way around? The Bulk Import module seems to be really janky.

Tags (1)
0 Kudos
2 Replies
qc4vmware
Virtuoso
Virtuoso

I'm gonna share a utility with you I put together a while back because I had so many issues with generating the bulk import csv's.  Maybe this will get you what you need with a little tweaking.  You can filter on a few things.  It is designed to create files based on unmanaged machines so if you need it to work against managed you'll have to tweak that.  Hope this helps.  I've only used this with 7.3.1 and lower so hopefully the format is still the same.   Good luck!

0 Kudos
darrenoid
Enthusiast
Enthusiast

I am running vra 7.6 and see the same thing. I found KB VMware Knowledge Base which says "To work around this issue either filter the number of machines you will be exporting down or use Cloud Client to generate the list."

However, as you pointed out, the options to filter the machines down by business group, etc are greyed out and the cloud client machine list does not include the same fields. It does seem backwards to have those options greyed out for managed machines but not for unmanaged. It might be worth it to open a support request with VMWare on this issue.

~ Darren

0 Kudos