Ankur Bawiskar
Tera Patron

Hi,

below script should help

updateRecords();

function updateRecords(){

try{

var ritm = new GlideRecord("sc_req_item");
ritm.addActiveQuery();
ritm.addEncodedQuery("stage!=complete");
ritm.query();
while(ritm.next()){
    //check for active sc tasks
    var taskRec = new GlideRecord('sc_task');
    taskRec.addActiveQuery();
    taskRec.addQuery("request_item",ritm.sys_id);
    taskRec.query();
    if(!taskRec.next()){
        //close requested item
        ritm.stage = "complete";
        ritm.active = false;
        ritm.state = 3; // set to close complete
        ritm.setWorkflow(false); // stop any BR
        ritm.update();
        //close request
        var request = ritm.request.getRefRecord();
        request.active = false;
        request.state = 3;
        request.setWorkflow(false);
        request.update();
    }
}

}

catch(ex){
gs.info('Exception'+ex);
}

}

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader