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

rugwiza

Mr.

u can use Scott's reporting module . it is excellent

http://sudobash.net/ostickets-reports(http://sudobash.net/ostickets-reports)

thx

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

makpith

Thanks

thanks yooooooooooooooooooooooooooooooooooooooooooooou