Tried search and it works fine. But there is not where to specify, for
example, closed last week.
Using stats I only have numbers and this is not enough for me and for my
boss.
:(
On Thu, Mar 6, 2008 at 11:14 AM, Joshua Scott [EMAIL PROTECTED]
wrote:
Have you tried the stats module?
You
Andrew, it's perfect. But I need to know, for example, what are these
tickets. It's important to have the subject for this tickets in hands.
On Thu, Mar 6, 2008 at 8:14 AM, Andrew Stesin [EMAIL PROTECTED] wrote:
It's easy but needs a bit of daily work.
1. Establish some timestamp at which
This is for my boss!
;-)
I tried Search but I couldn't do that.
Any suggestions?
Diego
___
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Youll need to run a sql query on the database. This is what we do
select tn, title, owner, customer_id,
FROM_UNIXTIME(escalation_solution_time) time_completed,create_time,
floor((escalation_solution_time-create_time_unix)/86400) as days,
2008/3/6, Andrew Stesin [EMAIL PROTECTED]:
4. The day after:
- write `2008.03.06' into cell A2 - we are making a daily report for
Sorry for misprint, of course we are working with 3-rd row now, need to be A3 :)
___
OTRS mailing list: otrs - Webpage:
It's easy but needs a bit of daily work.
1. Establish some timestamp at which daily data is to be taken. Say 8:00.
2. Take Excel and create a table with the following columns:
- column A: date
- column B: the rest taken
- column C: new
- column D: closed
- column E: the rest given
3. Let's
Have you tried the stats module?
You should be able to easily create a report that will give you that
information, but I personally have a php boilerplate app that I customize
with SQL queries whenever I get a request like this from management, and
send the link to them so they can run the report