Ticket Tracking and Customer Management?

An anonymous reader writes "Like many Slashdot readers, I'm sure, I run a small side business doing IT consulting in addition to my day job. I'm looking for a good open-source ticket tracking system that I can run under Linux, preferably one that also has some customer management features. I'd like to be able to maintain a separate record for each job, along with time tracking, work logs, and information about the customer. Much of what I see on Sourceforge is, as usual, pre-pre-pre-alpha with no actual code. Does anyone have any suggestions for a project that might fit my needs?"

Major missing point...

[Sparr0]

All the other replies are pointing out great "ticket tracking" software, but I think that is the easy half of this request. I too have searched for what the original submitter is searching for. The key thing that is missing from the existing offerings is hour and work logs. Put simply, at the end of a ticket we need how much to bill the client for. Integrated invoicing would be awesome.

Re:Same thing under Windows

[crossmr]

if its web based..no you don't need it to run under windows. Its why god invented virtual machines. Web based means the back end should be completely transparent to the users and it doesn't matter if its run on a gerbil strapped to a hamster chasing a toaster.

Re:Trac (Open Source; Python)

[Anonymous Coward]

If Trac is so good, tell me how you get a list of tickets you've submitted over the past year(not assigned to you, just submitted).

Seriously, go try and see how it has no way to do that.

doyourownwork = asshole

[dbc001]

Whoever tagged this post as "doyourownwork" is an asshole who has no understanding of the way The Internet and it's online communities work. For any question that gets posted on Slashdot, there are dozens if not hundreds of Slashdot readers who want to know the answer. I wouldn't be surprised if 20% of the Slashdot community is running some kind of business that might have a need for a ticket tracking and CRM software setup. Many Slashdot readers are also very friendly, so while a person could easily spend hours researching a question like this, it's far more effective to come to Slashdot and benefit from the experience of it's users.

So to all the douchebags who criticize people who ask questions on Slashdot: FUCK YOU.

Re:Trac (Open Source; Python)

[Anonymous Coward]

"Seriously, go try and see how it has no way to do that."

Sure there's no way. It is an open source product (as in "well, you can modify the source any way you want", backed up by a database where start date for a ticket is already stored and still "there's no way" to send an easy SQL query to the database. And some idiot moderate this as "insightful".

Well, I don't even use a recent Trac version, but here we go:

On main page go "View Tickets"; choose "6 - All Tickets By Milestone (Including closed)". Then go "This report: copy" and give it another name (just to preserve the original). On the copy go to "Edit"; then go to "SQL Query for Report" and modify it to your leisure (you just need to add a "where clause"); done.

What's more: since there is such a standard and *simple* template system for database queries you can add the ones significant to your *specific* needs in minutes, few hours at most. Try that on more "corporate aware" products and then learn what's easy and what's difficult. And, believe me, no matter what you use, you *will* have to customize it to your company needs.