I have a problem with an EPO database of aproximatelly 20 GB, and reporting is quie slow. I would like to remove all cookie events, but not the virus, trojan, mass mailer events etc. I have been trying to get a SQL script to do this.
Have anyone done this? 90% of all events in the DB is Cookies and right now we are not so interrested in these events.
If it is possible to purge all events containing "Like Cookie%" for instance. I am even interested in removing events with a certain EventID.
I am aware that this will be a walk in the park when we upgrade to EPO4, but I need to do this before we upgrade.