Project Online: Find Assignments I'm Assignment Owner of

Question

Dear,

My customer is trying to delete a resource, but is receiving an error saying '[Resource Name]: The resource is the assignment owner for [Task Name] and cannot be deleted'. This customer is NOT using timesheets or task statuses so the assignment owner field has never been used, but was just filled with default values when creating tasks.

The TaskName in the error message is a generic task name (from the template), used in multiple projects. For now, the only solution we see is opening all projects, checking the assignment owner field and updating where needed. Too time-consuming in an environment with 100+ projects.

We've tried getting an SQL statement requesting TaskName, ProjectName and AssignmentOwner, but turns out AssignmentOwner is not an available field in the Project Online database. An alternative script in CSOM returned nothing but "null" values.

Is there a way, either in PWA (tasks? approvals?) or using custom code, to get a list of all assignments for which a specific user is assignment owner?

Thanks in advance!

Answer 1

The product group for Project actively monitors questions over at
https://techcommunity.microsoft.com/t5/project/ct-p/Project
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_project

--please don't forget to Accept as answer if the reply is helpful--