My company is using HEAT (
http://www.smasystems.com/)
This solution allows for Automatic Ticket Generation from email (we currently utilize an automated monitoring program on another system to email problems to the ATG which creates a ticket....the problems are taken care of before our stores even knew a problem existed, Web ticket initiation and manual entry....Assignment of tickets and a whole lot more we have not implemented. It uses an SQL-server backend and has a KB repository.
Although letting go of a home grown system is difficult, there are many solutions out there, including this one, that have much more capability.
My company is a retail chain of 557+ stores in the US and Canada, 900+ internal employees and field personell. It has and is still serving us well. With an SQL server backend, reporting can be done via Crystal Reports or other DB Query solution.
Edited by jflaker on May 24 2006 at 10:20 AM
If you are satisfied, please check yes above to accept this answer. Thank you very much.
As always bonuses are always welcomed and highly appreciated.