Slashdot Mirror


Best FOSS Help Desk Software For Small Firms?

Nocts writes "I'm currently working for a moderately sized company that manages a large portion of its internal help desk questions through a Jabber-based chat room. What we're looking for instead is an open source, preferably Web-based solution that will give us the ability to have floor representatives queue questions and concerns in a similar fashion to BugTraq, directed at the help desk. Email capability would be preferred for elaboration of specific issues, but the more we can centralize everything into the queued system the better. Any recommendations and experiences? Just about any language is doable since I have the ability to configure and upgrade our servers and we're looking at about a user base of 100 people, with around 5-10 questions a minute."

41 of 321 comments (clear)

  1. 100 people, 5-10 questions per minute? by bakuun · · Score: 5, Informative

    That's one helpdesk question per user every 10-20 minutes.. my god.

    1. Re:100 people, 5-10 questions per minute? by Bryansix · · Score: 5, Funny

      No, but I do work at Retard's R US and I do want an answer. Now pony up!

    2. Re:100 people, 5-10 questions per minute? by Gorobei · · Score: 4, Interesting

      We handle that traffic level with a few simple many-to-many chatrooms. All askers and answerers can see all messages, with highlighting of messages aimed at them. Bad answers are corrected quickly, and stupid questioners tend to get told to STFU: you quickly learn who is competent and who is not to be trusted. New users get up to speed quickly because they can watch the text stream and learn the expected style of communication.

    3. Re:100 people, 5-10 questions per minute? by Nocts · · Score: 5, Informative

      As the submitter, I should have elaborated in the main article so my apologies. We have ~100 users asking questions to helpdesk with an average of 5-10 questions a minute from those same users and it is being fielded by 2-3 actual helpdesk representatives at any given time. That's a silly number for representatives to require answers for what are generally common-sense responses, I agree. While we streamline our helpdesk ticket process we will also be reviewing our training procedures to eliminate the questions that these people should be able to answer themselves. While we could also just hire additional Helpdesk staff, it doesn't change the fact that Jabber is a terrible way to manage floor-level questions, especially when documentation is concerned.

      --
      "It is not the strongest of the species that survive, nor the most intelligent, but the one most responsive to change."
    4. Re:100 people, 5-10 questions per minute? by Nocts · · Score: 3, Informative

      3 people would have to answer each question in 20 seconds or less just to keep up

      Correct. Since the questions are from our floor reps and not the clients the actual inquires can be something as simple as "Is x property out?" with a simple yes/no answer. And the system is generally in place for questions that the reps can not answer on their own. Our larger problem is the retraining of procedure and encouraging the RTFM method, but it doesn't change the fact that we needed a more elegant solution for documenting the escalated helpdesk issues.

      And yes, sometimes the questions would be queued in the chat room with the simple questions answered in priority.

      --
      "It is not the strongest of the species that survive, nor the most intelligent, but the one most responsive to change."
    5. Re:100 people, 5-10 questions per minute? by Pjerky · · Score: 4, Insightful

      Why don't you just setup a simple forum that people can submit to and anyone can answer. Then your moderators can not only answer for one person but other users can see the answers to their same questions. Thus reducing the number of questions.

      --
      The Mind Is Speculative and Interpretive. So speculate all you want and interpret this 00101101 01001110!
    6. Re:100 people, 5-10 questions per minute? by jon3k · · Score: 4, Funny

      Since when is 100 helpdesk techs "small"? I must work inside a fucking amoeba...

    7. Re:100 people, 5-10 questions per minute? by ozmanjusri · · Score: 5, Funny
      I must work inside a fucking amoeba.

      Until the next exocytosis, anyway.

      --
      "I've got more toys than Teruhisa Kitahara."
    8. Re:100 people, 5-10 questions per minute? by Anonymous Coward · · Score: 3, Informative

      In my experience, RT ("Request Tracker") works well for 100-1000 users.

      According to the site:

      RT is an enterprise-grade ticketing system which enables a group of people to intelligently and efficiently manage tasks, issues, and requests submitted by a community of users.

      The RT platform has been under development since 1996, and is used by systems administrators, customer support staffs, IT managers, developers and marketing departments at thousands of sites around the world.

      Written in object-oriented Perl, RT is a high-level, portable, platform independent system that eases collaboration within organizations and makes it easy for them to take care of their customers.

      RT manages key tasks such as the identification, prioritization, assignment, resolution and notification required by enterprise-critical applications including project management, help desk, NOC ticketing, CRM and software development.

      RT is used by Fortune 100 companies, government agencies, educational institutions, and development organizations worldwide.

      http://bestpractical.com/rt/

  2. RT by dg41 · · Score: 5, Informative
    1. Re:RT by jgaynor · · Score: 4, Informative

      RT doesn't scale well. We used it at Rutgers but around the 100K ticket mark it started to tank. So we rewrote it:

      http://ruqueue.rutgers.edu/

      Very capable.

    2. Re:RT by ToddChapman · · Score: 3, Informative

      RT Rocks. Great software, great community, lots of good extensions available. Our company is a heavy user of RT. We have one instance for external requests and one for internal requests. It was really easy to customize for our exact needs. Note: I wrote Asset Tracker, an asset tracking (duh) extension to RT. http://code.google.com/p/asset-tracker-4rt/

    3. Re:RT by LinuxOnEveryDesktop · · Score: 3, Informative

      We're at almost 200K tickets. RT scales fine, you just have to tune it a bit. And run it on PostgreSQL, and *definitely* tweak your PostgreSQL for performance.

      In older versions, many indexes were missing by default. That may have been fixed more recently. Also, PostgreSQL 8.3 made a huge difference for us performance wise.

    4. Re:RT by jesse · · Score: 5, Interesting

      Readers might want to take my comments with a grain of salt, as I'm RT's original author and chief architect. I routinely work with clients with RT instances that are well over 100,000 tickets. When using any large application at scale, you're going to need to invest time in performance tuning, but 100k tickets isn't "big" for an RT instance. With a single front end box and a single backend (untuned, but beefy) DB server, I've seen an RT server doing 10,000 tickets on a slow day, bursting to 25,000 with several million in the database.

    5. Re:RT by trawg · · Score: 4, Informative

      We use RT at our work at the moment for both development/bug tracking and also user support. We had a LOT of teething problems and invested (imo) far too much time in trying to making it work properly - lots of odd performance issues, regular 10sec + load times, all sorts of weirdness. We spent a lot of time tweaking and finally got it running nicely (note: we're webdevs working on high utilisation sites so we know what we're doing as well, or at least think we do).

      Aside from all the messing around - I don't like it for user support. We're doing maybe between 600-1000 inquiries a month - I can't imagine doing it at the sort of volume specified in the OP.

      My big woes are the lack of good reporting, so its hard to identify trends - short of putting issues in queues I can't get visibility on what issues are cropping up regularly unless our staff remember them.

      Also, there's no option for doing Standard Responses (at least not in the base install), meaning every response needs to be custom-written. There might be an addon or something for this; I haven't looked.

      I got /really/ used to this in FogBugz (which I really liked for support purposes, but we got turned off by the price tag and closed-sourceness - we wanted something open so we could extend it. We've made a few changes to RT although have found hacking on it to be a pain in the ass (largely due to our inexperience with perl/mason/etc.

      We also rolled our own and use that, which works much better for our purposes, as it is heavily customised for our specific uses.

      All that said, I'd encourage you to try RT and see if it meets your needs. It's not terrible by any means, it just doesn't do what I want as well as I'd like.

    6. Re:RT by Bazman · · Score: 4, Informative

      We have a pretty small RT system for managing departmental issues. It used to get very slow, and checking on the server revealed apache spinning like mad, so we'd have to kick apache and it would get going okay again.

      I asked our university RT admin guy if he ever had this problem. And he said no, his RT was always pretty slick. Then I saw a lightbulb come on. Ah, he said, I do have a cron job that kicks apache every night at 3am. Why? I asked. Well, he replied, because RT used to get very slow and their apache would spin, was the answer.

      So now we kick our apache at 3am every morning and RT hasn't grinded to a halt since.

  3. 5-10 per minute? For 100 people? by lousyd · · Score: 4, Funny

    If your organization is only 100 people, and you get 5 to 10 support requests per minute, one wonders if you're doing something wrong.

    --
    If aspiration is a virtue, achievement cannot be a vice.
  4. OTRS by alexborges · · Score: 3, Informative

    otrs is ITIL compliant, has a webservice interface and generally rocks.

    We use them and so should many others.

    Another great one, but really complicated to deploy, is RT.... but its pretty cool, its what CERT uses AFAIK.

    --
    NO SIG
  5. Open source help desk suggestions by Amigan · · Score: 5, Informative

    Here's a website that lists many of the open source helpdesk options: http://www.opensourcehelpdesklist.com/ The only one I have experience with is ZenTrack and both the users and helpdesk folks found it easy to use. jerry

    --
    "Software is the difference between hardware and reality"
  6. Re:5-10 per minute? For 100 people? by Bryansix · · Score: 4, Funny

    Never underestimate the retard capacity of a sales department of about 75 people. Next keep in mind those positions turn over completely in about a month.

  7. CalemEAM by Shark4126 · · Score: 3, Informative

    Got CalemEAM running over here. It has a massive number of features, but you can limit it to only the work order portion if need be. Open source and super customizable: http://eam.calemeam.com/eam/

  8. Yes, RT by br00tus · · Score: 3, Informative

    We used RT at my last company. Keeps track of tickets, with different ticket queues, and different user groups. People can do it by web or e-mail or both. You can search the system for old tickets as well, although it's not a good idea to search the body of the message if you have a lot of tickets going back many years.

    1. Re:Yes, RT by dskoll · · Score: 3, Insightful

      We use RT and it works very well for us. We don't have a very high volume of tickets (we're up to about 14000 in 5 years, so only about 8 tickets/day on average), but RT is insanely flexible and customizable and has excellent e-mail integration.

    2. Re:Yes, RT by sqldr · · Score: 3, Informative

      If there is one piece of software I never want to use again, it's RT. It's all fine until you start modifying triggers and templates. First there's the evil, kludgey combination of bad perl and bad Mason which you have to write overlays to, then once you've done this, you can't upgrade! If you upgrade, all of your overlays break. So you end up stuck with an out of date version with patch on top of patch. Interface is a little ugly too.

      --
      I wrote my first program at the age of six, and I still can't work out how this website works.
  9. Liberum by SoupGuru · · Score: 4, Informative

    I really liked Liberum when I used it a couple of years ago. It's really simple, web based, and can use Windows integrated authentication which was really nice at that job. Might not be exactly what you're looking for but I thought I'd mention it since google doesn't find it very well.

    http://liberum.org/Default.aspx

    --
    What doesn't kill you only delays the inevitable
  10. Mantis by _Pablo · · Score: 3, Informative

    http://www.mantisbt.org

    --
    $2B OR NOT $2B = $FF
  11. IRC by Collinp6 · · Score: 3, Funny

    What about IRC? Its simple, you can PM people with specific questions, its free and open source, and it has many web-based clients.

  12. How about GLPI by EvilGrin666 · · Score: 3, Informative

    I work as a network manager in a school in the UK. We use a French Helpdesk system called GLPI. We also use OCS Inventory as recommended to populate the database with our hardware. Overall the solution has a few minor quirks, but if teachers can cope with it I don't understand why office drones can't!

  13. Re:Wesley by icydog · · Score: 5, Funny

    Fire your current staff and higher more computer literate individuals

    Perhaps they are trying to "higher" English (or whatever their language is) literate individuals.

  14. Re:I hear Good Things about RT by Anonymous Coward · · Score: 3, Funny

    I get contract work calls because Siebel is on my resume. I explain that I've helped 3 departments in 3 different companies stage active revolts against Siebel, demonstrating exactly how badly it sucks for anything but sales contacts, and override the VP who clearly got the pretty demo with pretty Gant charts, the permanent invite to 3-martini business lunches with Siebel "sales reps", and probably the weekly blowjob to get them to commit their companies to it. I then explain to the recruiter that any company using it should be expected to fail outright or be bought out at pennies on the dollar by a more competent company.

    So far, I'm right, 5 for 5.

  15. Write your own, seriously. by Gavin+Scott · · Score: 3, Insightful

    Service, whether it's software, hardware, helpdesk, whatever, is very hard to generalize.

    Everyone wants to do things their own way and everyone has some weird little set of extra requirements. So every package that's available has already choked to death and drowned in features that most people will not need.

    You get web UIs with tabs containing tabs containing hundreds of fields, of which a typical customer will probably use about 2-5%, and they'll end up stuffing information into them that they weren't originally intended to contain.

    I really can't think of an application domain that cries out for a completely custom solution in almost every case.

    G.

  16. No need to look far by Kugrian · · Score: 4, Funny
  17. Comment removed by account_deleted · · Score: 3, Funny

    Comment removed based on user account deletion

  18. Re:ruQueue by dskoll · · Score: 4, Interesting

    YIPE! I took a closer look at ruQueue... can you say XSS attacks and SQL injection, folks? /me mails the authors...

  19. What you REALLY NEED by Jane+Q.+Public · · Score: 5, Insightful

    ... is a way to cut back on the questions. Seriously. Putting a better help desk system in place might solve the symptoms, but dude, at that kind of question rate your operation, whatever it is, has some kind of disease and that is what you need to cure. Something about that operation is very badly designed somewhere.

  20. The disconnect here by symbolset · · Score: 5, Informative

    The problem here is that what you need is a dispatcher support system, not a helpdesk support system.

    A dispatcher support system has things like maps to objects and a website for checking inventory levels. Your dispatchers are experts who field questions about that sort of thing, and are keyed into the systems where the questions are answered. The previous poster is correct that chat rooms work well for this. If your reps are local, radio works well too.

    A helpdesk system creates trouble tickets that are tracked, assigned to service reps and accounted for. They're for blocking issues where nontechnical workers need technical help. If you had 5,000 customers and you're seeing two calls a minute, there's a major network outage and your call center stops entering tickets in minute two - if they can enter tickets at all with the network down. For a normal tech shop one or two tickets a year for the average customer is a pretty reasonable expectation.

    A trouble ticket system would work well for those questions that need escalation and all of the available trouble ticket systems can support thousands of trouble tickets per minute because they're automated technology solutions. Your problem will be not letting the tickets get out of control. You'll need to teach your dispatchers not to create tickets if they can find an answer in less than a few minutes.

    That said, have you tried sourceforge? They have about 500 CRM systems with trouble ticket tracking. Search for "CRM".

    --
    Help stamp out iliturcy.
  21. Re:ruQueue by that_itch_kid · · Score: 3, Informative

    XSS and SQL injection attacks are strongly correlated with bad coding practice.

    Don't get me wrong, the problem is probably more prevalent with PHP as PHP is such an easy language and thus attracts a larger number of amateur/incompetent programmers. That doesn't meant you can't write secure code in PHP.
    I'm currently re-writing a logistics system in PHP, and sure enough, XSS/SQL attacks would have been child's play in the original code (Even from the login page).
    I can assure you every single one of my database inputs is checked for injection attacks (Even those that came directly from PHP built-ins like time()), and every piece of data that goes onto a web page is checked for scripts as well.

    Writing secure code can be a difficult process, but it's not impossible even with PHP.

  22. Cerberus Helpdesk by waa · · Score: 3, Informative

    Giving up my mod points to recommend Cerberus

    --
    Windows is not the answer.
    Windows is the question.
    The answer is "NO."
  23. I'd imagine that's part of the reason by Sycraft-fu · · Score: 4, Insightful

    They want a helpdesk. One problem you find with support is that if you make support too easy, some people will stop thinking for themselves. When they can get instant answers to their questions, they just stop trying, they ask first without thinking. So I could see something where it's an immediate communication leads to a situation of people asking tons of dumb questions all the time.

    Where I work, that's one of a number of reasons why we insist people send e-mail to the help desk. When they just wander in or call, they are prone to ask simple questions they can answer themselves because they expect an immediate response. When a response will take a little bit, they'll solve the problem on their own.

    Sometimes I'll deliberately wait on a ticket, doing other first, if it is something simple I think they'll figure out. Often I'm right about this. We'll get something like "My printer is broken help!!!!" Then 15 minutes later "Oh it just wasn't turned on, never mind."

    So ya I think IM based support is probably the worst you can have for that. At least with a phone people still have to call, maybe wait on hold, etc. With IM they can fire it off any time, even while doing other things, but it is still near realtime so they expect a response right away. That leads to a real brain shutdown in many people. They find it easier to just IM support rather than think about anything, so you'll get request after request.

    1. Re:I'd imagine that's part of the reason by nmp0906 · · Score: 3, Interesting

      It has been awhile since I have looked at free ticketing systems, but I seem to remember that outside of OS Ticket there was not a whole lot of offerings. Granted, at the very core, a ticketing system is not terribly complex, but finding one with a good workflow out of the box is the difficult part.

      Now I know you said free, but I highly recommend you check out Kayako. I personally have not found anything close to the workflow and capabilities this offers. When I used to work for an outsourced support company (mainly web hosting) our system interfaced with customers' Kayako installations almost exclusively. We were pushing 12+ tickets per hour per seat, and the workflow allowed us to do that effectively.

      The single feature I miss the most with my current companies ticketing systems is the ability to put tickets on hold (or close, or other custom status) and have them re-open at a specified time interval, say for future requests. Their suite comes with a chat application and a knowledge base, which I don't have extensive experience with, but know they do their respective jobs adequetaly.

      In addition to the web interface, Kayako operates extensively by email if you should choose. Now, most ticketing systems I have used do this, but the thing is Kayako's web interface operates like how you would expect email too. Adding people to tickets is simple with the cc or bcc fields (and people get emailed accordingly on ticket status changes). Like I said the workflow is really effective and the interface is superb.

      Kayako is only $300/yr for the suite (or $200/yr for just the ticketing system), which is quite reasonable. There is a 30-day demo available. I haven't checked out all the recent features, but last I checked they were working on some more advanced features like desktop sharing, if that be beneficial.

  24. Re:Is x property out? by fuzzyfuzzyfungus · · Score: 3, Insightful

    As far as (l)users are concerned, the helpdesk is a database frontend.