Screen Logging

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.

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

eg: How often and when a user accesses the Job Orders screen or how many times a user runs a report.

Whilst this information is useful in the early days of an implementation, you should remember there are numerous records being created in the associated table in the database. Leaving this setting on can dramatically impact on the size of the database as time goes on. Therefore you should consider purging records from the SCREENLOGGING table on a regular basis if this setting is left turned on for a period of time. 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 screenlogging

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

    • 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 ...

    • 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 ...

    • 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/ ...

    • Improving Performance of Opening Lists

      As a database gets larger, the opening List grids can take longer to load, when 'Include Closed' Orders, 'Include Updated Status' or 'Include Fully Paid' is turned on along with Filtering and Sorting from the Grid options. This is because in order to ...