Audit Logging

Audit Logging

File->System Configuration->Audit Logging

If Audit Logging is employed, you should remember that this will create records in the AUDITLOGGING Table

Current records can be displayed via General->Inquiries->Inquiry - Audit Logging

Audit Logging allows you to identify a specific field in an Ostendo Database which, when a record is added, changed, or deleted and this field is contained in that record then an Audit Log is created that records the old value and the new value along with the User that carried out the action and the Date and Time it was carried out

This function is extremely useful when trying to determined who or when a field value was written or Amended. Audit Logging should be used sparingly for a specific purpose and then removed once you have determined what you need. If ignored, this could significantly impact on the database size.

 NB: Turning off this setting simply means that no more records will be logged, however previous records will remain.

The SQL below will enable you to determine the number of  records in this table:

Select Count(sysuniqueid) from auditlogging

For a more accurate assessment of the storage implications of this, we suggest you refer to the article 

https://developmentx.zohodesk.com.au/portal/en/kb/articles/determining-record-count-and-table-sizes

If you do intend to delete records from this table (using SQL), you should always create a Backup of the database first and then perform a Firebird Validation / Backup and Restore after the deletion. We suggest if you are not confident with SQL, that you enlist the services of a Developer Partner to provide you with an appropriate script to delete unwanted Logging records.



    • Related Articles

    • Data Volumes and Impact on Performance

      Data Volumes This article explains how data volumes can influence performance and user experience. Apart from technical Firebird Database settings, Configuration settings within Ostendo can also affect performance. As sites run Ostendo and Freeway ...

    • Database Sweep Interval Setting To Improve Performance

      Amending the Database Sweep Interval Setting Overview: On some large databases, performance issues maybe experienced due to the database Sweep Interval setting being set at a higher level than need be. By default the Sweep Interval setting is set to ...

    • Screen Logging

      File->System Settings->Environment Settings (tab)->Activate Screen Logging Ostendo allows you to trap user activity and habits enabling you to design Workflows and other tools to assist users in areas they are repetitively accessing within Ostendo. ...

    • Performance Speed Test

      Sometimes it can be useful to conduct a speed test in order to benchmark read / write speed in a database. This is useful when attempting to diagnose a performance problem on a specific database within different environments. By running the speed ...

    • Increasing Firebird Performance

      Below are links to two articles relating to potentially increasing Firebird Performance https://ib-aid.com/en/articles/how-to-make-firebird-work-20-faster-at-windows-server-2016-in-less-than-1-minute/ ...