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


Article ID: 159903


Updated On:


Data Loss Prevention Enforce


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



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.  There is no ongoing provision for periodically clearing out this table.  It will grow and grow and grow.


ListAccountUserAction.sql - Audit report for user account changes.


ListUnsuccessfulLoginAttempts.sql - Audit report of failed login attempts.


ListUserSessions.sql - Audit report of user sessions.