Click here to Skip to main content
15,867,568 members
Articles / Database Development / SQL Server
Article

Creating a Simple Help Desk Application

11 Apr 2011CPOL2 min read 47.9K   16   4
A demonstration of how you can quickly create a simple help desk application using modern development tools with little to no hand coding required.

This article is in the Product Showcase section for our sponsors at CodeProject. These articles are intended to provide you with information on products and services that we consider useful and of value to developers.

Introduction

A Help Desk application can be a great way to provide assistance and support to users. A simple IT Help Desk application will allow you to log problems and solutions. You can grant your staff/customers access to it allowing them to report their problems direct. Staff can then review the problem list and post solutions. Over time you will build up a repository of common problems and their solutions all in a central searchable place. Simple web applications like this can prove to be really useful.

Download_Green.png

Solution

To build your own Help Desk application you will need access to some development tools. In this example I have used MS SQL Server 2008R2 for the database and Iron Speed Designer v8 to build the application. You will also need to decide what information you want to collect. As this is your own custom application you will be able to collect just the right information for your business. In a basic system you will mostly likely need to log at least what software/hardware they are using and get a full description of their problem.

Create a Database

image001.jpg

Once you have decided what information you want to store you can create your database. I have provided a sample database schema below.

The HelpCase table is used to store a list of all reported problems and their respective solutions. The related tables are simple type tables designed to hold lists of information. These can then be used to populate drop downs for the user to select from.

Create an Application

image002.jpg

Once the database is complete you will need to create an application to use it. To keep things simple I have used a code generator called Iron Speed Designer to generate the application. This allows us to build the user interface without writing any code. I have generated a simple search page with additional add and edit pages. The screen shown below allows you to add/edit existing help cases and you can also search for key words in the problem description/solution.

This system also gives you access to an admin menu which you can use to configure data stored in the other tables. This is a very simple application but can easily have extra features added. With Iron Speed Designer you can build in role based security and various extra customisations without writing any code.

Conclusion

You can use modern development tools to generate simple applications without writing any code. This means you can create applications quickly to provide useful tools for use in your business. This help desk application is a prime example of what you can achieve. You could use the same basic principles to create other simple apps for tasks such as time tracking and customer relations management. As these are web applications you can deploy them on internal company networks or have them accessible on the public internet allowing your staff and customers access from anywhere. All these applications can be tailored to meet your particular business needs.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer
Canada Canada
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
GeneralSeems a bit expensive Pin
Edw12-Apr-11 3:22
Edw12-Apr-11 3:22 
GeneralRe: Seems a bit expensive Pin
Ben Demes12-Apr-11 4:21
Ben Demes12-Apr-11 4:21 
GeneralRe: Seems a bit expensive Pin
SamDaMann19-Apr-11 5:57
SamDaMann19-Apr-11 5:57 
GeneralRe: Seems a bit expensive Pin
Ben Demes19-Apr-11 6:30
Ben Demes19-Apr-11 6:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.