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-2870: How to use the sample script from the DA SDK for archiving a Auditstore database.

Auditing and Monitoring Service ,  

12 April,16 at 11:42 AM

Applies to: Centrify DirectAudit 2.x
 
Question:

How to use the sample script from DA SDK for archiving Auditstore database?

Answer:

DirectAudit SDK comes with a job rotation VBscript that could ease the process of archiving an active AuditStore database. 
Tasks includes creating a new AuditStore, setting it active and linking it to collectors.

1. Download "CentrifyDA-SDK-2.0.2-win" from the Centrify Support Portal.

2. Install the package on the Windows machine which hosts the DA Administrator Console

3. Bring up the command line console and change directory to the package folder, e.g.:
 
  cd c:\CentrifyDA-SDK-2.0.2-win

4. Run the script with 5 arguments:
 
  cscript.exe db_rotation_sql_script.vbs <installation-name> <audit-store-name> <sql-server-name> <audit-store-database-prefix-name>

5. Detach the AuditStore database from DA Console e.g:

  DirectAudit Administration -> CurrentInstallation -> Audit Stores -> Databases -> OldAuditStore (right-click) -> Detach

6. Detach the AuditStore database from SQL server e.g:

  ServerHostName -> Databases -> OldAuditStore (right-click) -> Tasks -> Detach

7. The OldAuditStore database can now be archived to another storage.
 

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

Related Articles

 articleKB-6044: How to configure users for automatic Kerberos Credentials for infinite renewal even after users have logged out? articleKB-6050: How to configure a group for automatic Kerberos Credentials for infinite renewal? articleKB-4600: How to create new databases for DA every month with an automated process and make the old databases read only? articleKB-6041: How to show current license type in use by adclient? articleKB-6073: How to join the Linux/Unix Centrify Server to Active Directory with specific Computer Role? articleKB-6040: How to change the license type in use after adclient successful joined to the AD? articleKB-6038: How to specify the license type to use when joining the server to AD using adjoin? 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