Skip to content

I want to delete my Pleasanter log

Answer

  1. Set "DeleteSysLogs" in "BackgroundService.json"
  2. Delete with SQL. This page explains.

Overview

The procedure to delete Pleasanter's "log". Depending on usage, logs may become bloated, so please consider deleting logs as necessary. Deleting logs will not affect the operation of Pleasanter.

Cautions

  1. This procedure involves direct manipulation of the database, so it is dangerous. We strongly recommend that you take a "Backup" in advance.

Operation Procedure

  1. Log in to the server on which Pleasanter is installed.
  2. Launch "SSMS" (SQL Server Management Studio).
  3. Expand "Databases" from "Object Explorer" and select "Implem.Pleasanter" → Right-click → Click "New Query".
  4. Execute the following "1. SQL for deletion" to delete all logs.
  5. Execute the following "2. SQL for confirmation after deletion" to confirm that the logs have been deleted.

Code Samples

1. SQL for deletion

SQL
truncate table "SysLogs";

2. SQL for confirmation after deletion

SQL
select top 1000 * from "SysLogs";