Copy the Values from RITM to Custom Table

[sayanghosh0]

Hello All,

Please help me to copy the values from RITM to a custom Table.
Please find the Catalog Item Screenshot

I want Server Infrastructure details values to be inserted in cmdb_ci_service_auto table(Please find the below screesnhot)

Backend name of Catalog item "Server Infrastructure details"(infrastructure_details)
Backend name of Custom Table(cmdb_ci_service_auto) Infrastructure details(u_infrastructure_details)

Best Regards

[Kristy Merriam]

Hi @sayanghosh0 ,

Personally, I would use a flow to do something like this that is triggered via the Service Catalog. In the flow you can specify the Requested Item template to pull the variable data from. Once you have the data, then you can update your cmdb_ci_service_auto record. 

Have this in a flow would also allow you to have some sort of review/approval step in there which I would recommend as you are updating information in your CMDB. 

[Ankur Bawiskar]

@sayanghosh0 

what script did you start with and where are you stuck?

If you are using workflow then you can use Run Script

If you are using flow then you can get the variable values using "Get Catalog Variables" and then use Insert Record flow action on your custom table

If my response helped please mark it correct and close the thread so that it benefits future readers.