RT table Cleanup

Discussion created by Bhavpreet_Bains_7888 on Mar 31, 2017
Latest reply on Jul 13, 2018 by AlainMoisy

We recently noticed that the RT table has grown very large. We already have DB maintenance setup on automic for reports to be deleted that are more than 90 days old. 

However, when we pulled in the rt database by using query select * from uc4.rt, there were entries with RT_TimeStamp of April, 2016.
All the entries that has the RT_TIMESTAMP filled has 
RT_Type: ACT,  RT_CONTENT: null and has some data in RT_MSGINSERT.
The rest of entries has
RT_Type: Log, RT_TIMESTAMP: null,  RT_CONTENT: has some data and RT_MSGINSERT: null

Also, in the unload jobs of DB maintenance, there are only a few entries (2-5) for deletion for RT table.

I am not sure if I am doing something wrong because of which it's not deleting the entries from RT table during unload of DB maintenance. Also, I want to understand why the log entries in database doesn't have the timestamp and old act files are still there.

Thank you.