How to populate values from key:value to table

[Rutuja K]

Hello,

I am building a custom pattern for mssql db. I am getting output by running powershell file. Output is in key:value format. How can we map it with existing records in mssql db table.
Output eg:
name:master
collation_name: sql_collation_1
collation_value:150
name:testrestore
collation_name: sql_collation_2
collation_value:100

So in CMDB, we have a CIs named like master, testrestore- I need to map respective details from output to fields in cmdb.

Could you please help me with it

[PavanBV]

Hi @Rutuja K , have you tried writing a pre/post processing script for this?