What is the purpose of the ...\Protect\tools\sql SQL scripts?
search cancel

What is the purpose of the ...\Protect\tools\sql SQL scripts?

book

Article ID: 159903

calendar_today

Updated On:

Products

Data Loss Prevention Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

For auditing purposes, a customer will request the purpose of scripts in the tools directory:

<drive>:\Program Files\Symantec\DataLossPrevention\EnforceServer\x.x.xxxx\Protect\tools\sql

Resolution

  • ClearAdminLockout.sql - Used to unlock DLP Administrator account should it become locked due to multiple failed login attempts.

  • ClearSystemEvents.sql - This will clear all records from the systemevents table.  Systemevents table is used as a log by DLP to record system events for troubleshooting.  These do not delete during normal operation.

  • ListAccountUserAction.sql - Audit report for user account changes.

  • ListUnsuccessfulLoginAttempts.sql - Audit report of failed login attempts.

  • ListUserSessions.sql - Audit report of user sessions.