How to Delete Unused Files from CA APM › How to Delete Unused Files from CA APM › Query the CA MDB

Query the CA MDB

If a specific attachment file, import data file, or legacy map file is no longer needed, you can delete the file from the CA APM application server. Before you delete the file, verify that the file does not have any associations in CA APM (for example, a file attached to a legal document or an import data file associated with a data import).

Follow these steps:

1. Access the CA MDB that is associated with your CA APM installation.
2. Query the al_file_storage table to search for the file name and the associated tenant if applicable. The following statement is an example query:

   select COUNT(0) from al_file_storage where attachment_url = 'filename.txt'
   

   If no records are returned, no records are associated with the specified file name. You can delete the file.