Closure of change request with inactive/no change task

[Annirnita Dash1]

Hi All,

I have a request where I have to add few filters and mark change request as closed.

Conditions are:

All those change request which are not updated from 10 days.

there are no active change task under it, or they have no change task at all.

All such change where multiple ctasks are there with some active and some inactive shall be ignored. Only those with all inactive ones will be considered.

I tried gliding to ctask, checking with all filters , but confused with how to check for changes without a change task.

[Dr Atul G- LNG]

Hi @Annirnita Dash1 

I have no idea how this can be done, but you can create a report for same upto some extent as per my experience

[Annirnita Dash1]

@Dr Atul G- LNG , thanks for the reply.

I have to mark this change as closed, so report will only give me data.

[Dr Atul G- LNG]

Hi @Annirnita Dash1 

Yes correct, report will give only data. Might be use that data in flow to close teh changes.

[Runjay Patel · Accepted solution]

Hi @Annirnita Dash1 ,

You can create a schedule job and set run as daily.

Use below script to close the change based on your condition.

var gr = new GlideRecord('change_request');
gr.addEncodedQuery('sys_updated_onRELATIVELT@dayofweek@ago@10');
gr.query();
while (gr.next()) {

    var gr2 = new GlideRecord('change_task');
    gr2.addEncodedQuery('change_request=' + gr.sys_id + '^active=true');
    gr2.query();
    if (!gr2.next()) {

        gr.state = 3;
        gs.setWokflow(false);
        gr.update();
    }


}

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------