Robust Import Set Transformer

[Shalani Rajendr]

Hello everyone,

      I have a requirement where we have configured service graph connector for Microsoft SCCM to pull data into ServiceNow instance. They have used Robust Import set Transformer where transformer definition type is cmdb integration studio application data source is created and cmdb integration studio entities, entity mapping,entity field mapping, entity engine operation is configured. A scheduled job is created to run this robust import set transformer where transform mapping is done for multiple tables and one of the table is cmdb_sam_sw_install. They have written a business rule on insertion to cmdb_sam_sw_install with condition installed_on.operational_status is one of ceased,under construction then it should abort action(checkbox) is checked.

Due to this everytime during the import thousands of errors are logged. I need to avoid this error in syslog table as it affects the performance of the instance.

Kindly request to suggest a best solution to remove logs from sys log table. Either an alternative solution for business rule or onbefore script in robust import set transformer where the record insertion will be skipped without any error logs in syslog table. As there is no documentation for cmdb integration studio application definition please provide me assistance in resolving this issue.

Thanks in advance!

[Shalani Rajendr]

Hello @SwathiPedireddy ,

   Thanks a lott. It worked but now the issue is earlier it was a global business rule so it aborted the insertion. Now specific I have written for that robust import transform. There is one more data source where I thought to try the same logic but there was no serial number found. I'll attach the image if you find anything please do help me with that too.

[SwathiPedireddy]

Hi @Shalani Rajendr 

you can try with 'installed_on_sys_id' this is the sys_id of the computer

Thanks,

Swathi

[Shalani Rajendr]

Hello @SwathiPedireddy,

Yes that's how I thought to proceed.

I have written logs to get the value and proceed further. Thanks for your response.

[Shalani Rajendr]

Hello @SwathiPedireddy ,

I tried the above code with logs the logs works fine but still the records get inserted into cmdb_sam_sw_instalk table. I tested again today I'm facing this issue with the code which I have accepted as solution.

[SwathiPedireddy]

Hi @Shalani Rajendr 

Are you sure they are from the Computer Data Source and not from Software Data Source,please share screenshot of the script.

Thanks,

Swathi