Genesys – Deleting Log records from log database

As we all know, Genesys applications can be configured to store log records in database. Unfortunately, there is no automatic maintenance option and have to purge data either manually or schedule script for this.

Delete logs manually


You can use ‘Log Database Maintenance Wizard’ from Genesys SCI to maintain database. If there are large number of records in database, SCI application will become unresponsive and we have to kill it forcefully.

Delete logs – Schedule it


You can use steps below to automate the process. Fortunately, we don’t have to dig deep for this as SQL scripts are available from the wizard itself. You can easily find that log records are stored in two tables as below

  • G_LOG_MESSAGES
  • G_LOG_ATTRS

and to delete logs which are older than 15 days, use script below

You need to run this in the same order as above and recommend to schedule to run every 24 hours. You can configure this as SQL Server Agent job or run this sql as scheduled task from windows.

(Visited 18 times, 1 visits today)

Tagged: ,

Leave a Reply

Your email address will not be published. Required fields are marked *