Enhancement on Auto Population of Dynamic CIs in the Affected CI on Change Request form

[Community Alums]

Hello Developers,

The functionality of dynamic ci has been enhanced. According to my development, when a user selects a configuration item on a change form with the specific class to "Dynamic CI Group," I am able to populate a group of CIs from the table "Cmdb Group Contains Configuration Items" into the related list  "Affected CIs" on the change table.

Solution as below:

Business Rule: After Insert/Update

Table Name: change_request

Condition: 1. Configuration Item is not Empty   AND

Condition: 2. Configuration Item.class is Dynamic CI Group

Priority: 50

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
    var ci = current.cmdb_ci;
    //var ciname = current.cmdb_ci.getDisplayValue();
    var gr1 = new GlideRecord("cmdb_ci_query_based_service");
    gr1.addQuery('sys_id', ci);
    gr1.query();
    if (gr1.next()) {
        var groupName = gr1.cmdb_group;
        gs.addInfoMessage("CI Group Name is " + groupName);
        var gr2 = new GlideRecord("cmdb_group");
        gr2.addQuery('sys_id', groupName);
        gr2.query();
        if (gr2.next()) {
            var gr3 = new GlideRecord("cmdb_group_contains_ci");
            gr3.addQuery('group', gr2.sys_id);
            gr3.query();
            while (gr3.next()) {
               
                var gr4 = new GlideRecord("task_ci");
                gr4.initialize();
                gr4.ci_item = gr3.configuration_item;
                gr4.grp=gr3.group;
                gr4.task = current.sys_id;
                gr4.insert();
            }

        }

    }


})(current, previous);

If you find this article useful, kindly mark it as helpful or bookmark it.

Best Regards,

Namrata Ghorpade