We have situation when not properly configured Agent had produced about 2GB of report files per day that got ingested into AE RT table. We have few days’ worth of Reports from this Agent.
How can we safely delete the Reports only for this Agent from the AE Database RT table if we know the offending reports IDs (RT_AH_Idnr)?
I had look into https://community.automic.com/discussion/6824/db-maintenance-with-automic-utilities article regarding DB Reorg and DB Unload.
Unfortunately I did not see an option in the “Criteria for reorganization” for removing specific reports by ID from RT and RH tables. I see only criteria for the older then Date option. With the requirements that we have we cannot remove all the reports older then specific dates, I only need to remove the reports related to this specific Agent.
I appreciate any insight or feedback on how case like this can be handled.