SCCM Service graph connector field mapping

[Steve Stivers1]

I am replacing the old SCCM integration with the SCCM Service Graph connector. We have a field we have been populating using a modification to the old tool. It only populates a particular CI (cmdb_ci_computer) field if that field is empty. If the field already has a value it will not be changed. This is only done for that single field.

I am trying to figure out how to make that one field update conditional on the current value in the CI.

[#2]

You may want to look into the IRE's reconciliation rules.  You should be able to accomplish what you want by creating a new reconciliation rule.

Service Graph connectors forumulate a payload to send to the IRE so there isn't knowledge of the target CI during the transformation and mapping stage.  You could use a lookup operation on sys_object_source to get the target CI but that will only grab the target CI after the first run.  From there you could script out logic to either pass an empty string to your target field or some other value.  I would suggest you look at reconciliation rules first as those will be more performant.

[VivekSattanatha]

Hi Steve,

You need to look at the Robust Import set Transformers (sys_robust_import_set_transformer) where you have the logic of transformation.

The transformer definition would be having detailed field mapping. To know more about robust transform maps look below

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/concept/robust-import-set-transformers.html

Regards,

Vivek

[kalyani8]

Hi Steve,

Install integration HUB ETL which is the best editor to view and modify field mappings.

Open the respective data source in IntegrationHub ETL and right click on the attribute you want to modify the logic for.

use script action and write the script for your requirement.

Follow below product documentation from servicenow. Refre to section 'Preview and prepare data'

https://docs.servicenow.com/bundle/rome-servicenow-platform/page/product/configuration-management/co...

[CMDB Whisperer]

I concur with this.  However, an important tip: modifications to the out of box Service Graph Connectors and ETL Applications are not accurately captured in Update Sets, and even manually capturing the updates doesn't tend to work out as hoped.  So you will likely need to make the modifications independently in each instance!  So make sure you document your changes in detail outside the platform so you can make them reliable in each manual implementation.