Project Online: Find Assignments I'm Assignment Owner of

JLE_ 6 Reputation points


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!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,136 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Dave Patrick 426.4K Reputation points MVP

    The product group for Project actively monitors questions over at

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

    0 comments No comments