@atul_05 Then you can create this as a scheduled job and run on a daily basis. This way the ticket will get updated on a daily basis.
Here is the filter I created for the script on the task table.
Here is the script I wrote to fix the records.
var glideTask = new GlideRecord('task');
glideTask.addEncodedQuery('active=true^sys_class_name=problem^ORsys_class_name=incident^ORsys_class_name=sc_task^ORsys_class_name=sc_req_item^assigned_to.active=false');
glideTask.query();
while(glideTask.next()){
glideTask.setValue('assigned_to','');
glideTask.update();
}
You can put this script inside a fix script or a scheduled job.
Please make sure to test this script on a non prod instance first, verify the result and then run it on a prod instance.
Please mark the response helpful and accepted solution if it managed to address your question.
@atul_05 Then you can create this as a scheduled job and run on a daily basis. This way the ticket will get updated on a daily basis.
Here is the filter I created for the script on the task table.
Here is the script I wrote to fix the records.
var glideTask = new GlideRecord('task');
glideTask.addEncodedQuery('active=true^sys_class_name=problem^ORsys_class_name=incident^ORsys_class_name=sc_task^ORsys_class_name=sc_req_item^assigned_to.active=false');
glideTask.query();
while(glideTask.next()){
glideTask.setValue('assigned_to','');
glideTask.update();
}
You can put this script inside a fix script or a scheduled job.
Please make sure to test this script on a non prod instance first, verify the result and then run it on a prod instance.
Please mark the response helpful and accepted solution if it managed to address your question.
