Hi Dave,
thanks for answer:
I create an Import Set table (with releated REST api to create record on the table),
I attached a Transform map to the Import Set with "On Before" scripted:
(function runTransformScript(source, map, log, target) {
// Call CMDB API to do Identification and Reconciliation of current row
var cmdbUtil = new CMDBTransformUtil();
cmdbUtil.setDataSource('MySource1'); //This is the name you added in the step above.
cmdbUtil.identifyAndReconcile(source, map, log);
ignore = true;
if (cmdbUtil.hasError()) {
var errorMessage = cmdbUtil.getError();
log.error(errorMessage);
} else {
log.info('IE Output Payload: ' + cmdbUtil.getOutputPayload());
log.info('Imported CI: ' + cmdbUtil.getOutputRecordSysId());
}
})(source, map, log, target);
When the Import Set WS is called the record on CMDB is created or updated following the current Identification and Reconciliation rule configurated on the ServiceNow instance, but the WS answer me with the same response:
{
"import_set": "ISET0010004",
"staging_table": "u_cmdb_ci_mysource1_staging",
"result": [
{
"transform_map": "TransformMapName",
"table": "cmdb_ci_server",
"status": "error",
"error_message": "Target record not found",
"status_message": "Row transform ignored by onBefore script"
}
]
}
I guess it's happening because there is ignorance to true (which is strictly recommended by the docs .. otherwise it doesn't work properly)
SN docs: https://docs.servicenow.com/bundle/newyork-servicenow-platform/page/product/configuration-management...
The Data Source that call the ServiceNow WS to import CI,expect the response in a format like this:
{
"ServerName" : "ServerName_Created_or_Updated",
"Status" : "Updated / Created"
}
Furthermore...
When the CI is previously discovered (and therefore with Discovery Source = ServiceNow), the Discovery Source field changes from "ServiceNow" to "MySource1", and I cannot see it on Discovery Schedule report as Discovered CI.
This no longer allows me to check whether a particular CI has actually been previously discovered except by using the Last discovere date column.
I should have more evidence of CI discovered by discovery but updated from other sources (as in my case). Is OOTB possible? Or do I have to create a custom report?
Best regards,
Gaetano
