Updating the SCCM transformation map

[lmundere]

Hello,

I am currently changing our plugin Integration - Microsoft SCCM 2016 to the Service Graph and I have one challenge, I need to update the server location based on the AD short code (data available in SCCM). For example:

Ashburn => Short code is IAD

Manchester => short code is MAN

etc.

We have these short codes on the location table so by receiving it, I should be able to map the location to the server, I had this already set up in the previous integration, as I had a transformation script for it, but now I am struggling where to have this script in the Robust Transformation map, can anyone shade a light on this on where to start?  

[ersureshbe · Accepted solution]

Hi, Did you try with 'sys_rte_eb_operation_list.do' table and define the script , conditions here.

[lmundere]

Hi Ersureshbe, let me give it a try and come back to you. Thanks

[Joe S1]

In your IntegrationHub ETL in Step 2 you can create a New Transform and choose script operation. From there you can pass in a value run your script and return a value to a defined field. You can then take that defined field and map it in your Class mapping in Step 3.