Project Online: Find Assignments I'm Assignment Owner of

JLE_ 11 Reputation points
2022-04-11T09:05:31.93+00:00

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!

Community Center | Not monitored
{count} votes

2 answers

Sort by: Most helpful
  1. Anonymous
    2022-04-11T12:21:39.237+00:00

    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--

    1 person found this answer helpful.
    0 comments No comments

  2. ashagre tafere 0 Reputation points
    2025-01-17T07:41:55.63+00:00

    Part II Mlicrosoft Project (MSP)

    SCENARIO: January of 2024 Mr. Engera were assigned as the new project manager for a

    Prototype Development project was to start the first working day of Feb 2024. The following table

    represents the task resource information that has been put together by the former project manager,

    who has just left the company. After going through her records, this is all you can find in the

    project file of any value, other than a preliminary MS Project file. The normal working times at

    your company is 6 days a week, 7 hours a day. The company does not require its staff to work

    on weekends. In addition the company holds its annual retreat from Feb 21st to the 23rd during

    which time its oftices are closed and all of its employees are expected to attend an offsite facility

    where various conferences, employee morale and team building activities are done.

    WBS ACTIVITY DURATION ACTIVITY START RESOURCES REỌUIRED

    CODE NAME INFORMATION I leader, I analysts, 2 engineer,

    A Analysis 12 days Can start on or after Feb 3

    Also, you are the team member

    of the analysis

    E Basic Design 18 days | Can start2 days after A startsI leader, l analyst

    C Code Prototype 19 days Can start when B starts |I analyst, I engineer

    D Design I week Can start when A is finished 2 engineers

    Interface

    Engineer 4 weeks Can start when A is finished 2 engineers

    Module

    Final Testing I week | Can start 2 days after E starts 2 analysts, I engincer

    Go-ahead Can occur after all previous none

    Milestone tasks are complete

    The company's standard billing rates for its various staff resource categories are given below. The

    company does not pay extra for overtime. These are the only staff available; all the others have already

    been assigned to more important projects.

    Resource Group Hourly Rate | Staff Names

    | Analysts Br. 950 Solo,

    Zix,

    Fakoo

    Add your name

    Leaders Br 1,800 Yobi,

    Ljio

    Engineers Br 1.200 Nowe

    Kissa

    Kiki

    Wofo

    You have been asked to enter dependencies and assign staff for the activities on a one page Gantt

    chart, showing the earliest possible completion date. Your boss, who prides herself on being

    sensitive to her staffs family obligations, asks that you review the workload for all staff assigned

    3

    to this project. She asks that you perform resource leveling to ensure that no one has to work more

    than 7 hours a day, no one works weekends, and no one works on or between Feb 2Ist to the 23rd.

    She insists that your Gantt chart printout show the total duration and the total cost of the project

    using a Project Summary Task. She also wants to see the resource names next to the timeline bars

    on the right side of the chart.

    File Setup:

    1. Start the MS Project and create a new project file.
    2. Using Project Information enter the start date of the project as Feb Ist, 2024.
    3. Save the file using the combination of your name and ID number

    Required

    O Submit the assignment in a hardcopy by generating a report and the softcopy (Send it through

    telegram).

    O Due date 15 Jan 2025.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.