Create a report with list of VM that have multiple tags

[Mariangela Tosti]

Hi, i need to create a report with a list of vm's sorted by tags.

The issue is that my vms have more than one tags and aria operation creates a single column for all the tags present in vm separated by characters.

Example

VM Name   Tags

VM1             “[<TAG1-value1>, <TAG2-value2>, <TAG3-value3>]”

 

I would like to generate the report with one column for each tag present in the VM

example.

VM Name   TAG1      TAG2     TAG3

VM1             value1    value2   value3

 

Is this possible via views and reports in aria operations?

 

Best regards

Mariangela Tosti

Translated with DeepL.com (free version)

[RickVerstegen]

I am afraid this is not possible with views at the moment. As a workaround, you could create a view with the vSphere Tag in a single column. Then, create a report and add this view. Run the report as a CSV file and use Excel to generate multiple columns to get the desired result.

[Mariangela Tosti]

@RickVerstegen thank you for your suggestion. I solved as you suggested with a macro in excel that spit column Tags in multiple columns.

[RickVerstegen]

@Mariangela Tosti: Happy to help. Please mark the thread as answered.