SG-SCCM Robust Transformer - how to check target record field values?

[Andrii]

CONTEXT

• I have SG-SCCM Data Source that retrieves data from SCCM Using Service Graph Connector and Robust Transformer. 

REQUIREMENT

• What I need to do - I need to check assigned_to of a target computer before I do an update.
• If current value of target assigned_to  is the one I want - then I want Robust Transformer to update the target assigned_to but if not - I want to skip this field update. 

QUESTION

• How do I achieve this via Robust Transformer? I know how to do such requirements using Transformation Map, but Robust Transformers seems to give less capabilities for scripting

[Bala Krishna2]

Hi Andrii,

Best way to check is by installing integration HUB ETL plugin. (It comes with proper guided set up)

1. Through it you can verify incoming data.
2. Add your logic for field there are OOTB script capabilites available such as getting model,Manufacturer..
3. You can create a logic and it will create a new field map.Consider that it runs for each row .

You can let me know further if you need more information.

Referencs:

IntegrationHub ETL (2.2.1) (servicenow.com)

https://www.youtube.com/watch?reload=9&v=2tVLhE_OwOE

Regards,

Bala Krishna

[CMDB Whisperer]

More specifically, you can use the scripted transform options in combination with the Table Lookup transform option to do this in IntegrationHub ETL.

[Yogi3]

The best way to check for any Robust Transformation engine mapping for Service Graph connector is you use free plugin called ‘Data visualizer’. You can check the fields from import table, temp entities and target tables. You can verify and validate transform operations too. You can also input test values and see how it gets transformed to target field. Very kool app specially for RTE. Hope this helps!

[VaranAwesomenow]

You can implement this in 3 ways

1. Implement on before script

    gliderecordusing key field from source / target -> if found

        //status = 'SKIPPED';

        or

        //ignore = true;

2. Implement on after script

    On after can access target Object, so you can run a set query to check if its a valid record or not and do a delete.

3. Write a post import script on scheduled import that will do the delete