Hello all,
Though its an old post but wanted to provide some more info to help others.
Problem Statement:
Populate various CMDB Classes from multiple data sources e.g. Airwatch, ADDM, JSS etc.. Most of them are having REST WS, and need a way to schedule the population of CIs through an import set while we need to keep track of CIs being populated from which DS.
Solution:
1. Get CIs from different REST WS to populate Import Set tables. We have 3 import sets for 3 different Data Sources
2. Associate the import sets with transform maps according to CI classes
3. In the onBefore transform script instead of using ServiceNow's original "CMDBTransformUtil" code snippet use below code snippet
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
// Add your code here
var cmdbUtil = new MyCMDBTransformUtil("JSS_import");
cmdbUtil.identifyAndReconcile(source, map, log);
ignore = true;
})(source, map, log, target);
4. Add a SI named MyCMDBTransformUtil which would act as a wrapper class of OoB CMDBTransformUtil,
var MyCMDBTransformUtil = Class.create();
MyCMDBTransformUtil.prototype = Object.extendsObject(CMDBTransformUtil, {
initialize: function(prm_sDISCOType) {
this.transformTable = "sys_transform_entry";
this.ds = prm_sDISCOType;
this.JSON = new JSON();
this.json = this.JSON;
this.CmdbAPI = SNC.IdentificationEngineScriptableApi;
this.dataSource = this.ds;
this.transformEntryTable = this.transformTable;
},
// Identify and Reconcile given source record and transform map
identifyAndReconcile: function(source, map, log) {
var inputPayload = this.buildInputPayload(source, map);
var outputPayload = this.CmdbAPI.createOrUpdateCI(this.dataSource, this.json.encode(inputPayload));
log.info("Identification and Reconciliation Result: " + outputPayload);
},
type: 'MyCMDBTransformUtil'
});
5. By doing this we are keeping the original class as is and at the same time allowing it to be upgraded in future versions like Istanbul or Jakarta.
6. The CI records would look like below
Note: You have to add the Sources in cmdb_ci.discovery_source field and in the transform map mapping do not map the discovery source field.
Let me know if that helps.
Thanks!
Sudipta
