SGC - AWS to stop populating the Image table (cmdb_ci_os_template)

[ThenmozhiA]

Need help  to stop populating the image class table by AWS connector. It brings many records  (we have 50k records) into the table which arent used by the CMDB team. I tried to disable the import schedules - sg-aws- image id and sg-aws-image- private. But i found many import schedules populates the image class. Is there a way to stop populating the image class?

[Hanna_G]

Hi @ThenmozhiA 

I'd do this through the ServiceNow IRE rules. You can create a data source rules to prevent discovery sources from populating different classes. Either prevent insert, prevent update or both.

Here are the ServiceNow docs:

Configuring CMDB Identification and Reconciliation

[ThenmozhiA]

Hi Hanna,

Thanks for the suggestion I have already added the IRE data source rule and added BR to stop updating the image table.  But it isnt working. I have attached the BR, please review and let me know if any changes required? Do we need to change anything in the ETL definitions. 

[Will O]

If you need to prevent a specific data source from creating records on a table, you can create an IRE data source rule. 

As an example, I created an IRE data source rule to prevent the JAMF Service Graph Connector from creating records on the cmdb_ci_printer table; it could still update them (that's where Data Reconciliation Rules come in) but it was previously creating Printer CIs that were unnecessary.

Create an IRE data source rule