Hello,
Does anybody have a sql query for calculating SLA ticket closure time they would be willing to share, I could use as a template.
I want to take ticket solution time (ticket.create_time - ticket.change_time) and subtract time period ticket is in certain states.
I am using a vanilla install of OTRS 4.0.3 and my sql skills are struggling to create a query which works. I need to implment intially for a 24/7 calender and then a office hours calender.
Thank you.
[SOLVED] sql query for SLA calculation
Moderator: crythias
[SOLVED] sql query for SLA calculation
Last edited by numerouno on 15 Jan 2015, 07:25, edited 1 time in total.
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: sql query for SLA calculation
Try this thread: viewtopic.php?t=14242
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask