APM DB query to extract Total transaction and Slow time defects

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• CA Application Performance Management (APM / Wily / Introscope)
• INTROSCOPE
• DX Application Performance Management

Issue/Introduction

We need APM DB query to extract Total transaction and Slow time defects per day with below condition

APM query to extract only the slow time defects per day as a sum of each Business Transactions. There are around 900 transaction recorded in CEM

APM query to extract the Total transaction per day  as per Business Service or Business transactions

 

Environment

Release : 10.5

Component : APM Agents

Resolution

APM query to extract only the slow time defects per day as a sum of each Business Transactions.

Query: select ts_defects.ts_occur_date,ts_transets.ts_name,count(ts_defects.ts_defect_type) as slow Defects from ts_defects inner join ts_transets
on ts_defects.ts_transet_id=ts_transets.ts_id where ts_defects.ts_defect_type=1 group by ts_defects.ts_occur_date,ts_transets.ts_name ;



There are around 900 transaction recorded in CEM

APM query to extract the Total transaction per day as per Business Service or Business transactions

Getting a query to get the total number of transaction is spread through multiple stats table, which were generated dynamically based on hourly,daily. So getting total transaction through query is not possible.

They can see the count in the analysis graph and export the data.