Schedule job to close Incidents

[sanathk]

Hello Community,

I have a requirement; I need to auto close the incidents which are not updated in last 30 days through schedule job which should run every day. can someone please help me with the code for this?

Thanks & regards,

Sanath K

[Amit Pandey · Accepted solution]

Hi @sanathk 

I don't think this filter is possible in Flow Designer. You need to write a scheduled job. Sharing the outline of the code-

(function() {
  
    var gr = new GlideRecord('incident');
    gr.addQuery('sys_updated_on', '<', gs.daysAgoStart(30)); 
    gr.addQuery('cmdb_ci.name', 'NOT LIKE', 'ABC%'); 
    gr.addQuery('active', true); 
    gr.query();

    while (gr.next()) {
            gr.setValue('state', 7); 
            gr.update();
    }
})();

Please mark my answer helpful and correct.

Regards,

Amit

[Dr Atul G- LNG]

Hi @sanathk 

You can use the flow for the same.

Some baseline

https://www.servicenow.com/community/csm-forum/how-to-set-the-auto-close-day-once-the-case-is-resolv...

[sanathk]

Hi @Dr Atul G- LNG , Thanks for your valuable response

The above mentioned solution is working fine but here i have a problem in condition i need to add a filter condition "does not start with" can you please guide me how can i achieve this in flow condition?

Thanks,

Sanath K

[sanathk]

Hi @Dr Atul G- LNG , Can you please help me out on this scenario

Thanks,

Sanath K

[Amit Pandey]

Hi @sanathk 

You can create another filter by clicking on AND and then select the field you want to choose does not start with in trigger section.

Regards,

Amit