Time tracking by agent on same ticket

Moderator: crythias

Locked
kmdot
Znuny newbie
Posts: 68
Joined: 16 Dec 2010, 18:46
Znuny Version: 3

Time tracking by agent on same ticket

Post by kmdot »

Hi

Is it possible to track the time spent on a ticket when multiple agents are adding times?

Each ticket may be passed to 2 or 3 agents, and each will add times.

I need to know what agent spent what time on the ticket in some sort of report rather than just making a note. need stats =)

Thanks
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Time tracking by agent on same ticket

Post by jojo »

yes, you can get this information 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
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Time tracking by agent on same ticket

Post by crythias »

You may start thinking about an ArticleFreeTextField
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
kmdot
Znuny newbie
Posts: 68
Joined: 16 Dec 2010, 18:46
Znuny Version: 3

Re: Time tracking by agent on same ticket

Post by kmdot »

I have added fields

billable time and agent name to a note.

Now how can i make a report that does this.

Report by ticket id, and under id get a list of "billing notes"?

thanks
dwg
Znuny newbie
Posts: 17
Joined: 08 Jun 2011, 07:08
Znuny Version: 3.08

Re: Time tracking by agent on same ticket

Post by dwg »

I hope resurrecting an old post is not in bad taste.

This is EXACTLY what I am trying to figure out.... let an agent plug in their time with each note they add to a ticket. We bill hourly for services and this would be a wonderful way to track it. Why make the agent go to a separate billing system or to the TimeAccounting module to re-enter what they have done. This (dual-entry) inevitably leads to lost billing.

It is easy to accomplish the entry... just add an articlefreetext to the note.

The hard parts are:
1. How to report on this time?
2. How to track which entries have already been billed?
3. How to go back to make a change to an article when necessary.

Will this all need to be done through SQL or is there a more appropriate way?
ATG
Znuny newbie
Posts: 3
Joined: 19 Jun 2012, 13:18
Znuny Version: 3.1.6

Re: Time tracking by agent on same ticket

Post by ATG »

Hi guys,

This is exactly what we are trying to achieve as well.

Did you get any further with this?
Locked