MSP_Resource Table Dups?

K

Ken Z

I want to check on some advice I got from Microsoft Support. They had me run
a query to look for resources that showed up more than once in the
MSP_Resource table. (Query below). They then wanted me to delete anyone with
a count > 1.

Looking at the table though, it looks like people should be in there more
than once as the row has a Proj_ID column. This seems to link a resource with
a project. Anyone assigned to more than one project would have to have
multiple rows, one for each project the resource is linked to.

Incidentally, the underlying problem is an Active Directory sync error. The
idea was if resources are in this table more than once it cause AD to bomb.

I'm skeptical - thoughts?

count(*)
from
MSP_RESOURCES
where
RES_AD_GUID is not null
group by RES_AD_GUID, RES_NAME
having count(*) > 1
 
R

Ray McCoppin

Ken: you are correct that a resource can be listed in the msp_resource table
more than once, because this table contains the enterprise resource pool and
project resources. But because the AD Sync works on the ERP, only records
in the ERP have a RES_AD_GUID. So the query bellow will only show duplicates
that have a RES_AD_GUID in the ERP. Because it is grouping by the
RES_AD_GUID and RES_NAME it should show only resource that have duplicates in
these field.

If you have duplicates I think that is good advice, and this query should
point to those duplicates.

Hope this helps.
 
Top