Layton ServiceDesk - Utilities - Clear Down Database

From Layton Support
(Difference between revisions)
Jump to: navigation, search
(Created page with '== Wiping the Database == The clear down database function clears out all data in the database so that the system can be started afresh. This is intended to be used when the sy…')
 
m (Minor formatting changes)
 
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
== Wiping the Database ==
+
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>
 +
<p align="right">[[File:btn_back_up.png|link=Layton ServiceDesk - Utilities - Purging]] [[Layton ServiceDesk - Utilities - Purging |<u>Previous article in this series: ''Purging''</u>]]</p>
 +
__FORCETOC__
 +
=Overview=
 +
The ''Clear Down Database'' function clears out non-configuration data in the database so that the system can be started afresh. This is intended to be used when the system has been evaluated and the user wishes to start again for a live system. Any Form Designs and Global List Views that have been configured will not be affected.
  
The clear down database function clears out all data in the database so that the system can be started afresh.  This is intended to be used when the system has been evaluated and the user wishes to start again for a live system.  This will delete all Requests, Tasks, Problems, Changes, all Company Structure data such as Sites, Companies, Departments, Analysts (Except for the Admin Account) and End Users.  It will also delete all the Library items. 
 
  
Any Form Designs and Global List Views that have been configured will not be affected.
+
[[File:Lsd util clear down db.png|center|link=]]
  
The Analyst must be logged in as the “Admin” account. A confirmation prompt will appear asking if you are sure you want to do this.
+
=Data Deleted=
 +
Specifically, this will delete the following:
 +
 
 +
*All Requests
 +
**Associated Comments
 +
**Associated Costing information
 +
*Problems
 +
*Changes
 +
*Tasks (excluding '''[[Layton ServiceDesk - Logging a New Task#Creating a New Recurring Task|Recurring Tasks]]''')
 +
*Whiteboard Messages
 +
*Surveys
 +
*Reminders
 +
*Unprocessed Incoming and Outgoing Mail.
 +
 
 +
All other data will not be affected.
 +
 
 +
=Procedure=
 +
<span style="color:red">'''Be sure you are ready to delete the data in your database prior to doing this procedure. You should consider firstly backing up your database in case you need to recover the deleted data.'''</span>
 +
 
 +
#Log in as ''Admin''. No other account can do this operation. If logged in as other accounts, an error will display.
 +
#''Optional'': Enter a value in the ''Reset IDs to'' field. The default is ''1''. The first Request, Problem, Change and Task created after the Clear Down Database procedure will have this ID.
 +
#Click the Confirm button [[File:Lsd btn confirm 24px.png|link=]].
 +
#When the operation is complete, the message ''Database Cleared'' will appear.
 +
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p>

Latest revision as of 02:19, 30 August 2016

Btn back up.png Back to Contents

Btn back up.png Previous article in this series: Purging

Contents

[edit] Overview

The Clear Down Database function clears out non-configuration data in the database so that the system can be started afresh. This is intended to be used when the system has been evaluated and the user wishes to start again for a live system. Any Form Designs and Global List Views that have been configured will not be affected.


Lsd util clear down db.png

[edit] Data Deleted

Specifically, this will delete the following:

  • All Requests
    • Associated Comments
    • Associated Costing information
  • Problems
  • Changes
  • Tasks (excluding Recurring Tasks)
  • Whiteboard Messages
  • Surveys
  • Reminders
  • Unprocessed Incoming and Outgoing Mail.

All other data will not be affected.

[edit] Procedure

Be sure you are ready to delete the data in your database prior to doing this procedure. You should consider firstly backing up your database in case you need to recover the deleted data.

  1. Log in as Admin. No other account can do this operation. If logged in as other accounts, an error will display.
  2. Optional: Enter a value in the Reset IDs to field. The default is 1. The first Request, Problem, Change and Task created after the Clear Down Database procedure will have this ID.
  3. Click the Confirm button Lsd btn confirm 24px.png.
  4. When the operation is complete, the message Database Cleared will appear.

Btn back up.png Back to Contents

Personal tools
Namespaces

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