TCM SearchLog Table is large

The dbo.SearchLog table in the TCM database is large 

• TCM

• Diskspace

• SearchLog

• Search Log

• Performance

When Log All Searches is enabled, the search logs every incoming search query's detail such as the date/time of the search, the userID the search was done by, the # of documents returned in the search, and how long the search took. The search queries come in anytime Munis gets the document count to display, when the TCM viewer is launched from Munis, and whenever someone does a direct search within TCM itself (Full Client and new browser-based Document Search).

• To clear Search Logs, from TCM full client schedule the job system.log.PurgeSearchLog

• To disable TCM search logging:

  • Open TCM full client as admin

  • Navigate to Administration > System Setup

  • Select iDoc Documents > Search Settings

  • Uncheck Log all Searches

  • Click OK