Reporting

[geekChamp]

Hello

I use osTicket for my clients to open support ticket with my company. Is there a reporting module, where by I can generate monthly/yearly reports to how many tickets were opened in what priority, time to resolution (I don't think osTicket tracks the time on it though).

You know what I mean, the kind of info you would like to provide to someone who's using your services.

I use cpanel, does mySQL have any reporting application like "SQL reporting services" are there for MS SQL server?

One that is open source that I can install on my portal to generate the reports?

I don't mind building a class so that others can download it to add it to their installation.

Does osTicket have exposed APIs, or a module plan to encourage plugins to be developed?

Just thinking aloud here.

Thanks

[torusturtle]

osTicket saves the time of tickets and messages here:

ost_ticket.created
ost_ticket.closed
ost_ticket.reopened
ost_ticket_message.created
ost_ticket_response.created
ost_ticket_note.created

It should be possibel to use these data to create a report.

This would be a good feature I'd use too.

[hereme]

were you able to get this done ? it would really help if you can post the solution here