Populate "Datasource History" table with SCCM Integration

Gaetano De Mitr
ServiceNow Employee
ServiceNow Employee

Hello to all,

I need to populate the cmdb_datasource_last_update table when a Computer is created by SCCM integration, since not populating this table (cmdb_datasource_last_update), the rules of Datasource Precedence and Reconciliation Definitions do not work. As a better approach, what do you recommend:

  • Create an onBefore Transform script on the following SCCM Transform "SCCM 2012 v2 Computer Identity", using the IRE API, or
  • do an insert BR, "onAfter" on the cmdb_ci_computer table that populates the records in the "cmdb_datasource_last_update" table by setting Datasource = SCCM?

My aim is to give SCCM absolute priority over Computers (Workstations) on any field

Furthermore, since to date there are already Computers created by SCCM but without recond in the "Datasource History" table, I imagine an initial remediation should be done on the AS-IS.

Do you agree?

16 REPLIES 16

I'm not sure I follow this--why an insert on alm_asset?

Patrick DeCarl1
ServiceNow Employee
ServiceNow Employee

Hey Gaetano, check out post I just made. https://community.servicenow.com/community?id=community_article&sys_id=e7202b51dbc4585c13b5fb2439961...

 

I think this solution will help you.