Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Resolving report generation and managed product entity issues using Control Manager (TMCM) Tools

    • Updated:
    • 21 Oct 2015
    • Product/Version:
    • Control Manager 6.0
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Server R2
    • Windows 2008 Standard
Summary

Learn how to resolve the following issues using Control Manager tools:

  • Inconsistent log report and widget information
  • False status of managed entities
  • Increased size of TMCM database db_ControlManager that causes problems in component updates and other major functions
Details
Public

The TMCM 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

  1. Stop the following TMCM services:
    • Trend Micro Common CGI
    • Trend Micro Control Manager
    • Trend Micro Management Infrastructure
  2. Run ..\Control Manager\CMMaintainingTool.exe.
  3. Purge abnormal communicators by selecting each of the following and clicking Purge Now:
    1. Purge abnormal communicators
    2. Purge duplicate communicators with abnormal status
    3. Purge duplicate tables in SQL database
  4. On the Recount the Control Manager server logs section, select the following:
    • Virus logs
    • Security logs
    • Web Security logs
    • Packets Virus logs
  5. Click Recount Now.
  6. Under the Remove duplicate OSCE clients and SPNT NS information section, select the following:
    • OSCE client
    • SPNT NS
  7. Click Remove Now.

Using the DBCleanupTool

  1. Stop the following TMCM services:
    • Trend Micro Common CGI
    • Trend Micro Control Manager
    • Trend Micro Management Infrastructure
  2. Right-click ..\Control Manager\DBCleanupTool.exe and select Run as Administrator.
  3. Select the following:
    • Invalid Log
    • Temp Log
    • Command Tracking Log (All)
    • Unregistered Product List
    • Invalid Engine/Pattern Version
  4. Click Start.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Deploy; Upgrade; Update
Solution Id:
1061260
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.