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

Create a technical support case if you need further support.

Generating OfficeScan (OSCE) Agent Listing from the Control Manager (TMCM) database

    • Updated:
    • 25 Jun 2018
    • Product/Version:
    • Control Manager 6.0
    • Control Manager 7.0
    • Platform:
    • Windows 2003 Server R2
    • Windows 2008 Enterprise
    • Windows 2008 Enterprise 64-bit
    • Windows 2008 Server R2
    • Windows 2008 Standard
    • Windows 2008 Standard 64-bit
    • Windows 2012 Enterprise
    • Windows 2012 Server Essentials
    • Windows 2012 Standard R2
    • Windows 2012 Web Server Edition
Summary

This article shows how to generate OSCE Agent Listing from the TMCM DB.

Details
Public

To generate the OSCE Agent Listing, do the following:

  1. Logon to DB Server and open the SQL Management Studio.
  2. Logon to the SQL Server using your credential and click Connect.
  3. At the Object Explorer, expand TMCM\SQLExpress.
  4. Go to Databases > db_ControlManager. This is the database of Control Manager.

    Object Explorer

  5. Select New Queryfrom the menu.
     
    Make sure that you are in the correct databasedb_ControlManager.

    New Query

    The SQL Query editor will launch.

    Query Editor

  6. Copy the SQL statement below, and paste it in the SQL Query editor:
    select e.EI_OS_MachineName,p.EI_OS_MachineName, e.EI_DomainName,e.EI_ClientTreePath,e.EI_IPAddressList,e.EI_State,e.PFWSetting,e.EI_OS_Name,e.EI_OS_SPVersion,e.EI_OS_Version,e.EI_OS_SPVersion,e.EI_ProductVersion,e.EI_ProductBuildNumber,e.EI_MACAddressList,e.EI_CloudScanMethod,e.EI_CloudScanMode,e.EI_LastRegistrationTime,e.LastScheduleScanUTC,e.LastManualScanUTC,e.LastScheduleScanUTC,en.SEI_EngineVersion,pt.SPI_PatternVersion,e.* from tb_EntityInfo e with(nolock)  left join tb_EntityInfo p with(nolock) on e.EI_ParentID=p.EI_EntityID  left join tb_AVStatusEngineInfo en with(nolock) on e.EI_EntityID=en.SEI_EntityID  left join tb_AVStatusPatternInfo pt with(nolock) on e.EI_EntityID=pt.SPI_EntityID  where en.SEI_EngineType=4096 and pt.SPI_PatternType=4 and e.EI_Type=2 and e.EI_ProductType=15  order by p.EI_OS_MachineName  
  7. Click Executeor press F5.

    Execute Query

    The Query Result will be seen at the bottom of SQL Query editor.

    Query Result

  8. Export the file in CSV format. Do the following:
    1. Right-click on the result.
    2. Select the Save Results as.
    3. Enter the preferred file name, then select CSV as the format.
    4. Click Save.
Premium
Internal
Rating:
Category:
Configure
Solution Id:
1120180
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.