Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Report - Projects a User has Manage Access to

Avatar

Level 3

We are trying to build a report that pulls projects where a user has manage access, but is not necessarily the project owner.  Has anyone had luck creating a report for this?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

I have what could be a start of it...create a project report with project users ID equal [person's name in question] and can also add a filter for project owner ID NOT equal the same person.

Madalyn_Destafney_0-1721421519384.png

From there having a hard time pulling in a column to show what level of access they have on the projects but this is a start to show you what they have access to and are NOT the project owner.

If this helped you, please mark correct to help others : )

Avatar

Community Advisor

this would probably be a project report with an exists filter that is filtering on access rules.

 

You would start off with a regular report filtering for "project owner ID is not equal to your person's user ID" and then switch to text mode and put in additional text mode, like: 

 

EXISTS:a:$$OBJCODE=ACSRUL

EXISTS:a:securityObjID=FIELD:ID

EXISTS:a:accessorID=your person's user ID

EXISTS:a:coreAction=EDIT

 

This is a sample exists statement querying access rules for anything where the object ID on the sharing rule is the same as your project ID, and then finding out if your user is on it, and if they have "edit" access (this commonly is what manage access is called). The above is just a guess to point you in a direction, so you might want to explore the API explorer for more tidbits, if it errors. This is all under the Sharing object, which is what Access Rules are commonly referred to in the API explorer.

 

Edited to add that if the user is in a company, role, group or team that was given manage access, they will likely not be covered with the statement above. So you'll have to discover these separately (you might do this by querying the users company, roles, groups or teams, and then searching to see if any of those objects had manage access to anything.