Create De-duplicate Task manually by using UI action on list view of CMDB_CI table.

[D_R]

De-duplicate tasks are created when system identifies the duplicate Cis in the discovery process.

In some cases these tasks are not created as expected even though duplicate CI exists.

In a few scenarios clients expecting to create de-duplicate task from the UI action on list view of ''cmdb_ci'' table and this UI action is available to specific group of people.

In Servicenow we have OOTB Script include  ‘’CMDBDeduplicateTaskUtil”, to create duplicate task, however In this case we have to specify the sys_ids of specific Cis and execute every time.

So Instead of taking the sys_ids of the CIs every time and execute, we can create button/list choice UI action on the list view and select the specific CIs from CMDB_CI table, this will be easier to the CMDB team whoever wants to create.

This UI action utilizing the OOTB Script include with few modifications as we have to return with newly created de-duplicate task or error if it finds any.

UI Action name : Create De-duplicate Task, Type: List Choice

Step:1 

Step:2

Step:3

when we click on OK. We'll get the confirmation.

It will navigate to newly created De-duplicate task, shown below.

Step: 4

If the selected CI is already part of open De-duplicate task then it will give error and displays those CIs

Step:5

Step: 6

Client script: 

function getConfigItems() {
var sysIDs = g_list.getChecked().toString();
var sysIdList = sysIDs.split(',');
var con1 = confirm('Total number of Selected CIs ' + sysIdList.length + '. Click OK to create De-duplicate task');
if (con1) {
var ga = new GlideAjax('CMDBtaskCreate');
ga.addParam('sysparm_name', 'createDuplicateTask');
ga.addParam('sysparm_sysids', sysIDs);
ga.getXML(CallBack);
function CallBack(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer == null) {
alert('Failed to create Remediate Duplicate Task. Selected CIs are already part of an open Remediate Duplicate Task');}
else {var url1 = 'reconcile_duplicate_task.do?sys_id=' + answer;
var con = confirm('The De-duplicate task is created. Click OK to redirect to De-duplicate task record');if (con) {
location.href = url1;
}}}}

Thanks,

Mark it helpful if it is.....!!!!!

[Jon Collins2]

Thank you for sharing this; I may try this out actually. In our environment, sometimes IRE fails to catch a duplicate, even when the CI's meet the criteria - I've always wondered if ServiceNow plans to address this or if there is a solid reason why. 

Your manual work around looks like a good help for a larger platform problem. 

[D_R]

Thanks @Jon Collins.

[Community Alums]

Its not working as mentioned in above screen shots. Not giving any message and not creating duplicates. Could you please help with exact code. 

[Les1]

looking for this as well

[NateDickson1]

I have not thoroughly tested this but I was able to get this working with the code below. A few things to note:

• This could be helpful for de-duplicating logical records like Services, Business Applications, etc... since those typically do not use IRE and could have manual duplication.
• Your IRE Rules should be setup to automatically identify duplicates, if you are finding duplicates that are not creating rules make sure to investigate why
• CMDBDuplicateTaskUtils - Global The docs site has examples for running a script across your cmdb based on a value to automatically create duplicates which may also be helpful

UI Action:

Name = Create De-duplicate Task

Client = True

List Choice = True

Onclick = showConfirmationDialog() or whatever you choose as your function name

Script:

function showConfirmationDialog() {
var entries = g_list.getChecked();
var sysIDs = entries.split(',');

var con1 = confirm('Total number of Selected CIs ' + sysIDs.length + '. Click OK to create De-duplicate task');

if (con1) {
alert(sysIDs);
var ga = new GlideAjax('createDuplicateCITask');
ga.addParam('sysparm_name', 'createDeDupTask');
ga.addParam('sysparm_entry_ids', entries);
ga.getXML(getDupTasks);
}

function getDupTasks(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");
if (answer == null) {
alert('Failed to create Remediate Duplicate Task. Selected CIs are already part of an open Remediate Duplicate Task');
} else {
var url1 = 'reconcile_duplicate_task.do?sys_id=' + answer;
var con = confirm('The De-duplicate task is created. Click OK to redirect to De-duplicate task record');
if (con) {
location.href = url1;
}
}
}
}

Script include:

Name = createDuplicateCITask

Client Callable = true

Script:

var createDuplicateCITask = Class.create();
createDuplicateCITask.prototype = Object.extendsObject(AbstractAjaxProcessor, {
createDeDupTask: function() {
var entries = this.getParameter('sysparm_entry_ids');

var dupTaskUtil = new CMDBDuplicateTaskUtils();
var deDupTaskID = dupTaskUtil.createDuplicateTask(entries);

return deDupTaskID;

},

type: 'createDuplicateCITask'
});

[prakritipriyank]

This worked perfectly as expected. Thank You!