Delete Rows from SCCM using IntergrationHub ETL

[syed_but_not]

Hi,

I'm currently using IntegrationHub ETL to modify how assets are updated using the SCCM integration but have run into an issue. There are certain rows in the data source that we don't want based on the manufacturer, we don't want to update these CI's using the integration but I can't seem to find a way to exclude certain rows, does anyone know if there's a way to achieve this?

[Andrew_TND]

Hi @syed_but_not 

This looks like the original SCCM integration but repackaged.

If you’ve already set it up I.e. credentials and imported data… Go out of the setup menu, go to the SCCM application and open the Data Source module in the application navigator.

Open applicable record, scroll to the bottom and you’ll find a robust transformer. 

Finally you need to add a transform script to skip the rows you don’t want.

Transform Map: How to skip Records? 

Please mark as helpful or if I’ve resolved your issue, CORRECT!

[syed_but_not]

Hi @Andrew_TND, I see the ability to add a transform map, however this seems to be different than a robust transformer

[Andrew_TND]

hi @syed_but_not 

It could have been removed as the configs done through the integration hub… is it available to add in the related list?

[syed_but_not]

Hi @Andrew_TND thank you, I was able to find it. Do I simply modify the one that already exists?