Layton ServiceDesk - Utilities - Purging

From Layton Support
Jump to: navigation, search

Btn back up.png Back to Contents

Btn back up.png Previous article in this series: Request Export XML

Contents

Overview

Purging permits the user to purge selected records from the database.

It is highly recommended that you back up your database prior to purging operations, as there no way to restore purged requests. It's also recommended that no-one be using the system during a purging operation in case this causes the database to be modified after the point of last backup. If you purge the wrong item, you can immediately restore the backup without losing any data.


Lsd purging01.png


Life Cycle of an End User

  1. Import from AD.
  2. End User is used in Requests.
  3. End User no longer in organisation, disabled in system.
  4. Purging is done from time to time. The End User cannot be purged if it is still associated with a Request.
  5. Finally no Requests are left to which the End User is associated.
  6. Purging removes the End User.

The rule is that if an End User has been specified in the End User field in a Request, you can't purge or delete it. This is because there is a relationship between the data in the End User and Request tables. So purging will only delete End Users that don't appear in Requests. If you want to purge End Users, purge using all of the preceding options first.

Note that you can disable a user without purging it. See this article for more details.

Btn back up.png Back to Contents

Purging Options

  1. Begin by clicking the radio button that matches the type of data you want to purge. When you first load the page, no radio button is selected.
  2. Click the desired options for that type of data.

Requests

Lsd purging02.png

Delete Closed Request before

Choose a date. All Requests with a closure dated before that date will be deleted.

Purge All Closed

Purges any Request that has a status of Closed.

Purge Specific Request

Specify a Request ID to delete.

Problems

Lsd purging03.png

Delete Closed Problem before

Choose a date. All Problems with a closure dated before that date will be deleted.

Purge All Closed

Purges any Problem that has a status of Closed.

Purge Specific Problem

Specify a Problem ID to delete.

Changes

Lsd purging04.png

Delete Closed Change before

Choose a date. All Changes with a closure date before that date will be deleted.

Purge All Closed

Purges any Change with a status of Closed.

Purge Specific Change

Specify a Change ID to delete.

Tasks

Lsd purging05.png

Delete Completed Task before

Choose a date. All Tasks with a closure date before that date will be deleted.

Purge All Completed

Purges any Task with a status of Closed.

Solutions

A dormant Solution is a Solution that has not been applied or linked to any Requests or Problems.

Lsd purging06.png

Purge Dormant Solution

Deletes all solutions not in use.

End Users

A dormant End User is an End User that has not been associated with any Requests, Problems, Changes or Tasks.

Lsd purging07.png

Purge Dormant End User

Deletes End Users who have never logged a Request, or those that are no longer associated with past Requests by virtue of having purged them.

Archiving

While Layton ServiceDesk does not have a feature that can save data in an archive, then purge it, you could make a backup of the database using Microsoft SQL Server Management Studio, then do a purge. This gives you a database backup that you can load should you need to look earlier than what is currently in the database.

Next article in this series: Clear Down Database Btn forward.png

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox