What is the purpose of the Vontu\Protect\tools\sql SQL scripts?
Last Updated February 09, 2015
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.
Imported Document ID: TECH219906
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe