Impact, Urgency and Priority Mapping on Incident From

RAHUL Khanna1
Mega Guru

Hi Guys, 

---I have added an extra option for impact and urgency (1-Critical), the mapping was adjusted in the dl_u_priority table with a custom matrix.

---Till here it is fine, Now I have to revert the changes and bring it to original mapping, So I have de-activated the newly created choices in impact, urgency and priority look up table also.

--when I have done above changes, I am finding the below issue.

 

find_real_file.png

Any work-around available for above.

 

6 REPLIES 6

Community Alums
Not applicable

The data lookup definitions have a "Run on Update" option. You could run a background script on incident table and update all the incidents once, it should reset the Priority based on the look up matrix.

Before running the script on whole table, I would suggest testing the script with few records to avoid errors.

var gr = new GlideRecord('incident');
gr.addEncodedQuery("priority=1"); //copy your query from the table filter and paste here.
//gr.setlimit(3);
gr.query();
while(gr.next())
{
gr.update();
}

 

If my reply helped with your issue please mark helpful 👍 and correct if your issue is now resolved.
By doing so you help other community members find resolved questions which may relate to an issue they're having.

 

Thanks,

Debopriya

Hmm....Actually I wanted to avoid it because.........

 

1) Currently in PROD we have New Mapping (with extra values).

2) Now in sub-prod environment, As I have reverted the mappings I am seeing the issue.

3) --->As soon as   I move the changes to PROD ......the values gets changed

--------DO you think, Any SLA's, Notofications, Business rules will trigger because of above changes.

 

4) on top of it ...if I ran the Background script ----> again point 3 , ofocurse we can make set workflow false and try to cotrol few things, but SLA's Notofication can we control.

Can you analyse above .....and try to guess the impact with the above changes.