• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

change max resolution date
#1
I would like to extend the SLAs (change max resolution date) for incidents and service requests.
Which fields should I modify? Are the modifications made on SD_REQUEST and AM_ACTION?

Thank you for your answer.
Jkonan, proud to be a member of EV CONNECT FORUM since May 2019.

#2
Hello,

In Easyvista, SLA and OLA are in the same menu. Remember that SLA is for request and OLA is for incident:
https://wiki.easyvista.com/xwiki/bin/vie...anguage=fr

If you need to extend an SLA/OLA for, you can use in a business rules or workflow "calculateMaxResolutionDate(Request_ID, Submit_Date, SLA_ID)"
https://wiki.easyvista.com/xwiki/bin/vie...lutionDate

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#3
Thanks ABBE for your quick answer.
I'm not yet comfortable with busness roles so I can't use it now as I have to find a quick solution to change the execution date for about 200 requests.
Jkonan, proud to be a member of EV CONNECT FORUM since May 2019.

#4
(10-11-2019, 06:53 AM)Jkonan Wrote: Thanks ABBE for your quick answer.
I'm not yet comfortable with busness roles so I can't use it now as I have to find a quick solution to change the execution date for about 200 requests.

You could probably update with SQL theses datas...

update sd_request set max_resolution_date_ut=dateadd(dd,+30,submit_date_ut) where rfc_number in ('I191011_0001','I191011_0002')

=> example for adding 30 days to submit_date

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#5
(10-11-2019, 07:24 AM)ABBE Philippe Wrote:
(10-11-2019, 06:53 AM)Jkonan Wrote: Thanks ABBE for your quick answer.
I'm not yet comfortable with busness roles so I can't use it now as I have to find a quick solution to change the execution date for about 200 requests.

You could probably update with SQL theses datas...

update sd_request set max_resolution_date_ut=dateadd(dd,+30,submit_date_ut) where rfc_number in ('I191011_0001','I191011_0002')

=> example for adding 30 days to submit_date

P.ABBE

Ok Thanks a lot.
Jkonan, proud to be a member of EV CONNECT FORUM since May 2019.

#6
(10-11-2019, 08:13 AM)Jkonan Wrote:
(10-11-2019, 07:24 AM)ABBE Philippe Wrote:
(10-11-2019, 06:53 AM)Jkonan Wrote: Thanks ABBE for your quick answer.
I'm not yet comfortable with busness roles so I can't use it now as I have to find a quick solution to change the execution date for about 200 requests.

You could probably update with SQL theses datas...

update sd_request set max_resolution_date_ut=dateadd(dd,+30,submit_date_ut) where rfc_number in ('I191011_0001','I191011_0002')

=> example for adding 30 days to submit_date

P.ABBE

Ok Thanks a lot.

This don't work for in my alert.

UPDATE SD_REQUEST SET MAX_RESOLUTION_DATE_UT = DATEADD(dd,+10,SUBMIT_DATE_UT)

WHERE REQUEST_ID IN (#LIST_ID#)
Jkonan, proud to be a member of EV CONNECT FORUM since May 2019.

#7
(10-11-2019, 02:50 PM)Jkonan Wrote:
(10-11-2019, 08:13 AM)Jkonan Wrote:
(10-11-2019, 07:24 AM)ABBE Philippe Wrote:
(10-11-2019, 06:53 AM)Jkonan Wrote: Thanks ABBE for your quick answer.
I'm not yet comfortable with busness roles so I can't use it now as I have to find a quick solution to change the execution date for about 200 requests.

You could probably update with SQL theses datas...

update sd_request set max_resolution_date_ut=dateadd(dd,+30,submit_date_ut) where rfc_number in ('I191011_0001','I191011_0002')

=> example for adding 30 days to submit_date

P.ABBE

Ok Thanks a lot.

This don't work for in my alert.

UPDATE SD_REQUEST SET MAX_RESOLUTION_DATE_UT = DATEADD(dd,+10,SUBMIT_DATE_UT)

WHERE REQUEST_ID IN (#LIST_ID#)

Hello,
Can you check/post the log Administration/Activities/Logs

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.

#8
Hi ABBE,
thanks for the answer, I used this and it worked:

UPDATE SD_REQUEST SET MAX_RESOLUTION_DATE_UT = '18/10/2018 15:30:00' WHERE REQUEST_ID IN (#LIST_ID#);
Jkonan, proud to be a member of EV CONNECT FORUM since May 2019.






Users browsing this thread: 1 Guest(s)