What types of reports are taking up the most room in the RT table ?

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

What types of reports are taking up the most room in the RT table ?

Environment

Release : 12.x

Component : AUTOMATION ENGINE

Cause

N/A

Resolution

The RT table contains the report(REP, ACT, etc..) of the execution of any objects.To find out which type of report  that has a lot of records, you can execute the query below.


SELECT RT_TYPE, COUNT(*) as Records
FROM RT 
GROUP BY RT_TYPE;


Reference on different type of reports.
https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Reports/Reports_Overview.htm?Highlight=Report%20type