Deep Security DB purge

help follow the steps below to identify which table in dsm database is eating up the space

1. Open and log in to Microsoft SQL Server Management Studio and connect to sql server where DSM database is located

2. Click the New Query button

3. Copy the following script into the New Query page or you can open the attached text file copy the content and paste it to the New Query page of Management studio.

========================

USE [DSM]

CREATE TABLE #temp (

table_name sysname ,

row_count INT,

reserved_size VARCHAR(50),

data_size VARCHAR(50),

index_size VARCHAR(50),

unused_size VARCHAR(50))

SET NOCOUNT ON

INSERT #temp

EXEC sp_msforeachtable 'sp_spaceused ''?'''

SELECT a.table_name,

a.row_count,

COUNT(*) AS col_count,

a.data_size

FROM #temp a

INNER JOIN information_schema.columns b

ON a.table_name collate database_default = b.table_name collate database_default GROUP BY a.table_name, a.row_count, a.data_size ORDER BY CAST(REPLACE(a.data_size, ' KB', '') AS integer) DESC

DROP TABLE #temp

===========================================

4.Click the Execute button

5. Export the results by pressing right click mouse of the results then select "Save Results As..." and send us a copy of the results.

reset the events tables

________________________________________________________________________________________________________________

1) On DSM server, open Command Prompt

2) Go to "C:\Program Files\Trend Micro\Deep Security Manager" folder

3) Then execute the command

dsm_c -action resetevents -type li

The command about will reset the Log Inspection Events.

Here are the other option you can use on type all - All Event Types fw - Firewall dpi - Deep Packet Inspection im - Integrity Monitoring li - Log Inspection

_____________________________________________________________________

DELETE FROM loginspectionevents WHERE LogDate < '2017-12-15'

____________________________________________________________________