Size of Log Database

NICE CXone API & Integrations
1

The size of my Log Database is extremely big. Is there a way to configure it through CME or SCI in order to delete obsolete

records without using a DBMS mechanisms.

If not, what would be the best way and how to delete the records using a DBMS mechanisms.

Thanks,

Anthony

2

There is no mechanism in Genesys version 6.1, it has been implemented in version 6.5 of the management layer. Otherwise if you’re using version 6.1, you can use the following script.

delete from g_log_messages

where timewritten < to_date(‘(your date in format DDMMYYYY)’, ‘DD/MM/YYYY’);

This script allows you to delete log messages in the log DB that are older than the date specified. It has been tested on an Oracle DB.