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

[sanathk]

Hi @Amit Pandey , Thanks for response 

we do not have any filter type as do not start with in filters,

Thanks,

Sanath k

[Amit Pandey]

Hi @sanathk 

So sorry for the oversight. 

You can use Starts with or does not contain instead. Can you write your exact requirement so that I can help you further.

Regards,

Amit

[sanathk]

HI @Amit Pandey , i need to write a schedule job that should close the Incident tickets that are not updated in past 30 days. This one i am trying to achieve through flow scheduled job.

In this i need handle this conditions

1.Incidents are not updated in past 30 days

2.Configuration item should not start with "Ex: ABC"  

and then in update record i closing those fetched records.

[1__AnithaHV]

Hi @sanathk ,

For the question Configuration item should not start with "Ex: ABC" you can use SQL "NOT Like " operator.

gr.addQuery('name', 'NOT LIKE', 'ABC');

Hope this helps you in resolving your issue.

Thanks & Regards,

Anitha H V

[sanathk]

Hi @1__AnithaHV , Thanks for your response ,

I have checked earlier, it will work in scheduled jobs but not in flow 

Thanks,

Sanath K