function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Malisa Gibbons 9Malisa Gibbons 9 

Delete Reports in Inactive Users Personal Folders?

I need to delete reports that are located in inactive users personal folders.  I am an Admin so thought this was a setting on the Admin Profile but cannot find it. Can anyone point me in the right direction?
AnkaiahAnkaiah (Salesforce Developers) 
Hi Malisa,

Use the allPrivate query scope to find and delete reports and dashboards saved in private folders. Requires the user permission "Manage All Private Reports and Dashboards." 

Refer the below help article for more information.
https://help.salesforce.com/s/articleView?id=000317823&type=1

If this information helps, Please mark it as best answer.

Thanks!!
 
Bart Lont 12Bart Lont 12
Use this SOQL query:

SELECT Name,FolderName,Owner.Name,Owner.isActive,Id,LastModifiedDate,LastRunDate FROM Report USING SCOPE allPrivate WHERE Owner.isActive = false