Audit trail Details in Cem

Document ID : KB000014236
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Some information on the APM CE (CEM) Audit trail location and tables.

Question:

Can we know the general details on CEM Audit trails tables liks,

 

1. Q.    Where is the APM CE Audit Trail stored?

2.Q.   Where are the URL Configuration and the defined business transactions stored?

3.Q.   What are the Schema and UIF names for the Business Transaction tables?

4.Q.   What happens when we click the TIM synchronization button ?

 

Environment:
APM 9.x and 10.x
Answer:

 

1.A.   The APM CE Audit Trail is stored inside the APM database in these table: ts_audit_records  and ts_audit_record_props. 

2.A.    Business transactions are stored in the database in various tables. Note that each table is associated with other tables with dependency keys. 

               These are the main tables: ts_transets and ts_tranunits. 

3.A.    The schema name and Unique indenter field name is stored in the tess-db-cfg.xml file. It is located in the MOM EM_HOME\config folder. 

             For example: If your database is Oracle, then the values will look like this:
 

          <property  name="hibernate.connection.url">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PRO 

          TOCOL=tcp)(HOST=ghhsi01-pc)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl.ca.com)))</property>  

          <property name="hibernate.connection.username">cemuser</property> 

       Here, Schema Name is cemuser  and the Unique Identifier field name is  SERVICE_NAME

 

4.A.    The APM CE transaction definitions are sent to the TIM as flat files as the TIM does not have a database. This process happens when clicking on Synchronize Monitors. 

Path for flat files on Tim: 

           The flat files will be in this path on tim:  /usr/local/wily/cem/tim/config.