Find Open Incidents which with no updates for last 30 days and closes them (without Encoded Query).

[harshchaudh]

var grd = new GlideDateTime("2025-07-21");

grd.addDays(-30);

grd.query();

var gr = new GlideRecord("incident");

gr.addQuery('sys_updated_on','<',grd);

gr.query();

while(gr.next()){

if(gr.state!='7'){

gr.setValue('state','7');

gs.info(gr.number);

}

}

i write this code can anyone please help me to correct this code ?? as it worked but doesnot change the state to closed of some incidents IDK why?

[Ankur Bawiskar]

@harshchaudh 

there is an OOTB data policy which blocks INC from update when State = 7

So you should set Resolution notes and Resolution code while updating

var grd = new GlideDateTime("2025-07-21");

grd.addDays(-30);

grd.query();

var gr = new GlideRecord("incident");

gr.addQuery('sys_updated_on', '<', grd);

gr.query();

while (gr.next()) {

    if (gr.state != '7') {

        gr.setValue('state', '7');

        gr.close_code = 'Solution provided';

        gr.close_notes = 'Closed via script';

        gs.info(gr.number);

    }

}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[harshchaudh]

It didn't worked.

[Ankur Bawiskar]

@harshchaudh 

it should work.

please share what didn't work.

You mentioned it's not getting updated so I assumed your filter and query is fine

Remember closing incident requires those 2 fields to be updated and hence I updated those while updating the record.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Chaitanya ILCR · Accepted solution]

Hi @harshchaudh ,

try this

var grd = new GlideDateTime("2025-07-21 00:00:00");

grd.addDays(-30);

grd.query();

var gr = new GlideRecord("incident");

gr.addQuery('sys_updated_on', '<', grd);

gr.query();


if (gr.next()) {

    if (gr.state != '7') {

        gr.setValue('state',7);
        gr.setUseEngines(false);
		gr.setWorkflow(false);
		gr.update();

        gs.info(gr.number);

    }

}

why not use the Update JOB (no code approach)?

https://www.youtube.com/watch?v=5jZmZS6tb1I

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya