Calculate the solution time excluding SLA Pause

Moderator: crythias

Locked
vinesh
Znuny newbie
Posts: 76
Joined: 01 Sep 2012, 09:51
Znuny Version: 5.0.16
Real Name: Vinesh Narayanan
Company: NTS

Calculate the solution time excluding SLA Pause

Post by vinesh »

Hi,

I am using SLA stop for some status and I wanted to calculate the solution time excluding the time ticket was in pause. Can anybody give me the sql query for that?
Top
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:
Contact jojo

Re: Calculate the solution time excluding SLA Pause

Post by jojo »

OTRS does not support to pause a SLA out of the box. Also not all data is stored in the database.
"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
Top
Locked

Return to “General”