Cleaning resources with no assignments

[Mauricio@BVFG]

Hi Gurus,

Since there are to many resources showing up in the Resource views I decided
to do some cleanup. I found out I have inactive resources with no assignments
that are counting a license each - my CFO will be happy if I delete these
from the DB.

I came with the following SQL statement

delete from msp_web_resources where wres_is_enabled = '0' and
wres_count_license = '1' and wres_id not in (select distinct wres_id from
msp_web_assignments)

Is this a valid approach?

Thanks

Mauricio

 

[Rod Gill]

I would check with the project server group, but deleting data from msp_web
tables is very dangerous and likely to lead to corruptions of data! Safest
way to delete resources is via the Admin pages which of course can only be
accessed by people with Admin rights.

However, my understanding is you don't need a license for a resource that
doesn't use PWA. For example a resource of machine doesn't need a PWA
license.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com

 

[Mauricio@BVFG]

Valid points. Anyway how can I reduce the resource list length? These records
that I want to remove are users that somewhere down the road were included in
the ProjectServer AD group with no reasin and are just making terrible the
resource selection process when uisng Project Professional -although I have
already set some filters for ease up things for the project managers.

 

[Rod Gill]

If you have AD synchronisation then simply remove the resources from the AD
groups. Next time Project Server syncs, the resources will be set inactive.
To completely remove them is still the role of the Project Server
Administrator.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com