Smart Reporting database clean up queries
Is there a way to clean up inactive user profiles and contents( i.e reports &views) created by them from system in bulk. Especially looking for view deletion.
In customer's environment currently there are 6000 views and 2000 reports created by those users who are not present in system currently.
Are there any queries available to remove it from database in a batch ? What will be the impact on application ?