Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..
670 views

SLA/Holiday issue

Dear Experts,

 

I have an issue.

Sometimes we have unexpected holiday that is not in the calendar. When I add it to the holiday table, the problem is that the tickets/SLAs are not updated. What we need to do is to update all the open tickets so that the clock is reflected.

 

What can I do about it?

Has anyone faced the same issue?

 

Please let me know.

 

Thanks

0 Likes
7 Replies
Highlighted
Absent Member.
Absent Member.

Re: SLA/Holiday issue

Hi,

Yes they will not be updated as it will capture only at time of logging or addition of sla alerts.

hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Highlighted
New Member.

Re: SLA/Holiday issue

Hi,

We have the same issue.

I know is 'around  this',
Open Database manager ->
(which form) ? ->
(which Table) ? ->
x Administration mode ->
Search ->

but can some charitable old soul please explain how can i mass update all opened ticket?

thank you.




0 Likes
Highlighted
Absent Member.
Absent Member.

Re: SLA/Holiday issue

Hi,

It is not recommended option to mass update all the existing tickets as his might lead to huge event-out and notifications, depending on tikes and customization in your environment. Also do not feels that mass update of problem tickets or sla records will help.


Any way if you are sysadmin and mass update is enabled in operator profile or corresponding fc then just search the table using db and you will get the mass update visible. OR check 'Administration mode' box in db before search of table.


hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: SLA/Holiday issue

Well... I think if you try to update all the tickets by performing mass update... as Piku said it will generate eventout & notifications will be triggered.

What I think is to create a script & execute it from script library... The SLA will be updated but no eventout will be created & no notifications will be sent.
0 Likes
Highlighted
New Member.

Re: SLA/Holiday issue


Well, that's well put, i do not want eventout, and notifications sent again... 🙂

Piku,
I do not want to mass update all the existing tickets, only the ones that are 'open' or with a status that have associated a running SLA so they 'read' get updated with the new holidays... does that make sense(?)
thank you

ulto1,
Can you give some clue to start from script library?
thank you

0 Likes
Highlighted
Valued Contributor.
Valued Contributor.

Re: SLA/Holiday issue

hello, 

i am facing this issue with SM 9.4 were you able to find a solution ?

0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: SLA/Holiday issue

This should not be a problem since at every save the times should be recalculated based on actual data.
An possible alternative solution to mass update is create a script that calls sla.change.state.wrapper to all open tickets. To check the parameters you can save your record and check the schedule table for sla class. You will see the call to the "sla refresh".. unless your system has online SLA calculation.. In this case you can disable it just to make this test and get the proper parameters.

I never did it this way but I see no reason to not work.
Regards,
Breno Abreu

If you feel this was helpful please click the KUDOS! thumb below!
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.