SCCM Graph Connector- Empty Source Field and Colease - Robust Transform Map

[Abish]

Hi 

I am working on Service Graph Connector for Microsoft SCCM plugin. In the Robust transform map I see the below mapping.

Question 1 :The source field is empty and I am not sure how this value will be picked up?

 

Question 2 : Also I see the colease field (Use unique Input set field) is set to u_multi_instance_computer_snk field which in turn is mapped to disk-computer.source_native_key. But I am not able to find "disk-computer.source_native_key" in the target table.

Does any one has the colease field list for the SGC-SCCM Robust Transforms?

Thanks and Regards

Abish R

[#2 · Accepted solution]

Question 1 :The source field is empty and I am not sure how this value will be picked up?

• Source native key is a field used by the IRE for identification by populating the sys_object_source table.  This field represents a unique identifier out of the source system.  In SCCM's case this is a jdbc connection to a database.  This value is populated by the connection id, device id, and resource id.  Connection id comes from the ServiceNow connection while device id and resource id are database indexes in SCCM.  There is no situation where this will result in an empty value:

Question 2 : Also I see the colease field (Use unique Input set field) is set to u_multi_instance_computer_snk field which in turn is mapped to disk-computer.source_native_key. But I am not able to find "disk-computer.source_native_key" in the target table.

• As mentioned in the response to question 1, the source native key field is not on the target cmdb class but rather in sys_object_source.  Please read up here for some more information.

[Abish]

Thanks a lot for the reply. So whenever we leave the source field empty then it is going to pick the Sys ID of the record(like source_native_key mapping sys id)?

I have one more query. I am trying to write On Before, On After scripts. I am not able to find action keyword on it. Do you have any example scripts for OnBefore and OnAfter scripts in Robust Transform?

Thanks and Regards

Abish R

[#4]

So whenever we leave the source field empty then it is going to pick the Sys ID of the record(like source_native_key mapping sys id)?

• As mentioned previously, in the case of SCCM disk the source native key will never be empty.  Source native key in general should always have a value from the 3rd party system.  It will never use the sys_id as that is only determined after the IRE matches.

I am trying to write On Before, On After scripts. I am not able to find action keyword on it. Do you have any example scripts for OnBefore and OnAfter scripts in Robust Transform?

• What are use case are you trying to solve for?  The on before/after scripts are fairly well documented on the cmdb_inst_application_feed table.

[Abish]

Hi Jgates,

I have custom fields I want to populate. And also there are custom scripts which have custom logic which I want to put it on the before /after scripts. (Similar to ones on Transform scripts on transform map).

Example: When manufacturer and model is not found then we should skip the record from inserting and create an incident. 

Thanks and Regards

Abish R