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: Purge for DM DB?
Post by: Anthony on January 01, 1970, 12:00:00 AM

Hi,


Has anybody develop a stored procedure to purge data from the CC Analyzer historical tables?

Title: Purge for DM DB?
Post by: Vic on January 01, 1970, 12:00:00 AM

drop user will do the trick :)
Interesting question, because I was trying to do it as well, and right away I thought of ETL Assistant. You can specify how long you want to keep the data for, and when you would want to truncate it.

Title: Purge for DM DB?
Post by: Anthony on January 01, 1970, 12:00:00 AM

Thanks...

Title: Purge for DM DB?
Post by: Vic on January 01, 1970, 12:00:00 AM

Any time :) Tell me if there is anything else I can help you with.

Vic

Title: Purge for DM DB?
Post by: Beancurd on January 01, 1970, 12:00:00 AM

I believe Genesys have a utility to purge the data.Rumour has it it's on the Reporting CD I'm not in a position to check at the moment.