A report for shared reports

[JaredMauch]

Workfront Community,

I may be overlooking the filter or report type but is there a way to filter a report for reports to only show reports that are shared with a specific user?

[MoniqueEvans · Accepted solution]

I just did some digging and could not find how to filter this either. You could create a report with no filter and then run the report as the specific user. This would then show all the reports they have access to. Definitely not the cleanest way to get the info, but it'll work.

[JaredMauch]

Thanks, Monique! It's working for what I need. One of our project admins is leaving so I'm making sure that the new admin has access to all the same reports, dashboards and project templates.

[-WE]

Hi Jared, 

The below filter can be used in any type of report (reports, projects, tasks, issues, etc.) to return a list of records that are shared with a specific user. It will display records where access is either inherited or shared directly.

• Swap out the GUID with the user's GUID.
• This will not return records that a user can only access because the record was shared with their role, team, or group - it looks for records that were shared directly to the user.
• If you want to return records that were shared to a specific role, team, or group, you can use the same filter and just swap out the ID of the role, team, or group. (You can enable multiple filters by layering in OR statements)
• If you want to return records that AREN'T shared directly to the ID in the filter, you can change the EXISTSMOD from EXISTS to NOTEXISTS.

EXISTS:A:$$EXISTSMOD=EXISTS
EXISTS:A:$$OBJCODE=ACSRUL
EXISTS:A:accessorID=5c1e831f02dc1e4ae10d0c0134b7c072
EXISTS:A:securityObjID=FIELD:ID

In a nutshell, what this filter does is "show a list of _____ (whatever the object type of the report is) where a Sharing rule exists AND that Sharing rule is for the provided ID" 

Hope this helps.
-WE