How to export the variables of specific RITMs in XML?

[Suggy]

We have around 3000 RITMs but I need to move only 500 RITMs from one SN to another SN instance (including the variables and its values for 500 RITMs)

I used a filter to export those 500 RITM via XML and imported in target instance but the variables section did not show up on the RITM, and I understand the reason - that the variable data sits in different table which is sc_item_option.

Hence, I went to sc_item_option table to export the XMLs but problem is that, I couldnt find a way to use the filter on this table.. something like 'RITM is one of <1,2,3..500>' on this table.

Anyone knows how to export the variables and its values from sc_item_option table for those specific 500 RITMs?

[Suggy]

Thankyou

[sanjaybagri]

Hello @Suggy ,

I have tried many ways into PDI. 

I tried to move Catalog item first and then Variables(sets) then RITM along with Request as an XML. Buts its not showing the Variable sections because its generating during/after the execution time. 

If you want, you can export all RITM based on the Catalog item field filter in sc_req_item table then export as XML then go to target instance and import the exported file. without having variable section details. 

If you want more information then you can raise a Hi-Support case for data Migration so that they will guide you best way.

Please mark my answer as helpful and correct if it resolves/helps your query.

Regards,

Thanks

Sanjay Bagri

[Suggy]

Hey @sanjaybagri  are you saying that its not possible to show the variable section at all even though we import all the related XMLs?

Our requirement was to move the closed requests from one instance to another instance (including audit, variables..... everything)