[SOLVED]SQL box report.

[immaBeans]

Good day to all.

Technically Im not good in SQL but I know that SQL box is the only way to see report in OTRS,
Can someone help me to see the reports of "TicketNumber,Owner,Subject,Date Created,State,Lapse from creation to reporting,DateClosed"

Please help. I just want to see our dev server status report. thanks.
And how can I know, how long does the ticket's state is new,open or closed.

exampe:
Report Name: Hours per state
Reporting Date: July 25, 2013
________________________________________________________
| ticket# | Create date | State | Lapse from creation to reporting|
| 000001 | July 15 | new | 15days |
| 000001 | July 15 | open | 12days |


In this example ticket "00001" is created in July 15 and its state is "New" but after "15 days" the state change "New" to "Open"

Thanks for help.

[crythias]

viewtopic.php?f=53&t=14242#p67562

[immaBeans]

Thanks now I can create report in a minute