Delete applications with contents

Question

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&aacute;s

Harsh Kumar Agarwal · Answer

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.

Shubham Aware · Answer

We initially tried multiple automated/scripted approaches, but after spending considerable time we realized manual deletion per application would have been faster and given us better control over exactly what gets deleted.

Harsha Sharma · Answer

Best viable solution, though time taking in reviewing and deleting manually in my experience. Avoids dependency errors as well as erroneous deletions in general. 
 First, for db objects prepare scripts successfully and then you can run them all together at one go. Once db objects are deleted, For Appian objects - I would suggest to add the objects carefully to a separate package which you want to delete - then review contents so that nothing relevant gets deleted and lastly delete the artifacts until package is empty.