Updating Identification Rules

[Austin27]

Hi Everyone. 

I have a few questions regarding sccm integration. 

1. The service graph training on ServiceNow Learning says to use the resourceId from SCCM to find existing CIs. However, after doing some research it looks like resourceId isn't really the best choice as it can change in SCCM but service tag won't. This cause duplicates in the sys_object_source database. From reading other community post it seems that resourceId isn't really the best one to use as a unique identifier either and should be using something like serial number. Would it be recommended to update the identification rule to set the id in the sys_object_source table to be serial_number? 

2. I have a couple hundred assets that have been created. However, no ci was added into the configuration field value. I've crossed referenced a few and saw that they do exist in the cmdb which looking at serial and names. How would I track these down to figure out the logic on why the configuration item value didn't get populated on the asset table? 

3. I saw ServiceNow has an IntegrationHub ETL plugin. I did download it and looked at it but wasn't for sure if this replaces the robust transforms that are currently setup within ServiceNow. If I use the ETL plug, then do I need to change anything on the robust transform? 

Thank you!

Austin 

[AJ-TechTrek · Accepted solution]

Hi @Austin27 ,

Refer the below response, might be this will helpful

1.I agreed, sometimes correlation ID will not be unique for SCCM case, you can use the Serial Number and Asset tag and change the Identification rule if you did the analysis and found thats the causing, there is no harm to update the IRE rules.

2. Check the Model and Model category where Asset is there but CI not created, Might be some issue on the Mapping.

3. Yes , ETL hub integration best. You can change the Mapping and review the all mapping from there as well, If you change the mapping through ETL- Hub , there is no need to change from Robust transform map, It is alternative to get the clear mapping understanding whose having issue with Robust Transform maps.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thank You

AJ - TechTrek with AJ

Linkedin:- https://www.linkedin.com/in/ajay-kumar-66a91385/

YouTube:- https://www.youtube.com/@learnitomwithaj

ServiceNow Community Rising Star 2024

[Austin27]

Thanks for taking the time to reply. I haven't tried to update the mapping yet but thanks for confirming that I was heading down the correct path. Hope you have a good rest of the week! 

Thank you.

Austin