I have had a warning for several days now saying that we exceeded the licence limit of 500000 docs.
In fact it was the querylog table of one of our profiles.
I have cleaned it out (<10 000 records) but the licence warning persists.
Do i have to do something else ?
NB.: this is an 'open' appliance, and i deleted the rows with tsql.
Once the metamorph index updates on the violating table the violation should clear itself after a day. Make sure any metamorph index on that table is up to date and that there are no other violating tables.
For reference the standard way to reduce the query log is to use query log rotation.