In TM ART, where to find information about the database schema? Need help with SQL query report to TM ART database.

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Transaction Management Application Response Time - Infrastructure Edition


    COMPONENT:

    BMC Transaction Management Application Response Time Central


    APPLIES TO:

    BMC Transaction Management Application Response Time - Infrastructure Edition



    QUESTION:

    I need help writing a SQL query report from the TM ART database.
     


    ANSWER:

     

    Legacy ID:KA316557

      

    1. You can view the database schema from the Online Help.  From TM ART Central select Help=>Documentation=>BMC TM ART Central Database Schema.

    2. The TM ART 4.2 Central User Guide is here: 
    http://documents.bmc.com/supportu/documents/13/93/441393/441393.pdf 

    See Chapter 5 starting on page 145 called Report Generation. 
    Page 156 describes Project Status Report and Location Status Report 
    Page 157 describes Project Transaction Health Report and Product Usage Report 
    And there is some sample SQL page 163 and other pages. 

    3. And the TM ART 3.x Database Overview and Tutorial is here:

      

    http://communities.bmc.com/communities/docs/DOC-5972

    It is old but we have nothing newer.

      

    4. Also you can search the knowledge base for examples of SQL queries that may be helpful.  Use search terms such as SQL query and select.

      
    Related Products:  
       
    1. BMC Transaction Management Application Response Time - Infrastructure Edition

     


    Article Number:

    000024343


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles