The TMCM/Apex Central server has two primary tools, the CMMaintainingTool and the DBCleanupTool. These tools resolve the issues by reducing the size of db_ControlManager database and removing stale database records. Run these tools once a month to keep the database healthy and to gather correct information in widgets and reports.
Using the CMMaintainingTool
- Stop the following TMCM services:
- Trend Micro Common CGI Trend Micro Common CGI is not available in TMCM 7.0 and Apex Central.
- Trend Micro Control Manager
- Trend Micro Management Infrastructure
- Trend Micro Common CGI
- Run ..\Control Manager\CMMaintainingTool.exe.
- Purge abnormal communicators by selecting each of the following and clicking Purge Now:
- Purge abnormal communicators
- Purge duplicate communicators with abnormal status
- Purge duplicate tables in SQL database
- On the Recount the Control Manager server logs section, select the following:
- Virus logs
- Security logs
- Web Security logs
- Packets Virus logs
- Click Recount Now.
- Under the Remove duplicate OSCE clients and SPNT NS information section, select the following:
- OSCE client
- SPNT NS
- Click Remove Now.
Using the DBCleanupTool
- Stop the following TMCM services:
- Trend Micro Common CGI Trend Micro Common CGI is not available in TMCM 7.0. and Apex Central.
- Trend Micro Control Manager
- Trend Micro Management Infrastructure
- Trend Micro Common CGI
- Right-click ..\Control Manager\DBCleanupTool.exe and select Run as Administrator.
- Select the following:
- Invalid Log
- Temp Log
- Command Tracking Log (All)
- Unregistered Product List
- Invalid Engine/Pattern Version
- Click Start.