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

Answer 1

Hi Kathy,

You may want to have a look on the following blog. Hope this helps you to fetch the resources data those are within the project but not assigned to any tasks.

http://badalratra.wordpress.com/2013/01/19/report-requirement-user-permissions-across-projects-in-project-server/

Cheers,

Badal

---

Warm Regards Badal Ratra

Answer 2

Thanks Badal,

I think this will be perfect!

Kathy