Can anyone tell me that if a document is deleted from UCM (say it's archived and then deleted) will this also remove all the audit trails and entries in other tables(docmeta,revisions,workflowhistory.. etc) as well?
Also if there are custom tables , will the entries be deleted automatically? How does this work?
I have to generate reports for the documents that are not archived.
Easiest way to figure this out would be set the following trace sections : requestaudit,systemdatabase along with full verbose tracing .
Then arvchive and delete a content item , check the view server output logs to see which all tables are affected by the operation .
Custom tables would not be invoked in the deletion process until and unless explicitly referred from the service or component calling any data . Just like when you make a content check-in , until and unless the custom filters / component does not fire the insert statements there will not be any entries made .
Tables like Workflow History need to persist these content items as its purpose is totally different. If a admin wants to know how many content went through a particular workflow, this is the table he could refer to and also know who approved them. It is up to you to truncate records in these tables depending upon the organization need. You can for example truncate records older than 5 years from these tables.