Summary

KB0014442 explains how to clean-up the OneSpan Authentication Server (OAS) audit database, when using an embedded MariaDB database.
This Article discusses how to do it on a MSSQL ODBC database, it is an extension of KB0014442 and only provide screenshots on how to do it in MSSQL.
Also check KB0014442 for details and principles.

Details.

In the tables vdsAuditMsg and vdsAuditMsgField, check (and change if needed) that the delete rule is set to  ‘Cascade’

Right-Click the Table and select Design
     

From the Table Designer Tab, select Relationships
      

Expand the INSERT and UPDATE specification, and set the Delete Rule to Cascade
     

     

Now you can delete records from vdsAuditMsg, and the related records in the vdsAuditMsgField will automatically be deleted.

You can first use a Select query to verify that the conditions are met correctly.
Eg: select * from identikey.dbo.vdsAuditMsg where vdsTimeStamp < '2024-10-01';
     

If the output is correct you can change “select *” by “Delete”.
Eg: Delete from identikey.dbo.vdsAuditMsg where vdsTimeStamp < '2024-10-01';

Remarks:

• It is advised to make a backup of the data before deleting it.

• Since OAS 3.16, you can configure the function to clean up the audit data automatically.
(Webadmin -> Servers -> Delete Audit Data. )

_________________________________________________________________________________________________________________

Security Status: External

Document type: How To

Applies to: Authentication Server 

Old KB Reference: 150111