I was looking into the selective data purge functionality (i.e. removing "false positive" / unwanted monitoring results), and noticed first of all that there are separate features for deleting CAS data (via DiagConsole) and the synthetic DB data (via the Synthetic Console). Deleting rows from the SyntheticMonitoring DB apparently has no impact when browsing the data via CAS. Seeing as CAS is the interface we use to browse the data, that is of course where we need to direct the data purge as well. Does it make sense to also delete from SyntheticMonitoring? If I only delete the rows from CAS, will it then later pick up the data from SyntheticMonitoring? I'm trying to understand the relationship between the two databases - if there's some documentation already about this, feel free to link me. The Agent Manager installation instructions do touch on the subject, but it's not quite clear to me yet overall.
Answer by Carol O. ·
Hi,Kalle. In general, as you know, your reporting data will be in the CAS database. So, you may at times need to purge data there.
You will also want to maintain the ESM database to a reasonable size. The best approach here (if your database is not too large currently) is to use the Agent Manager Database Tab to configure the database scheduled maintenance. If your ESM DB is currently too large, you may want to purge some data first using Agent Manager Content Pane Commands and then configure the scheduled maintenance. I hope this helps. Thanks!