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.