Populate "Datasource History" table with SCCM Integration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-19-2020 08:22 AM
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?
- Labels:
-
Discovery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-28-2020 08:19 AM
I'm not sure I follow this--why an insert on alm_asset?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-07-2020 02:01 PM
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.