Finding reports which can only be accessed by the creator

[LMeats]

I'm trying to identify reports created by users that have left the organisation and are only visible/accessible to the 'created by' user.

Is there a way to do this? I'm playing around with the report_stats and report_executions tables but can't seem to identify a way to work this filter out.

[Community Alums]

Hi @LMeats ,

If you check the OOB ACL's, Ownership of a report is effectively defined by the field 'Created by user' and the quickest way to update this field (and the field 'User') for a set of report is via xml and text editor.

From the menu Reports > Administration > All (table sys_report) filter on Created by user, export the results to xml, Open in a text editor replace the sys_id of the departed user in Created by user and User, save then import the xml.

For Scheduled reports, refer to this thread :Running Scheduled reports created by deactivated User

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[Mark Manders]

On your sys_report table, you can first filter on reports created by inactive users and check if they are on 'GLOBAL' user, or on a sys_id. If they are on a sys_id and the 'group' field is also empty, you have a good selection of those reports, I think.

If my answer helped you in any way, please then mark it as helpful.

Mark