Breakdown Multivalued vROPS Custom Properties / Metrics values to Separate Columns.

Breakdown Multivalued vROPS Custom Properties / Metrics values to Separate Columns.

Its been a long time since I blogged on anything, got a tricky request from one of our large customers, they were running a vROPS report to get a set of vSphere tags for VM’s in their environment.

vROPS did give them the report as below

but the customer’s expectation was to get each of the vSphere tags split into their multiple columns

Unfortunately vROPS cant split property/metric data into its very own individual column.

Hence – I resorted to a bit of PowerCLI and Powershell to get the format the customer needs it.

You can find the script below which does all this conversion’s – notes are also updated for reference.

This script / (scriptlet in your master script ) can be used to split data into multiple columns for any property/metric.

 

 

Once you run the above, you would see the output is exactly as what the customer expected!

 

 

 

Please follow and like us:

Share this post

Post Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.