I am using this query to get a list of old reports in private folders and I am wondering if I can include public folders also. Here is the query:
SELECT Id,name,LastRunDate,owner.firstname,foldername,owner.email,owner.isactive FROM Report USING SCOPE allPrivate WHERE LastRunDate < LAST_N_DAYS:365
If I use "USING SCOPE everything" I get a list of report in public folders. I want to combine these into one report.
Can I use more than one scope like this? USING SCOPE everything AND allPrivate