Script is Retuning Results but when passing to the Query to update only one record being updated

[Derek28]

Hi,

I need to be able to query the cmdb_rel table via an on Demand Scheduled job/script.  This will return some relationships based on the query and then, I want to check for those Services and update them in the Service Table.

The current script below, returns the correct number of results from the query, but its only updating the first service it finds.

Any help would be greatly appreciated.

var filterQuery = 'parent.sys_class_name=cmdb_ci_server^parent.operational_status=1^type=4afd799338a02000c18673032c71b817';

var gr = new GlideRecord('cmdb_rel_ci');
gr.addEncodedQuery(filterQuery);
gr.query();

while (gr.next()) {

//check results

gs.log("Records: " + gr.getRowCount() + " CI ID: " + gr.child.sys_id.toString());

}

var gr2 = new GlideRecord('cmdb_ci_service');
gr2.addQuery('sys_id', gr.child.sys_id.toString()); //we only want to update the records found in the search above
gr2.query();
while (gr2.next()) {
gr2.setValue('u_field', 'Yes');
gr2.update();
}

Sample Results being returned below

*** Script: Records: 270 CI ID: b7f842641be4415420fa4196b04bcb44
*** Script: Records: 270 CI ID: 06f343fb1bd08914d8164043b24bcb4b
*** Script: Records: 270 CI ID: 13044ffb1bd08914d8164043b24bcb29
*** Script: Records: 270 CI ID: bb3987b71b94c91420fa4196b04bcbb3
*** Script: Records: 270 CI ID: 1a048bfb1bd08914d8164043b24bcbd7
*** Script: Records: 270 CI ID: e9044bfb1bd08914d8164043b24bcb17
*** Script: Records: 270 CI ID: 240447fb1bd08914d8164043b24bcbaf
*** Script: Records: 270 CI ID: b4f3cfbb1bd08914d8164043b24bcb5f
*** Script: Records: 270 CI ID: 01f3cfbb1bd08914d8164043b24bcbfc
*** Script: Records: 270 CI ID: 7df343fb1bd08914d8164043b24bcb17
*** Script: Records: 270 CI ID: bff842641be4415420fa4196b04bcb60
*** Script: Records: 270 CI ID: 75f303fb1bd08914d8164043b24bcbd9
*** Script: Records: 270 CI ID: d9f303fb1bd08914d8164043b24bcb2a
*** Script: Records: 270 CI ID: 1a04cbfb1bd08914d8164043b24bcb23
*** Script: Records: 270 CI ID: 13044ffb1bd08914d8164043b24bcb29
*** Script: Records: 270 CI ID: b7f842641be4415420fa4196b04bcb44S

[Amit Gujarathi · Accepted solution]

HI @Derek28 ,
I trust you are doing great.
Here's how you can modify your script:

var filterQuery = 'parent.sys_class_name=cmdb_ci_server^parent.operational_status=1^type=4afd799338a02000c18673032c71b817';

var gr = new GlideRecord('cmdb_rel_ci');
gr.addEncodedQuery(filterQuery);
gr.query();

while (gr.next()) {
    // Log each record
    gs.log("Records: " + gr.getRowCount() + " CI ID: " + gr.child.sys_id.toString());

    // For each CI ID found, update the corresponding service
    var gr2 = new GlideRecord('cmdb_ci_service');
    gr2.addQuery('sys_id', gr.child.sys_id.toString());
    gr2.query();
    while (gr2.next()) {
        gr2.setValue('u_field', 'Yes');
        gr2.update();
    }
}

[Derek28]

Thank you very much @Amit Gujarathi that is updating as expected!