Updating Sametime Persistent Chat ‘Time To Live’ (TTL) on Windows Sametime servers

The time-to-live (TTL) setting defines how long the chat history is stored in the database. The default value is 90 days.

The instructions on how to change it in the official documentation unfortunately refer only to Docker and Kubernetes deployments and do not cover the Windows-based chat-only server.

On a Windows Server, you don’t have to edit the file custom.env, as you would in Docker or Kubernetes; instead, you need to edit the file chatlogging.ini.
Add at the end of the file this value: CL_MONGO_HISTORY_TTL=30 where 30 is the number of days you want to keep the chat history.

Then follow the instructions in the documentation to delete and recreate the Mongodb indexes. Open a mongo shell and type the following commands
use chatlogging
db.EVENTS.getIndexes() [here the default value should be 7776000]
db.EVENTS.dropIndex(“TimeStamp_1”)
db.USERS.dropIndex(“date_1”)

Restart the Sametime server and check again the value of the EVENTS index for TimeStamp_1, should be 2592000 in my case of 30 days.