Hello,
Our agents add the time spent on each ticket/note so a ticket with 5 articles will have some number in time spent entered for each article.
I want to run a report report which will show
Agent name | ticket | time spent
Was not very successful in the stats module
Thank You
Report on time spent by each agent
Moderator: crythias
-
Giulio Soleni
- Znuny wizard
- Posts: 392
- Joined: 30 Dec 2010, 14:35
- Znuny Version: 6.0.x and 5.0.x
- Real Name: Giulio Soleni
- Company: IKS srl
Re: Report on time spent by each agent
Hi,
at least you should activate Stats::UseAgentElementInStats parameter in sysConfig Framework -> Frontend::Agent::Stats
Then you may use "accounted time" attribute for your purposes.
Giulio
at least you should activate Stats::UseAgentElementInStats parameter in sysConfig Framework -> Frontend::Agent::Stats
Then you may use "accounted time" attribute for your purposes.
Giulio
OTRS 6.0.x on CentOS 7.x with MariaDB 10.2.x database connected to an Active Directory for Agents and Customers.
ITSM and FAQ modules installed.
ITSM and FAQ modules installed.
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Report on time spent by each agent
viewtopic.php?f=60&t=12546
Note that this old query doesn't reflect 3.2+ DynamicFields, but otherwise might be useful.
Note that this old query doesn't reflect 3.2+ DynamicFields, but otherwise might be useful.
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