LBE Web Helpdesk - Help Contents

  1. Introduction
  2. Quick Start
  3. Concepts and terms
  4. Installation
    1. System Requirements
    2. Files supplied
    3. Upgrading from earlier versions
    4. Installing
    5. Installing the Access database
    6. Using Sql Server
    7. Using Oracle
    8. Uninstalling
    9. Configuring
    10. NT Authentication
    11. Trouble-shooting
  5. Features
  6. What's new in this version
  7. Contacting LBE
  8. Trial Version
  9. Ordering
  10. Licensing
  11. Importing data from other programs
  12. Our other Helpdesk products
  13. Knowledge base
  14. Log in as operator
  15. Jobs Search Page
  16. Helpdesk Jobs
    1. Creating a new helpdesk Job
    2. Sending e-mail
    3. Searching Jobs
    4. Actioning an existing Job
    5. Creating a Child Job
    6. Uploading files to link to a Job
    7. Customize e-mails sent by the helpdesk
  17. Guests
    1. What are Guests?
    2. Logging as a Guest
    3. Registering a new Guest
  18. Customer Information
    1. Customer Hierarchy
    2. Adding/Editing a Customer
    3. Adding/Editing Departments
    4. Adding/Editing Contacts
    5. Adding/Editing Assets
  19. System Maintenance
    1. Personal Preferences
    2. Linked File Options
    3. Job History Order Options
    4. Items to Include in Job History
    5. Custom Fields
    6. Organization Structure
    7. Auto-escalation notification
    8. Asset Types
    9. Categories
    10. Priorities
    11. Working Hours
    12. Helpdesk Operators
    13. Clear Operator Activity
  20. Logging Off
  21. Hiding Records without Deleting them
  22. Error Logging
  23. Protecting your data
    1. Security
    2. Data
    3. Compacting your Access database
  24. Database Structure
  25. Reports
  26. Creating your own reports
  27. Customization

Introduction

Welcome to LBE Web Helpdesk. This is a fully functioning helpdesk system designed to be operated via your web browser. You can use LBE Web Helpdesk on the Internet, an Intranet or even run it locally on a stand-alone machine.

LBE Web Helpdesk can be installed on any web server running a Microsoft Windows 95/98/NT/2000 operating system. It can be accessed from any machine running a Javascript enabled web browser.

Powerful HelpDesk Software LBE Web Helpdesk will help you manage and control your helpdesk operation, without forcing you to change the way you work.

Sensibly priced
We charge per concurrent user, not individuals This means you only pay for the number of people you expect to be simultaneously using the helpdesk. By doing so, we can make LBE Web helpdesk affordable for small and medium sized enterprises. Many of our customers have told us they looked at helpdesk software which is more than 10 times our price - but, in their words, "wasn't anything like as good".

Simple to use
No extensive training is required. Our customers tell us that one of the major reasons they chose LBE Web Helpdesk is they found it very easy to understand and learn how to use it.

Adapts to your needs
Easily configured to reflect the way that you work.

Easy to set up
No need for an expensive on-site visit from us to install LBE Web Helpdesk. Just run the supplied setup on the web server PC, specify the location of your database and you are ready to start.

Scalable
LBE Web Helpdesk can be used with the supplied Access database, Microsoft Sql Server or Oracle.

Extensive Reporting
Supplied with many reports. If you need further reports, you can build your own reports using many of the commonly available reporting tools.

Integrates with our other Helpdesk Systems
Both LBE Desktop Helpdesk and LBE Web Helpdesk can share the same database.


Quick Start

This section will give you a quick demonstration of using LBE Web Helpdesk. When you have more time, you should review the rest of this documentation.

1. Install the Web Server

You need to have Microsoft Personal Web Server (PWS) or Microsoft Internet Information Server (IIS) running on either your local machine or one that you can connect to via the network. (see Requirements for more details).

2. Install Internet Explorer 5 (or later) on your web server

Internet Explorer 5 must be installed on your web server to provide support for the VBScript used in LBE Web Helpdesk.

3. Install the LBE Web Helpdesk files

On your web server, run the setup.exe supplied in the LBE Web Helpdesk installation set. Make sure you have full rights in the selected installation directory.

4. Run the Configure LBE Web Helpdesk from the start menu.

This will guide you through the configuration of the web helpdesk.

5. Access the Helpdesk

Point your browser to http://machine_name/web_name/oplogin.asp. The machine name can be found from the Network applet (Windows Start menu, Settings), the web_name will be the name you gave the virtual directory earlier.

6. Log in

You will be prompted for a name and password, enter 'trial' and 'password' (both without the quote marks), then click the Submit button.

7. Trial Version Page

If you are running the trial version of LBE Web Helpdesk, the next page to be displayed will remind you that you are running the trial.

8. Create a new Helpdesk Job

Select 'Jobs' from the drop down menu (you may also need to click the GO button). You will see a page with a table at the top entitled 'Selection Options'. This allows you to search for a particular Job. Ignore it for the moment and click the link beneath it entitled 'Create New Job'.

9. Complete the Helpdesk Job Information

The next page to be displayed is the 'New Helpdesk Job' page. Take a moment to look at the information you can record. For now we will ignore everything apart from the Problem description. Scroll down until you can see this section and type into the box a description of a problem.

10. Save the Helpdesk Job

Leave everything else as it is, then click the Update button. The 'Update Job' page will be displayed and will tell you that the Job has been successfully saved.

11. Finally

Well done, you have created your first Helpdesk Job with LBE Web Helpdesk. Now you should take some time to go through the rest of this help file.


Concepts and terms

Jobs

Jobs are the problems which users report to you or enter into the system themselves. A Job can be Actioned many times before it is completed.

Child Jobs

These are Jobs which must be completed before their parent Job can be completed. A Child Job cannot become a parent of another Job.

Action

An Action means that you have actually done something in relation to the Job, anything from recording extra information to completing the Job. All Actions are recorded with each Job in an audit trail called the Job History.

Customers

A Customer is an organization. If you are using LBE Web Helpdesk internally, it will be the company you work for. Otherwise it is those external organizations which you deal with.

Departments

A Department is a sub-division of a Customer. E.g. Sales, Finance, Marketing.

Contacts

A Contact is a person. All Jobs must be created against a Contact. The hierarchy is as follows:

Customers may have one or more Departments.

Departments may have one or more Contacts.

Categories

Categories help you identify certain types of Jobs. For example, you might categorize according to the probable cause, e.g. Hardware, Software etc.

Priorities

Priorities allow you to specify how important a Job is. The Priority also determines the default target for completion of the Job.

Helpdesk Operators

These are the people who work for you and use LBE Helpdesk. They create new Jobs and record whatever actions were taken.

Guests

Guests are Customer Contacts who you have allowed to access the Web Helpdesk. They can create new Jobs, view and perform limited Actions on their existing Jobs.

Assets/Inventory

Assets are (usually) physical items. E.g. hardware, software, furnishings, fittings etc.

Asset Types

Assets might be items of software, hardware, furnishings, fittings etc. Asset Types allow you to categorize Assets.


System Requirements

In order to use LBE Web Helpdesk you need the following:

A Web Server

The Web server must be capable of running Active Server Pages. Supported web servers are both from Microsoft:

Both of these are provided free by Microsoft.

In addition, Internet Explorer 5 (or later) should be installed on your web server to provide support for the VBScript used in LBE Web Helpdesk.

A Database

You can use the following databases with LBE Web Helpdesk:

Data Access Components

These allow your web server to connect to the database. LBE Web Helpdesk requires you to have installed Microsoft OLE DB drivers for Microsoft Jet (if you are using the Access database), Microsoft SQL Server or Oracle. These drivers are normally installed during the installation of your chosen web server. If you are not sure, you should download and install the latest mdac_typ.exe file from Microsoft.

A Web Browser

This is the only software that needs to be installed on the users' machines. LBE Web Helpdesk has been tested with MS Internet Explorer 4/5 and Netscape Communicator 4.51. Most modern web browsers should have no problem. The Web browser must have Javascript enabled. There is no additional software to install and no applets to download.

A Mail Server (Optional)

LBE Web Helpdesk can use e-mail to notify users and operators, to do so, mail software must be installed on your web server. The following mail protocols are supported :


Files supplied

LBE Web Helpdesk uses Microsoft Active Server Pages (ASP) technology. The following files are supplied:


Upgrading from earlier versions

Please back up all databases before upgrading.

Web Site

We suggest that initially, you install the new version into a different folder to your existing web helpdesk. When you are happy to move your main site over, simply change the directory your web helpdesk site is pointing at.

Transfer the settings from the old global.asa to the new one.

If we have prviously customized the web helpdesk for you, you may find that your customization is now an option in the "Configure LBE Web Helpdesk" Utility. If not, please contact us, there may be a small charge for re-implementing the changes depending on the amount of work involved.

LBE Desktop Helpdesk Databases

Upgrading databases from LBE Desktop Helpdesk 3.1:
Download and install LBE Desktop Helpdesk Version 4 and run it against your database. It will automatically update the database. Please make sure no one else is using the helpdesk whilst it is trying to convert it. Please note, the automatic process will not convert the database to Access 2000 format, you can do this manually yourself by opening it in MS Access 2000 after the initial conversion.

Upgrading databases from earlier LBE Desktop Helpdesk:
Please zip up your database and forward to LBE for conversion. If you do so on e.g. Friday evening we will have the database back to you for start of business on the following Monday.

LBE Web Helpdesk Databases

Access database
Download and install LBE Desktop Helpdesk Version 4 and run it against your database. It will automatically update the database. Please make sure no one else is using the helpdesk whilst it is trying to convert it. Please note, the automatic process will not convert the database to Access 2000 format, you can do this manually yourself by opening it in MS Access 2000 after the initial conversion.

MS Sql Server database
Please run the ConvertMSSql.sql file in the MSSql folder created by the setup.

Oracle database
Please run the ConvertOracle.sql file in the Oracle folder created by the setup.

If you have changed any of the database user names or passwords from the defaults supplied by LBE, you will need to amend these sql scripts.

If you have any difficulty, please contact LBE.


Installing

1. Install the Web Server

You need to have Microsoft Personal Web Server (PWS) or Microsoft Internet Information Server (IIS) running on either your local machine or one that you can connect to via the network. (see Requirements for more details).

2. Install Internet Explorer 5 (or later) on your web server

Internet Explorer 5 must be installed on your web server to provide support for the VBScript used in LBE Web Helpdesk.

3. Install the LBE Web Helpdesk files

On your web server, run the setup.exe supplied in the LBE Web Helpdesk installation set. Make sure you have full rights in the selected installation directory.

4. Register the dll

This should already have been done for you by the install routine. If you have any problems, click the Windows Start button, select run then type regsvr32 c:\path\lbeweb40.dll where path is the directory you installed LBE Web Helpdesk into. If the path contains spaces you must enclose it in quote marks, e.g.: regsvr32 "c:\program files\lbe helpdesk\lbeweb40.dll"

5. Run the "Configure LBE Web Helpdesk" from the start menu.

This will guide you through each step needed to set up the web helpdesk.


Installing the Access database

The file helpdesk.mdb will be copied into the directory you chose as an installation directory for the helpdesk files. It is best to keep the Access database on the same machine as the web server. In Configuring we will show you how to tell the helpdesk where your database is located.


Using Sql Server

We will assume that you already have SQL Server installed and can connect to the database. The Sql Server installation must be case-insensitive (which is the default option when installing MS Sql Server).

Open SQL Server Query Analyzer and connect to your Sql Server machine. open the 'create.sql' file which can be found in the MSSql folder supplied with LBE Web Helpdesk. This sql script will create:

If you wish to set up different logins/roles/grants please feel free to amend this script.

After running the create.sql, assuming there are no errors, open the 'data.sql' file (again, found in MSSql.zip), and run it. This will seed the tables with their initial values.


Using Oracle

We will assume that you already have Oracle 8 installed and can connect to the database. The web server must also have the Oracle Client software installed even if you are using the same server for both the web and database.

Please read and understand each of the sql scripts supplied. You may wish to create a separate tablespace for the web helpdesk and create the users in that tablespace. You may also wish to implement a differing security model.

You will need to amend the CONNECT statements as they assume the default password for the system user.

If you make any changes to the users created by users.sql, you will need to apply the same changes to all the other scripts.

The Oracle folder installed by the setup contains the following sql scripts needed to create the database for LBE Web Helpdesk


Uninstalling

If you decide that LBE Helpdesk doesn't meet your requirements, please send us an e-mail explaining what the problem is. We will do whatever we can to fix it or add the features you need.

To un-install:

  1. Stop your web server.
  2. Click the Windows Start button, select run then type regsvr32 c:\path\lbeweb40.dll -u where path is the directory you installed LBE Web Helpdesk into. If the path contains spaces you must enclose it in quote marks, e.g.: regsvr32 "c:\program files\lbe helpdesk\lbeweb40.dll" -u
  3. Run the Add-Remove Programs application from the Windows Control Panel.
  4. Delete the directory you installed LBE Web Helpdesk into.
  5. If you placed the helpdesk.mdb elsewhere, delete it.
  6. If you are using SQL Server, delete the helpdesk database in SQL Server Enterprise Manager.
  7. If you are using Oracle, run the drop.sql script.

Configuring

You can configure LBE Web Helpdesk by running the "Configure LBE Web Helpdesk" utility which was installed with the rest of the program.


NT Authentication

The standard method of authentication used by the Web Helpdesk is via a username/password page.

However, if you are using the Web Helpdesk on an intranet and wish to avoid this, you can use NT Authentication. To do so:

For the system to correctly identify the user, it gets the NT user name and tries to find a record in the helpdesk database which contains this user name:

  1. It checks to see if the user is a helpdesk operator by looking in the Users table for a record where either the username or e-mail field is equal to the detected NT user name. If found, it will automatically log this user into the helpdesk as an operator.


  2. If it can't find an operator with this NT user name, it will look to see if this is a Guest (i.e. a Customer Contact). To do so, it checks forename, surname and e-mail fields of the Person table for a value equal to the NT user name. If it finds a match, it will automatically log this user into the helpdesk as a guest.


  3. If the NT user is not found in either table, it will display an error message.

Trouble-shooting

You are most likely to run into problems when first installing LBE Web Helpdesk on your web server. This is because there are a number of Microsoft technologies which need to be working together correctly for our application to run.

To help you identify the problem we supply a file named testfile.asp. You should open this in your browser as normal. It will carry out a number of tests and report the results to you. N.B. Once you have the system up and running, you should delete testfile.asp as it could provide valuable information to potential hackers.

The main problem areas are:

Data Access

This is the one that causes 95% of all installation problems. Make sure you have installed MDAC 2.7(http://www.microsoft.com/data/download_270RTM.htm) and the Jet Service pack 3 (http://www.microsoft.com/data/download_Jet4SP3.htm). These files must be installed on the web server

Please note If using Oracle as your database, you also need to install the Oracle client software onto the web server from the Oracle CD.

Software Installation

Install IE5 on the web server - this provides VBScript support that the helpdesk needs.

Use either IIS4 or PWS4 as your web server. N.B. The web server provided by default with Frontpage will not support the Active Server Pages that the helpdesk uses.

Web Setup

Ensure the name of the virtual directory that points to the Web Helpdesk files does not contain any spaces.

Permissions

In either PWS or IIS, set Read and Script permissions on the virtual directory for the Web Helpdesk.

If you are using an MS Access database on NT, make sure the IUSR_computer account has create rights in the directory the database is located in.

If your web server is running on NT, the IUSR_computer and IWAM_computer account must be granted read permissions to the :\Program Files\Common Files\System\ADO directory and to the directory you installed the Web Helpdesk into.

Date Formats

If you have problems running the reports, you may need to change the long date format on your web server. Click Start Menu, Control Panel, Regional Settings, then select the Date tab. Enter a long date format of dd MMMM yyyy. Do not include the day name in any date format.


Features

Here are just some of the features you will find in LBE Web Helpdesk:

What's new in this version


Contacting LBE

Please send e-mail to LBE Support or visit our web-site for further contact information.


Trial Version

This evaluation version of LBE Web Helpdesk contains all the functionality of the full version with the following restrictions:

You can purchase a licence for the required number of concurrent users (in packs of 5), or an unlimited licence. Once you purchase, we will send you a licence file which allows you to continue using the product and any data created during the trial period.


Ordering

You can order on-line on our secure server at our web site. We accept checks, credit cards, purchase orders and bank transfer payments. Licences are purchased for the number of concurrent users you require in units of 5. Pricing detail can be found at our web site.

If you have any other requirements, please contact us either by an e-mail to LBE Sales, or by telephone/fax, the numbers can be found at our web site.


Licensing

We charge per concurrent user, not individuals This means you only pay for the number of people you expect to be simultaneously using the helpdesk. By doing so, we can make LBE Web helpdesk affordable for small and medium sized enterprises. Licences are available in packs of 5 or an unlimited concurrent user licence.

When an operator or guest logs in they consume a single licence. When they log out, this licence is released. If the user does not log out, the system will automatically log them out after an interval specified in the configuration, therefore you may need to order additional licences for this eventuality. If you do not have sufficient licences the system will not allow them entry and you may need to purchase additional licences.

If you wish to install LBE Web Helpdesk on several websites or different servers, you must purchase separate licences for each site

.

Importing data from other programs

It may be that you are upgrading to LBE Helpdesk from:

or you wish to import e.g. Customer information from another database.

The best tool is probably Microsoft Access. This has very good data import wizards which should enable you to carry out this task with the minimum of problems. Before doing so, you must understand the structure of the database which LBE Helpdesk uses.

If you do have any problems or need advice, we are happy to help.


Our other Helpdesk products

Other Helpdesk Products

LBE Helpdesk 2.5

This is an early version which we distribute for free. There is no licence charge.

LBE Desktop Helpdesk

Ideally suited for use by your helpdesk operators, the desktop environment allows us to provide a richer user interface.

LBE Helpdesk Mail-in Server

Lets your customers send a simple e-mail to automatically create new helpdesk jobs, update their existing jobs and retrieve the current status. Works with LBE Desktop Helpdesk and LBE Web Helpdesk.

Helpdesk Hosting

We can host your LBE Web Helpdesk on our website. This saves you the problems of finding a suitable webhost, installation and set up. Plus you don't have to buy a licence outright, in effect we rent the application to you for the length of the hosting agreement.

Please visit our web-site for more information and to download.


Knowledge base

Using the Knowledge Base page, your users and operators can quickly find if their problem has been solved before. They can enter a word or phrase and the Knowledge Base will show them both the Problem and Solution for all closed Jobs which contain this word/phrase.


Log in as Operator

Helpdesk Operators are the people who use LBE Web Helpdesk to record information about problems and (hopefully) solve them. Each Operator needs to be registered with the system and each operator can be assigned access to particular parts of the system by their privileges. See later for more information.

Helpdesk Operators should access the system by pointing their web browser at oplogin.asp. This page will ask them for their name and a password (see later to find out how to set these up). LBE Web Helpdesk ships with an Operator named 'trial' with a password of 'password'. On the same page is a link which allows you to login as a Guest, we will ignore this for the moment.

If the name and password are accepted, you will be taken to the Jobs Search page. If you are running the trial version of LBE Web Helpdesk, you will be taken to the 'Trial Version' page, on which you can select an option from the drop-down menu.

Log in, then, if you are not taken directly to the Jobs Search page, select 'Jobs' from the drop-down list.


Jobs Search Page

You should be at the 'Jobs Search' page, if not, select 'Jobs' from the drop-down menu at the top of the page.

At the top of the page you will see a table entitled 'Selection Options' with a number of entry fields in it. By default, the system retrieves all Open Jobs, however you can use the Selection options to search by particular criteria. Ignore this for the moment and click the 'Create New Job' link.


Creating a new helpdesk Job

There are a number of entry fields on this page, we will go through each of these in turn:

Job id

This is a unique identifier for each Job and is generated by the system. It cannot be edited. Because we are creating a new Job, this number is not shown.

Customer/Dept/Contact

Each job must be assigned to a particular Customer Contact. Contacts belong to Customer Departments which in turn belong to Customers. You will see either a text box for you enter a full or partial customer name or a drop down list displays all the available values for you to select from, depending on your Personal Preferences. Just to the right of the drop-down list is a button which will be marked with a '+' to add a new item to the drop-down or 'Search', to select a Customer Contact. Click this button now.

+ button
A dialog box will be displayed which will prompt you for a new entry in the format 'Customer/Department/Contact' (dependent on the Organization Structure you have selected. In this case, you must supply all three values, separated by a '/' character. Type the following: 'My New Customer/All/Ms. J Smith' then click the OK button. The new value will be displayed in the drop-down list.

When we submit this Job for update, this will create a new Customer called 'My New Customer' with a new Department called 'All' and a new Customer Contact called 'Ms. J Smith'. If either the Customer name or Department (for that Customer) already exist it will just create a new Customer Contact.

Search button
A new window will open and display the Customer Contacts. Either click the "Select this record" link or click the link to create a new Contact, first.

Job Status

Either 'Open', 'On Hold' or 'Closed'. Leave it set to the dafault of 'Open'

Category

This allows you to categorize each helpdesk Job, which can help you in analyzing your helpdesk activity. You can add a new Category by clicking the '+' button.

Priority

Select a Priority from the drop-down list. Essentially this is just another classification for your helpdesk jobs, and should be used to determine the importance of each Job. You can add a new Priority by clicking the '+' button. If you change the Priority, the system will ask if you wish to reset the target date/time to the calculated value for that Priority.

Which Asset do you think the problem relates to?

This is an optional entry. You can assign this Job to a particular piece of equipment or software etc. Each Asset belongs to a Customer. You will see either a text box for you enter a full or partial asset number or a drop down list displays all the available values for you to select from, depending on the setting you have made in your Personal Preferences. Just to the right of the drop-down list is a button which will be marked with a '+' to add a new item to the drop-down or 'Search' to select an Asset.

Problem

This is where you describe the nature of the Problem which has led to the creation of this Job.

To Do

Use this as a reminder for any outstanding actions you need to take.

Solution

If the Job is completed, you should enter a brief description as to how it was solved. This is important as may enable Operators to solve similar Jobs in the future.

Notes

Use this to record any other information about the Job, e.g. machine setup. When you save, these Notes will be transferred to the Job History (see later).

Custom Fields

There are two Custom Fields, which you may have renamed from the Maintenance page. These are provided so that you can store information which is particular to the way you run your business.

Actioned at

Enter the date and time this Action was carried out. The system defaults to the current date and time at the web server which may or may not be the same as your time, depending on your geographic location.

To be completed by

This is the target completion date and time for the Job. The default value is determined by the default Priority and your Working Hours (see later).

Who carried out this Action?

Select the Operator who carried out this Action from the drop-down list. The selected value defaults to the name of the operator currently logged in, but may be changed if e.g. you are Actioning this job on behalf of another operator. You can add a new Operator by clicking the '+' button.

Pass this Job to Operator

It may be that another Operator needs to deal with this Job next, if so, select their name from the drop down list.

Time spent (this action)

You can keep track of how much time is spent on each Job by entering a value in these fields. Whatever is entered will be added to the running total for the Job. The system will automatically increment this value every minute. If you have the appropriate privileges, you can edit this value - at which point the auto-increment will cease.

Cost spent (this action)

This allows you to cost each Job, you might use this to keep track of e.g. the cost of any spares used in a repair job. The entered value will be added to the running total for the Job.

E-Mail Fields

These check boxes determine who e-mail is sent to and the contents of the e-mail.

Cancel Button

If you decide not to update, click the Cancel button. The Job will not be updated, and any new values you added to the drop-down lists will not be sent to the database. If you are Actioning an existing Job, it will also clear the 'Currently Opened by' indicator on the Job, so that other Operators can see that no one else is working on it.

Update Button

When you have entered all the information, click the Update button. Please do so now. This will take you to the 'Update Job' page.

Update Job Page

Assuming the Job was updated/created correctly, this will be confirmed. You will also be shown links which allow you to:

For the moment, click the "Edit and send the mail message" link.

Sending e-mail

You should be at the Mail page, having just created a new Job and then clicked the 'Edit and send e-mail' link.

You will see a mail dialog, with To, CC, BCC, Subject and the message text itself. The recipients in the To field should already have been set, if you are using an SMTP server these should be the actual e-mail addresses rather than the people's names. If their e-mail addresses are not shown you need to define these for the Customer Contact and the Helpdesk Operator. You may add other recipients in any of the address fields.

The content of the email depends on template files which you may customize

When you are happy with the contents of the message, click the 'Send' button. The system will display a confirmation that the e-mail has been sent, or re-display the message if there is a problem.


Searching Jobs

The Jobs Search page has 'Selection Options' at the top of the page that allows you to restrict the Jobs retrieved

Search

This is a drop-down list which allows you to select what you wish to search on.

Search For

Enter the value you want to search for. E.g. if you selected Job Id in the Search drop-down, you would enter the Id of the Job you wanted to find in the Search For box. Using the next drop-down, you can choose what types of Jobs (Open, Closed, Held etc.) you want to be included in this search.

Sort by

Choose the value you wish to sort the returned records by, the drop-down Asc/Desc, allows you to choose Ascending or Descending sort.

Show

You can choose to show the Jobs in Summary, Detailed or Job Sheet mode. Job sheet mode is meant to be used for you to print out the Job details for an engineer to take and complete on-site.

Records per page

Choose how many records are displayed. If there are more records than will fit on one page, you will be given links to the other pages.

Advanced Search

If you click this link, you will be shown a much more complex Selection Options which allows you to specify complex search queries.

Saving Searches

Below the selection options you will see a link "Right click, Copy Shortcut to save this search". Right click on this link and select Copy Shortcut. Then go to a folder that you wish to save the search to. Right click, select Copy Shortcut. Alternatively, just drag the link onto your desktop. Now, whenever you wish to repeat this search, just drag the shortcut onto your browser window. This technique can be used on any of the search pages.


Actioning an existing Job

Select 'Jobs' from the drop-down list at the top of the page. You will be taken to the Jobs Search page. If you remember the Job Id of the last Job we created, select Job Id from the 'Search' drop-down, then enter the value into the 'Search For' box. Click the Retrieve button. If you can't recall the Job Id, leave the box blank and all Jobs will be retrieved.

The system will display a table showing the selected Jobs. If you select 'Details' from the Selection Options box, you will see a complete record for each Job.

Most of the information should be familiar to you by now, except for the 'Currently Open by' column. This shows you the name of the Operator who currently has a particular Job open in their web browser for updating. Using this you can avoid two people attempting to work on the same Job at the same time.

The left most column may have several links (the actual number depends on your privileges) for each Job. For the moment we just want to Action an existing Job, so click the 'Action' link.

The system will display the 'Edit Helpdesk Job' page which is the same as the New Helpdesk Job page with the following exceptions:

Make any changes you wish, then click the Update button. This will take you to the 'Update Job' page.


Creating a Child Job

A Child Job is simply a Job which must be completed before its parent job may be marked as completed. You might use this facility where e.g. you have a machine repair that needs components from several suppliers and you wish to track the progress of each 'sub-job'.

You should be on the 'Update Job' page having just Actioned a Job. Click the 'Create child of this job?' link.

This will send you back to the 'New Helpdesk Job' page which you have seen before. The only difference now is that the Parent Job Id is displayed. Make any changes you wish then click the Update button.

You should be back at the 'Update Job' page. Notice that the 'Create child of this job?' link is not displayed - this is because a Child Job cannot be a Parent, i.e. there is no concept of 'grandchild', 'great-grandchild' etc. jobs.

Click the 'Action this Job Link' to take you back to the 'Edit Helpdesk Job' page, then click the link in the 'Parent Job Id'. This will open the 'Edit Helpdesk Job' page for the parent Job.

Mark the parent Job as Completed, then click the Update button. This will also close any child jobs.


Uploading files to link to a Job

Sometimes it can be useful to link files to a Job e.g. screen dumps of error messages. There are two ways you can do this:

We will assume you have just updated a Job and clicked on the link "Upload files to link to this Job". This will open a new window which allows you to to select the file you wish to be uploaded and enter a short description."

When the Upload button is clicked, the system will transfer the file to the location you have specified as your upload directory and create links from the Job to this file. The file will be named according to the following format:

XXXXXX_originalname_YYY.originalextension.

Where XXXXXX is the Job Id and YYY is a number starting with 0 and incrementing if there already exists a linked file with the same original name. For example, if the original file is called screen.bmp and it is linked to Job Id 200, then the Linked file will be saved with a name of 0000200_screen_000.bmp


Customize e-mails sent by the helpdesk

The content and subject of each of these message types is read from a template text file, which you are free to modify. They are:

Templates for emails sent to the operator and contact when a Job is actioned:
email_job_closed_contact.txt
email_job_closed_operator.txt
email_job_hold_contact.txt
email_job_hold_operator.txt
email_job_open_contact.txt
email_job_open_operator.txt

Templates for emails sent to the operator and and the manager when a Job is escalated:
email_job_escalate_manager.txt
email_job_escalate_operator.txt


These files must be placed in the same folder as you installed the web helpdesk. If you delete them, a default subject and message body will be used.

You may edit these files using Notepad or similar text editor only. Here is an example of one:

'JOB EMAIL TEMPLATE - JOB STATUS = OPEN
'SENT TO - CONTACT
'
'Please see the helpfile for information on using/modifying this file
#SUBJECT=Helpdesk Job #JOB_ID
Your helpdesk job has been updated/created and can be viewed using this link: #GSTLOGIN
(please use the entire url, which may have wrapped onto more than one line)
#HISTORY


Please note:

Special Keywords

#GSTLOGIN - this is the url which allows the guest to login and then go straight to a particular Job
#OPLOGIN - this is the url which allows the operator to login and then go straight to a particular Job
#JOB_ID - the job id
#PARENT_ID - the job id of any parent job
#CREATED - the date time the job was created.
#LAST_ACTIONED - the date time the job was actioned (same as CREATED if this is the first action).
#ACTIONED_BY - the name of the operator that actioned the job
#TO_COMPLETE_BY - the target completion date.
#COMPLETED_ON - date the job was actually completed.
#JOB_STATUS - the current job status,
#HOURS_OVERDUE - how many hours overdue (negative if not)
#DAYS_OVERDUE - how many days overdue (negative if not)
#ELAPSED_HOURS - number of hours elapsed since first created (ignoring office hours).
#ELAPSED_DAYS - number of days elapsed since first created (ignoring office hours).
#PROBLEM - Problem description
#TO_DO - To Do description
#SOLUTION - Solution description
#HISTORY - the complete job history
#PASSED_TO - the operator this job was passed on to
#CURRENTLY_OPENED_BY - who has the job open at the moment (if anyone)
#EMAIL_PASSED_TO - the email address of the operator it was passed to
#TIME_SPENT - the amount of time logged against this action ONLY
#MONEY_SPENT - the amount of money logged against this action ONLY
#TOTAL_TIME_SPENT - the amount of time spent so far
#TOTAL_MONEY_SPENT - the amount of money spent so far
#NOTES - the notes of the last action
#CATEGORY - Current job category
#PRIORITY - Current job priority
#JOB_CUSTOM1 - Job Custom1 field value
#JOB_CUSTOM2 - Job Custom2 field value
#ASSET_NUMBER - Asset information (if relevant)
#ASSET_DESCRIPTION
#ASSET_MANUFACTURER
#ASSET_MODEL_NUMBER
#ASSET_SERIAL_NUMBER
#ASSET_PURCHASE_DATE
#ASSET_COMMENT
#ASSET_DISPOSAL_DATE
#ASSET_PURCHASE_ORDER
#ASSET_INVOICE_NUMBER
#ASSET_PURCHASE_PRICE
#ASSET_VENDOR
#ASSET_TYPE_DESCRIPTION
#CONTACT_TITLE - customer contact information:
#CONTACT_FORENAME
#CONTACT_SURNAME
#CONTACT_JOB_TITLE
#DEPARTMENT_NAME
#DEPARTMENT_LOCATION
#CUSTOMER_NAME
#CUSTOMER_REFERENCE
#CONTRACT_EXPIRY
#JOB_ALLOWANCE



What are Guests?

Guests are Customer Contacts who you have allowed to access the Web Helpdesk. Guest access minimizes telephone calls or e-mails to your helpdesk because customers can:

If you require a Guest to have more privileges you should define a special Operator, specify the privileges you wish them to have, then tell them the password needed to log on as that Operator

A Customer Contact must have an e-mail address and a password specified (see here for details) before they can log in as a Guest. You must also have allowed Guest access when configuring LBE Web Helpdesk.


Logging as a Guest

Point your browser at gstlogin.asp. The system will display the Guest Login page and asks for an e-mail address and a password. If the Guest has forgotten their password they can click the 'I have forgotten my password' button and the system will mail the password associated with the entered e-mail addess.

The default database doesn't have any Guests registered so, click on the 'register' link now.


Registering a new Guest

You should be at the 'Guest Registration' page. This page allows a new Guest to enter their information into the Helpdesk system. If you wish to prevent Guests from self-registering you will need to disable this when configuring LBE Web Helpdesk.

The required fields on this screen are:

Depending on your configuration and Organization Structure there may be a drop-down list for them to choose the Customer/Department they belong to or text boxes to enter this information. If a drop-down list is provided then they must make a selection before continuing.

If text boxes are provided then these values are optional. If they provide Customer and Department information they will automatically be assigned to that Department and Customer if it already exists, if not, it will be created. A Helpdesk Operator with the appropriate privileges can re-assign them to another Customer/Department if they made a mistake (e.g. not entering the exact name of an existing Customer). If no Customer/Department information is provided they will be assigned to a Customer called 'Guests', and a department 'All Departments'.

For now, enter your e-mail address, surname and password then click the Submit button.

Assuming registration was successful you will be shown a link which takes you back to the 'Guest Login' page, where you should enter the e-mail address and password you provided earlier.

When you click the Submit button you will be taken to the 'Trial Version' page or straight to the Jobs Search page. Notice that at the top of the page you have a short menu, with a limited set of options available to you.

If you are not already at the 'Jobs Search' page, select the 'Search Jobs' link at the top of the page. If you then click the Retrieve button, you will notice that no Jobs are retrieved despite the fact we created some earlier. This is because the Guest user can only see those Jobs where they are the Customer Contact.


Customer Hierarchy

LBE Web Helpdesk uses a hierarchy of Customer Information as follows:

Customers
Departments
Contacts

You can specify an Organization Structure that matches your structure and the system will adapt by hiding irrelevant information. E.g. if you are dealing with internal customers only, select "Single Customer, Multiple Departments" and the system will hide references and input fields related to Customer in most windows


Adding/Editing a Customer

You should be at the 'Customers Maintenance' page.

At the top of the page you will see a 'Selection Options' box, this is used to specify which Customers are retrieved. You can select an item you wish to search against (e.g. Customer Name) then enter the value you are looking for. You don't need to type the full value as the search will retrieve all records where your value is part of the selected search item. You can specify the sort order the Customers are displayed in and the number of records to show per page.

For now, leave the search value empty and click Retrieve. This will return all Customers. LBE Web Helpdesk ships with a sample Customer named 'Sample Customer' and this should be displayed below the 'Selection Options' box.

At the end of the customer information there should be a number of links: Edit, Delete, Departments, Contacts and Assets. We will return to the first two of these shortly. The Departments link is a quick way of displaying the Departments that belong to this Customer, similarly the Contacts link will show this Customer's Contacts, and the Assets link will show the Assets that belong to this Customer.

Click the 'New Customer' link just below the 'Selection Options' box. This will take you to the 'New Customer' page.

There are a number of entry fields on this page, we will go through each of them in turn:

Name

This is how the Customer will be identified.

Reference

You might use this field if you already have some form of reference number for each customer.

Address/Tel/Fax/Mobile

These entry fields are straightforward.

Contract Expiry Date

If you wish, you may set the expiry date for this customer's support contract. After this time, you will no longer be able to Action Jobs for this customer (unless you have override privilege ). If you don't wish to use this facility, set it to a date far in the future.

If the Customer's contract expiry date has passed, none of their Contacts will be able to log in as a Guest.

New Jobs Allowance

If you wish, you may limit the number of new Jobs this customer's support contract allows. Each time a new job is created, this figure will reduce, when it reaches zero, you will no longer be able to create new Jobs for this customer (unless you have override privilege). If you don't wish to use this facility, set it to a large value.

If the Customer has used up all their New Jobs Allowance, their Contacts will not be able to create new Jobs when they log in as Guest.

Custom 1/Custom 2

These entry fields may well have been renamed by you. They are provided so that you can keep information about each Customer that is particular to the way you run your business.

Notes

Any further information you wish to keep.

Delete Button

This is not shown when creating a new Customer, if you were editing an existing Customer this would allow you to delete the Customer.

When you are happy with your entries, click the Update button.


Adding/Editing Departments

You should be at the 'Update Customer' page having just created a new Customer. Assuming there were no errors, the system will display the following links:

Click the 'Edit the Default Department' link. This will display the 'Edit Customer Department' page. We will look at each entry field in turn:

Name

This identifies the Department

Location

You might use this to keep e.g. a building or floor number

Custom 1/Custom 2

These entry fields may well have been renamed by you. They are provided so that you can keep information about each Department that is particular to the way you run your business.

Customer

You will see either a text box for you enter a full or partial customer name or a drop down list which displays all the available values for you to select from, depending on your Personal Preferences and your Organization Structure. Just to the right of the drop-down list there may be a button marked with a '+' to add a new item to the drop-down or 'Search' to select a Customer.

You may change the selected Customer if you wish, this will have the effect of moving the Department (and all of the Customer Contacts which belong to that Department) to the new Customer.

Delete Button

This is only shown when editing an existing Department.

Update Button

This will update the database and create any new Customer you may have added by clicking the '+' button (see above).

Make any changes you wish, then click the Update button. The ' Update Customer Department' page will displayed, confirming that the update was successful or displaying any errors.

Now press the Back button on your browser until you reach the 'Update Customer' page, then click the 'Edit this Contact' link to edit the default Contact for the Customer we created earlier.


Adding/Editing Contacts

You should be at the 'Edit Customer Contact' page. Most of the entry fields on this page are self-explanatory, so we will just explain the others:

Customer/Department

You will see either a text box for you enter a full or partial department name or a drop down list which displays all the available values for you to select from, depending on your Personal Preferences and your Organization Structure. Just to the right of the drop-down list there may be a button which will be marked with a '+' to add a new item to the drop-down or 'Search' to select a Department.

Password

If you wish this Contact to have Guest access to the Helpdesk, you must enter a password for them.

Delete Button

This is only shown when editing an existing Contact.

Update Button

This will update the database and create any new Customer/Department you may have added by clicking the '+' button (see above).

Make any changes you wish, then click the Update button. The ' Update Customer Contact' page will displayed, confirming that the update was successful or displaying any errors.


Adding/Editing Assets

Assets are items (usually physical) which belong to a Customer, e.g. hardware, software, furnishings, fittings etc. By identifying the Asset that is involved in a Helpdesk Job, you may be able to reduce future problems.

To view the Assets for a particular Customer, select 'Customers' from the drop-down list at the top of the page. You can then choose the Customer, and click the 'Assets' link on that Customer's information, or click the 'Existing Assets' link and enter the Customer Name in the 'Selection Options' box at the top of the page.

We will assume you have reached the 'Customer Assets/Inventory Maintenance' page. To create a new Asset, click the 'New Customer Asset' link. This will take you to the 'New Customer Asset' page. Most of the information on this page is self-explanatory, so we will just look at two of the entry fields:

Asset Type

This displays a drop-down list of Asset Types, you may change the selected Asset Types if you wish. Next to this drop-down list is a '+' button, click this to add a new Asset Types to the list.

Customer

You will see either a text box for you enter a full or partial customer name or a drop down list which displays all the available values for you to select from, depending on your Personal Preferences and your Organization Structure. Just to the right of the drop-down list there may be a button which will be marked with a '+' to add a new item to the drop-down or 'Search' to select a Customer.

You may change the selected Customer if you wish, this will have the effect of moving the Asset to the new Customer.

Delete Button

This is only shown when editing an existing Asset. You can not delete any Assets which have Jobs linked to them.

Update Button

This will update the database and create any new Customer and/or Asset Types you may have added by clicking the '+' button (see above).

Make any changes you wish, then click the Update button. The ' Update Customer Asset' page will displayed, confirming that the update was successful or displaying any errors.


Personal Preferences

Select Maintenance from the main menu. The Maintenance page will be displayed, find the section titled Personal Preferences.

This gives you the choice of using Search boxes or drop-down lists on those pages where you have to select a Customer, Contact or Asset. Choosing Search boxes will speed up the loading of pages as the system does not have to populate the drop-down list, they can also make it easier to find the value you wish to use.

You may also choose what you want to happen when you change the Priority of a Job - the system can prompt you to reset the target date/time based on the new Priority or you can opt for it to be left unchanged.


Linked File Options

Select Maintenance from the main menu. The Maintenance page will be displayed, find the section titled System Options.

Default Location for Files Linked to Jobs

Enter the default location where you keep your linked files. You should use a UNC path (e.g. \\servername\c\foldername\filename) so that all operators can access these files regardless of their drive mappings.

Allow changes to Linked files when Job is closed?

If this box is checked, you can still make changes to a Job's linked files, even if the Job is closed.

Uploading

When the end user uploads a file, it is actually the web server which is doing the work, and it is impersonating the Anonymous User (IUSR_machinename) to do so. When the system checks to see if the linked files exist, it executes this check on the web server under the anonymous user's (IUSR_machinename) authentication, just as if you were to physically logon to the web server as the anonymous user, then try to use windows explorer to get to the same file.

Therefore, the Anonymous User (IUSR_machinename) needs to have Create permissions in this folder and needs to be able to reach it via the path you enter above. If the machine containing the linked files is NOT the same machine as the web server, then the anonymous user on the web server would not be authenticated on the target machine. You may need to make this user a domain user.

You will find further useful information at: http://support.microsoft.com/support/kb/articles/q207/6/71.asp. In particular, make sure that Auto Password Synchronization is OFF.

Downloading

When a linked file is presented on the web page it can be presented as either a file: or http: link.

To enable the system to display linked files with http: links, you need to configure LBE Web Helpdesk and specify a value for LinkUrl which points to the location of the linked files. If you leave LinkUrl set to "" (the default), linked files will be displayed using a file: link and any users will need network privileges to see these files.


Job History Order Options

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page, then find the System Options section.

When a Job is Actioned, the system keeps an audit trail of the information in the Job History. You can choose to have this entered so that most recent Actions are shown first or last. Click the link entitled 'Job History Order'. This will take you to the 'Job History Order' page. Select the order you wish the Job History to be kept, then click the Update button.

The system will display a message confirming the update was successful or any error messages if there was a problem. The change will only affect new Jobs, existing Jobs will carry on using whatever the setting was at the time they were created.


Items to Include in Job History

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page, then find the System Options section. Click the link entitled 'Items to include in Job History' this will take you to a page with check boxes for each of the items that you wish to be included.


Custom Fields

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Custom Fields are used provided in a number of places throughout LBE Web Helpdesk. These fields may be renamed by you and used to store information which is particular to your business. Scroll down until you can see the section entitled 'Custom Fields'. You should see a link entitled 'Rename Custom Fields'.

Click the 'Rename Custom Fields' link. This will take you to the 'Custom Fields' page. You will see a table with a row for each section which uses Custom Fields. Change the value in each of the two custom fields to whatever you wish. then click the Update button.

(N.B. If you don't wish to use one or more custom fields, set them to blank, this will prevent them from being displayed in any of the web pages.)

If you wish the custom field to display a drop-down list of options, enter a list of phrases separated by a semi-colon (;). The first phrase will be used as the caption, the rest as the options in the drop-down list. For example, entering "Charge Code;Internal;External;No charge" will display a field named "Charge Code" with a drop-down list containing the values "Internal", "External" and "No charge"

If you want to make selection of a value optional, enter a blank as one of the phrases, e.g. "Charge Code;;Internal;External;No charge" will give a drop-down list where the first option is empty.

The system will display a message confirming the update was successful or any error messages if there was a problem.


Organization Structure

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page, then find the System Options section. Click the Organization Structure link.

This will take you to a page where you can choose the Organisation Structure setting that matches the type of Organization you are supporting:There are 4 options:

OptionTypically used by
(A) Single Customer, single Department, multiple ContactsHelpdesk of a small company supporting internal users only.
(B) Single Customer, multiple Departments, multiple ContactsHelpdesk of a medium to large company supporting internal users only.
(C) Multiple Customers, not split into Departments, multiple ContactsHelpdesk supporting a number of small external companies.
(D) Multiple Customers, Departments and ContactsHelpdesk supporting a number of medium to large external companies.

If in doubt, choose the default Organization Structure is (D).

Select the appropriate Organization Structure from the drop-down list at the bottom of the window. You may change this value at any time as long as your data support it. For example if you already have several Customers defined, the system will not let you select options C and D. In this case you will need to delete all but one Customer before you can make these choices. (see also - how to hide records).

N.B. It is possible to e.g. create multiple Customers after you have set your organization structure to option A or B. However if you do so, the system will automatically reset the Organization type to the appropriate value.


Auto-escalation Notification

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page, then find the System Options section.

Select Auto-escalation Notification. This will take you to a page where you can control the notification e-mails produced when a Job is escalated in priority. You can specify if the Operator assigned to each escalated job is notified and/or another e-mail address (e.g. to notify a manager).


Asset Types

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Asset Types are a way of classifying Customer Assets, doing so helps you to identify which types of Asset cause more than their fair share of helpdesk problems. Scroll down until you can see the section entitled 'Asset Types'. You should see two links, 'Existing Asset Types' and 'New Asset Type'.

Click the 'Existing Asset Types' link. This will take you to the 'Asset Types Maintenance' page. At the top of the page is a 'Selection Options' box. This allows you to search for a particular Asset Type, specify the sort order of retrieved records and limit the number of records displayed per page.

We wish to retrieve all Asset Types, so leave the 'Containing' entry field empty and click the Retrieve button. You should see several records retrieved.

Each Asset Type has:

Editing

Click the 'Edit' link. This will take you to the 'Edit Asset Type' page. Make any changes you wish then click the Update button.

The system will display a message confirming the update was successful or any error messages if there was a problem.

Click the Back button on your browser until you return to the 'Asset Types Maintenance' page, then click the Refresh button on your browser, or click the Retrieve button on the page, and you will see the changes you have made reflected in the retrieved records.

New

Now click the 'New Asset Type' link, this will take you to the 'New Asset Type' page, which is identical to when you were editing an Asset Type, except that all the entry fields are empty. Give your new Asset Type a name then click the Update button.

Deleting

Move back to the 'Asset Types Maintenance' page and click the Retrieve button, your new Asset Type will be included in the retrieved records. Click the Delete link. This will display the 'Update Asset Type' page with a Delete button which allows you to confirm the deletion. Click this button now and the system will display a message confirming the deletion was successful or any error messages if there was a problem.

Move back to the 'Asset Types Maintenance' page and click the Retrieve button, the Asset Type you have just deleted will not be included in the retrieved records.


Categories

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Categories are a way of classifying Jobs, doing so helps you to identify which types of Job cause more than their fair share of helpdesk problems. Scroll down until you can see the section entitled 'Categories'. You should see two links, 'Existing Categories' and 'New Category'.

Click the 'Existing Categories' link. This will take you to the 'Category Maintenance' page. At the top of the page is a 'Selection Options' box. This allows you to search for a particular Category, specify the sort order of retrieved records and limit the number of records displayed per page.

We wish to retrieve all Categories, so leave the 'Containing' entry field empty and click the Retrieve button. You should see several records retrieved.

Each Category has:

Editing

Click the 'Edit' link. This will take you to the 'Edit Category' page. Make any changes you wish then click the Update button.

The system will display a message confirming the update was successful or any error messages if there was a problem.

Click the Back button on your browser until you return to the 'Categories Maintenance' page, then click the Refresh button on your browser, or click the Retrieve button on the page, and you will see the changes you have made reflected in the retrieved records.

New

Now click the 'New Category' link, this will take you to the 'New Category' page, which is identical to when you were editing an Category, except that all the entry fields are empty. Give your new Category a name then click the Update button.

Deleting

Move back to the 'Categories Maintenance' page and click the Retrieve button, your new Category will be included in the retrieved records. Click the Delete link. This will display the 'Update Category' page with a Delete button which allows you to confirm the deletion. Click this button now and the system will display a message confirming the deletion was successful or any error messages if there was a problem.

Move back to the 'Categories Maintenance' page and click the Retrieve button, the Category you have just deleted will not be included in the retrieved records.


Priorities

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Priorities are a way of classifying Jobs, doing so helps you to manage the order in which you deal with Jobs. Scroll down until you can see the section entitled 'Priorities'. You should see two links, 'Existing Priorities' and 'New Priority'.

Click the 'Existing Priorities' link. This will take you to the 'Priorities Maintenance' page. At the top of the page is a 'Selection Options' box. This allows you to search for a particular Priority, specify the sort order of retrieved records and limit the number of records displayed per page.

We wish to retrieve all Priorities, so leave the 'Containing' entry field empty and click the Retrieve button. You should see several records retrieved.

Each Priority has:

Editing

Click the 'Edit' link. This will take you to the 'Edit Priority' page. Make any changes you wish then click the Update button.

The system will display a message confirming the update was successful or any error messages if there was a problem.

Click the Back button on your browser until you return to the 'Priorities Maintenance' page, then click the Refresh button on your browser, or click the Retrieve button on the page, and you will see the changes you have made reflected in the retrieved records.

New

Now click the 'New Priority' link, this will take you to the 'New Priority' page, which is identical to when you were editing an Priority, except that all the entry fields are empty. Give your new Priority a name then click the Update button.

Deleting

Move back to the 'Priorities Maintenance' page and click the Retrieve button, your new Priority will be included in the retrieved records. Click the Delete link. This will display the 'Update Priority' page with a Delete button which allows you to confirm the deletion. Click this button now and the system will display a message confirming the deletion was successful or any error messages if there was a problem.

Move back to the 'Priorities Maintenance' page and click the Retrieve button, the Priority you have just deleted will not be included in the retrieved records.


Working Hours

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Working Hours are used in the calculation of a Job's default Target Completion date/time, based on the default Priority. Scroll down until you can see the section entitled 'Working Hours'. You should see a link entitled 'Edit Working Hours'.

Click the 'Edit Working Hours' link. This will take you to the 'Working Hours' page. You will see a table with a row for each day of the week. Enter the start and end times for each day using 24 hour notation for the hours. Setting all times for a day to 00 will make it a non-working day.

Make any changes you wish then click the Update button.

The system will display a message confirming the update was successful or any error messages if there was a problem.


Helpdesk Operators

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Helpdesk Operators are the people who use the helpdesk system. Scroll down until you can see the section entitled 'Helpdesk Operators'. You should see two links, 'Existing Helpdesk Operators' and 'New Helpdesk Operator'.

Click the 'Existing Helpdesk Operators' link. This will take you to the 'Helpdesk Operators Maintenance' page. At the top of the page is a 'Selection Options' box. This allows you to search for a particular Helpdesk Operator, specify the sort order of retrieved records and limit the number of records displayed per page.

We wish to retrieve all Helpdesk Operators, so leave the 'Containing' entry field empty and click the Retrieve button. You should see at least one record retrieved.

Each Helpdesk Operator has:

Editing

Click the 'Edit' link. This will take you to the 'Edit Helpdesk Operator' page. You will see a number of additional fields displayed:

Most privileges are self-explanatory, some need further explanation:

Make any changes you wish then click the Update button.

The system will display a message confirming the update was successful or any error messages if there was a problem.

Click the Back button on your browser until you return to the 'Helpdesk Operators Maintenance' page, then click the Refresh button on your browser, or click the Retrieve button on the page, and you will see the changes you have made reflected in the retrieved records.

New

Now click the 'New Helpdesk Operator' link, this will take you to the 'New Helpdesk Operator' page, which is identical to when you were editing a Helpdesk Operator, except that all the entry fields are empty. Give your new Helpdesk Operator a name then click the Update button.

Deleting

Move back to the 'Helpdesk Operators Maintenance' page and click the Retrieve button, your new Helpdesk Operator will be included in the retrieved records. Click the Delete link. This will display the 'Update Helpdesk Operator' page with a Delete button which allows you to confirm the deletion. Click this button now and the system will display a message confirming the deletion was successful or any error messages if there was a problem.

Move back to the 'Helpdesk Operators Maintenance' page and click the Retrieve button, the Helpdesk Operator you have just deleted will not be included in the retrieved records.


Clear Operator Activity

You should be at the 'Maintenance' page. If not, select 'Maintenance' from the drop-down list at the top of the page.

Each time a Job is actioned, the system records cost, time, the operator and date of the action. This is in addition to the Job History. This Operator Activity information enables you to report on the efficiency of each operator. Occasionally you may wish to clear this information for a specified period.

Click the link entitled 'Clear Operator Activity '. This will take you to the 'Clear Operator Activity' page. Select the start and end dates for the period you wish to clear, then click the Delete button.

The system will display a message confirming the operation was successful or any error messages if there was a problem.


Logging Off

Each connected user consumes valuable server resources. In addition your licence may allow you a limited number of concurrent users for LBE Web Helpdesk. Therefore it is important for you to log off the system when you are finished rather than depending on the system to automatically log you off, which will happen after a period of inactivity defined by the Session.Timeout value when configuring LBE Web Helpdesk


Hiding Records without Deleting them

Deleting records is permanent and when e.g. you delete a Customer, all related records are deleted as well. This will obviously affect your reporting. Sometimes you might want to disable e.g. a Customer or Operator so that they can't be used.

To do this you will need to open the database in the relevant tool and update a record manually. Most tables in the database have a column named Deleted. Normally this is set to 0. To disable this record, set the value to 1. For example, to hide a particular Customer, open the Customers table, locate the Customer record you wish to disable and set the Deleted value to 1. You can do this for Customers, Departments, Contacts, Operators, Assets, Asset Types, Categories and Prioirities.


Error Logging

Warning messages are displayed to the user. More serious errors are saved in a database table named 'exception' along with the date, time, remote address, login name and the error message. You can delete records at any time, using MS Access, SQL Server Enterprise Manager or Oracle Sql Plus as appropriate.


Protecting your data

Security

If you are using Oracle or Sql Server as your database, you may wish to modify the standard scripts that are provided (see either MSSQL or ORACLE folders in the helpdesk installation directory) so that the user and object security is suitable for your organization.

The Access database could be secured, but we have chosen not to do so because we feel that this causes more problems than it solves.

Once you have the web helpdesk up and running you should delete the testfile.asp file. The results generated by this file could give a potential hacker valuable information about the setup of your system - especially the location of your database.

If you are using Access, you have to give the anonymous user (IUSR_machinename) Full Control permissions in the folder containing the helpdesk.mdb file. To simplify installation, we install this file in the web helpdesk folder. However, once you have the system running OK, you should move the helpdesk.mdb into a different folder (preferably one not below the inetpub folder). You will then need to amend the location with the Configure LBE Web Helpdesk utility to reflect its new location. Give the anonymous user Full Control permissions in the new location and allow them read and Execute permissions only in the web helpdesk folder.

Data

Access is not as robust as Oracle or Sql Server. It is more prone to corruption, which can be caused by e.g. faulty network cards, 'blue screens', out of date database drivers. However, many people have used it for years without problems. Nevertheless it is vital you have a good backup policy in place.

Sql Server and Oracle are much more robust, coping easily with 'blue screens' etc. However, you still need to have a backup policy which you know works (i.e. you have successfully restored a backup as a test).

Compacting your Access database

As your Access database grows, records are deleted and moved; you will find that you need to compact it to recover lost space. Doing so also can prevent corruption. To compact your Access database, you will need MS Access or use our Desktop Helpdesk.


Database Structure

The following diagram shows the major tables in the helpdesk database. You may find it helpful if you are creating your own reports or importing data from other programs:


Reports

LBE Helpdesk ships with a large number of reports. Click the Reports option in the main menu to see a list


Creating your own reports

LBE Helpdesk comes with many reports, however you may reach a point at which you need to write your own. There are a number of options:

Probably the best option is to use Access. If you are using an Access database for the helpdesk then you can create the reports directly into the same database. If you are using either Sql Server or Oracle, then it is probably best to create a new Access database and link to the helpdesk tables.

When creating your reports, please bear in mind the database structure.


Customization

In Configuring we showed how you could change the title of each page and the logo displayed. You can do this without needing to know HTML.

If you wish to make more radical changes then the following options are available to you:

If you choose any of the above options, you need to be aware that this will limit your options for future upgrades as you, or we, will need to re-apply to the new release any modifications you have made.


Copyright Leigh Business Enterprises Ltd. 2003