Hi guys,
How can I track the I agents performance, according to the Ticket created, TIcket solved, Ticket excalated, and etc.
Thanks!
[SOLVED]SQL query to track Agent work
Moderator: crythias
-
immaBeans
- Znuny newbie
- Posts: 37
- Joined: 30 May 2013, 03:36
- Znuny Version: 3.2.2
- Real Name: Vince
- Company: Jollibee Worldwide Service
[SOLVED]SQL query to track Agent work
Last edited by immaBeans on 26 Jul 2013, 09:29, edited 1 time in total.
Re: SQL query to track Agent work
some SQLs can be found here: http://wiki.otterhub.org/index.php?titl ... generators
"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
-
immaBeans
- Znuny newbie
- Posts: 37
- Joined: 30 May 2013, 03:36
- Znuny Version: 3.2.2
- Real Name: Vince
- Company: Jollibee Worldwide Service
Re: SQL query to track Agent work
but how can i track, the time when ticket open and ticket was closed.
like that.
And some of the SQL do not work for me
like that.
And some of the SQL do not work for me
-
Navidlo
- Znuny newbie
- Posts: 10
- Joined: 16 Jul 2013, 11:49
- Znuny Version: 3.2.9
- Real Name: Ivan
- Company: X-Net
Re: [SOLVED]SQL query to track Agent work
Try replace ${INTERVAL} with 1 MONTH or 1 YEAR or 1 WEEK or 1 DAY
Navidlo
Navidlo
OTRS 3.2.9, ITSM 3.2.7, FAQ on CentOS 6.2 with Mysql 5.1