Centrify

Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-6015: PurgeSessions tool cannot delete sessions after database roll back

29 September,16 at 04:10 PM

Applies to: Versions of DirectAudit >=2.x on all supported platforms 

Problem: 
After rolling back a SQL database to a previous state, the PurgeSessions tool is no longer able to find sessions to delete even though there are sessions matching the criteria specified by the PurgeSessions tool. Please refer to KB-3394: Is it possible to purge audit sessions older than 'x' number of days for how to use the tool. 

Cause: 

After a rollback, the old sessions may become stuck in terminated state with no end time. This state is excluded by the PurgeSessions tool by design.  

Resolution:

Use the attached SQL script to delete sessions that are in terminated, disconnected, or completed state and are older than x number of days. Default is set to 365 days. Please modify the value on line #9 as needed. This script is to be run against the target audit store database as a DBA.

 
Attachments:
PurgeSessionsSQLJob - V2.sql

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.

Related Articles

 articleKB-4666: Best practices for backing up and restoring DirectAudit database articleKB-3394: Is it possible to purge audit sessions older than 'x' number of days articleKB-3971: How to roll back to local account after unlinking from Account Migration Tool on Mac OS X articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-6041: How to show current license type in use by adclient? articleKB-6040: How to change the license type in use after adclient successful joined to the AD? articleKB-4439: How to convert a migrated account into a network account after unlinking from the Account Migration Tool on Mac OS X articleKB-6056: How to report the group policy settings that are in effect for the local computer? articleKB-2104: How to archive/delete DirectAudit data using SQL tools