VM Notes (Annotations) inconsistant format – want to export

This post was originally published on this site

Our VM notes (annotations) have several styles depending on what point in history and who entered them. One thing that is common is there are multiple lines in the notes. One ‘gotcha’ I foresee problems in exporting the notes is some are using full colons and dates.

 

For example:

Team: the one that asks for VMs

Record ID: <data>

Date: <data>

Deployed by: <data>

 

Other VMs have no notes. Others have a one or two liner of text.

 

I’d like to export to csv in the following format:

 

VM Name Header 2 Header 3 Header 4
machine1 Team: Infrastructure Deployment Date: June 20, 2019 Deployed by: Fred
machine2 Telephony Template used: xxxxxxxx
machine3 line of text another line of text

 

One column per line of notes.

Leave a Reply

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