To check checkboxes based on field values

[Poorva Bhawsar]

Hi Community,

When user selects some variables values as approved from the dropdowns on catalog task, i want to check some checkboxes on the cmdb_ci form.

For e.g., if xyz is selected as approved from the dropdown list, then it should check xyz checkbox on the cmdb_ci form before closing the request.

Thanks

[Anil Lande]

Are you getting logs for Server CIs?

[Poorva Bhawsar]

Server cis are working fine. But database one is not working.

[Poorva Bhawsar]

@Anil Lande can you please help me with the database part?

For database, i have a variable set which is a multi row variable set with 2 variables in it.

1. A reference field.

2. Multi line text field.

When user selects a ci from this reference field. It should update the checkboxes in cmdb_ci table.

Here is the else if part.

else if (current.variables.oat_type == 'Database') {

    var server = [];

    var mrvsParsed = JSON.parse(current.variables.doat_server_details.toString());

    for (var x in mrvsParsed) {

        server.push(mrvsParsed[x].server_name.toString());

    }

    //var server = current.variables.doat_server_details.server_name.toString();

    gs.log("OAT Type: Database, Server Name: " + server, "YourScriptName");

    workflow.info("OAT Type: Database, Server Name: " + server);

    var gr1 = new GlideRecord('cmdb_ci');

    //gr1.addQuery('name', server);

    gr1.addEncodedQuery('sys_idIN' + server.toString());

    gr1.query();

    while (gr1.next()) {

        if (current.variables.privilaged_account_onboarded_to_piam_confirmation_approval == 'accept') {

            //gr1.u_tpam == true;

            gr1.setValue('u_tpam', true);

        }

        if (current.variables.database_onboarded_to_siem_confirmation_approval == 'accept') {

            //gr1.u_siem == true;

            gr1.setValue('u_siem', true);

        }

        if (current.variables.cis_scan_nessus_scan_passed_confirmation_approval == 'accept') {

            //gr1.u_nessus == true;

            gr1.setValue('u_nessus', true);

        }

        if (current.variables.ds_am_av_and_network_protect_with_ips_policy_is_set_to_prevent_or_ms_defender_installed == 'accept') {

            //gr1.u_av_am_ips == true;

            //gr1.u_xdr == true;

            gr1.setValue('u_av_am_ips', true);

            gr1.setValue('u_xdr', true);

        }

            gr1.update();

            gs.log("Updated your_multiline_text_variable_set_table record for Database - Sys ID: " + gr1.sys_id, "YourScriptName");

            workflow.info("Updated your_multiline_text_variable_set_table record for Database - Sys ID: " + gr1.sys_id);

        }

    }

[Anil Lande · Accepted solution]

Hi,

it was not working because you changed the variable names for GlideRecord (you were using 'grCI' it should be 'gr1')

Try below:

else if (current.variables.oat_type == 'Database') {

    var server = [];
    var mrvsParsed = JSON.parse(current.variables.doat_server_details.toString());
    for (var x in mrvsParsed) {
        server.push(mrvsParsed[x].server_name.toString());
    }
    //var server = current.variables.doat_server_details.server_name.toString();
    gs.log("OAT Type: Database, Server Name: " + server, "YourScriptName");
    workflow.info("OAT Type: Database, Server Name: " + server);
    var gr1 = new GlideRecord('cmdb_ci');
    //gr1.addQuery('name', server);
    gr1.addEncodedQuery('sys_idIN' + server.toString());
    gr1.query();
    while (gr1.next()) {
        if (current.variables.privilaged_account_onboarded_to_piam_confirmation_approval == 'accept') {
            //gr1.u_tpam == true;
            gr1.setValue('u_tpam', true);
        }
        if (current.variables.database_onboarded_to_siem_confirmation_approval == 'accept') {
            //gr1.u_siem == true;
            gr1.setValue('u_siem', true);
        }
        if (current.variables.cis_scan_nessus_scan_passed_confirmation_approval == 'accept') {
            //gr1.u_nessus == true;
            gr1.setValue('u_nessus', true);
        }
        if (current.variables.ds_am_av_and_network_protect_with_ips_policy_is_set_to_prevent_or_ms_defender_installed == 'accept') {
            //gr1.u_av_am_ips == true;
            //gr1.u_xdr == true;
            gr1.setValue('u_av_am_ips', true);
            gr1.setValue('u_xdr', true);
        }
            gr1.update();
            gs.log("Updated your_multiline_text_variable_set_table record for Database - Sys ID: " + gr1.sys_id, "YourScriptName");
            workflow.info("Updated your_multiline_text_variable_set_table record for Database - Sys ID: " + gr1.sys_id);
        }
    }

[Poorva Bhawsar]

Thank you for the quick solution.