What is the purpose of the Vontu\Protect\tools\sql SQL scripts
There are five SQL scripts under the folder \Vontu\Protect\tools\sql. These five SQL scripts are used for some kind of auditing purposes.
ClearAdminLockout.sql - Used to unlock DLP Administrator account. The DLP Administrator account will be locked due to multiple failed login attempts.
ClearSystemEvents.sql - This script 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.