none
Project Server 2007 Determining Resources in Project Team not Assigned to Tasks -- SQL

    Question

  • Project Server 2007  I use the query below to determine which resources i am able to archive by the following query.  This works for most of the of them except the one who have been added to a project team but have never been assigned to a task.  If I delete one of these it sends a message to the project manager that a resource in their plan has been deleted.  This causes concern.  Does any know how i get a listing of those resources who are within the project but not assigned to tasks?

    Thanks!

    select ResourceUID, ResourceName, ResourceNTAccount, ResourceGroup, ResourceCreatedDate, ResourceModifiedDate
    into WWG_ArchiveEmps1
     from dbo.MSP_EpmResource
    where ResourceUID not in (select ResourceUID from dbo.MSP_EpmAssignment)
    and resourceisactive = 0
    except
    select ResourceUID, ResourceName, ResourceNTAccount, ResourceGroup, ResourceCreatedDate, ResourceModifiedDate
     from dbo.MSP_EpmResource
    where ResourceUID in (select ResourceOwnerUID from dbo.MSP_EpmAssignment)
    and resourceisactive = 0

    Wednesday, January 30, 2013 4:02 PM

Answers

All replies