SQL: Select Generic Resources

[Kris R.]

OK, this seems like it should be simple, but I must need some more caffeine
or something this morning!

How can I use a SQL query to get the res_UIDs of all generic resources?

Select * from WHAT TABLE(s)?? I can't seem to find out where resources are,
nor can I find where they are marked as generic.

Must...get....coffee.....

Thx,
Kris R.

 

[John Sitka]

Open file PFDB.HTM

located ....\Program FIles\Microsoft Office Project Server 2003\Help\1033

EDIT > FIND "generic"

 

[John Sitka]

This is the first time I've looked at this table.

How does one find resources available in the resource pool
as this MSP_RESOURCES table is exactly what it says
A ProjectResources Table.

This looks close to me

SELECT res_uid FROM msp_resources
WHERE
proj_id = 1 -- it's my enterprise resglobal (MSP..) or Nonproject time
(MSP_WEB...)
AND
(res_rtype =1 OR res_rtype = 101) -- active or deactive, both types
AND
res_uid NOT IN (0,-65536,-65535,-65534) -- Who knows? Microsoft says to
exclude them for user purposes


Is there a true resources table?