Hi,
For the purpose of making reports, can you please let me know, how I can I calculate the time for which each ticket was in a particular status.
For Ex: I have three status statusA, statusB, statusC
and I have two tickets in my queue ticket1 and ticket 2.
Now I need to find out, for how much time, ticket1 was in status 'statusB' and time for which ticket2 was in status 'statusB'
Kindly help
Regards
SLA ClocK
Moderator: crythias
Re: SLA ClocK
you need to analyze the ticket_history for this ticket via SQL
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: SLA ClocK
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