Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Anthony on January 01, 1970, 12:00:00 AM

Title: Size of Log Database
Post by: Anthony on January 01, 1970, 12:00:00 AM

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

Title: Size of Log Database
Post by: gauthier on January 01, 1970, 12:00:00 AM

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.