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.
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.
____________________________________ Assign Kudo, if found post useful and mark it accepted if solves the 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