Openfire Server Message Retention Policy

Good Morning.

I have a request from management to start implementing a retention policy on my openfire server.

We would like to delete messages older than 210 days.

I have been googling, and the nearest info I can find is that I have to do this with some SQL commands.

I have my server running on Windows.

Is this correct? Did I find the right thing? Is there a way to set a retention policy of say 210 days and have the server automatically delete the old history?

Thanks.

I’m pretty sure the monitoring plugin allows this.

I have the monitoring service plugin. Is that the same?

Where do I configure that?