Delete applications with contents

Certified Lead Developer

Hi team,

We're struggling the the disk usage of our training environment as it's reaching its full capacity, there are several applications that can be deleted completely. However, there's no bulk deletion of applications including its contents, out-of-the-box.

Do you know any easier way to perform these deletions? 

P.D.: We would like to delete the DB objects (tables, views, etc) related to these applications as well.

Thank you in advance!

Regards,

Tomás

  Discussion posts and replies are publicly visible

Parents
  • You can try using the Delete Folder Contents smart service for objects stored in a folder. You will still need to manually delete a few objects such as CDTs and Records, but this approach will reduce the overall time required.

    Tables and views are easier to handle if you run a SQL query to identify objects containing your keywords, and then delete the corresponding tables and views in bulk.
    for example: select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%LOG%' order by TABLE_NAME

    Hope that helps.

Reply
  • You can try using the Delete Folder Contents smart service for objects stored in a folder. You will still need to manually delete a few objects such as CDTs and Records, but this approach will reduce the overall time required.

    Tables and views are easier to handle if you run a SQL query to identify objects containing your keywords, and then delete the corresponding tables and views in bulk.
    for example: select TABLE_NAME,COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%LOG%' order by TABLE_NAME

    Hope that helps.

Children