How to identify users and just resources?

[PMPLookingForToBe]

Hi.

How can I identify, using just the tables of Project Server database, user
accounts (whose can login at Web Access) and just resources (people or
materials assigned to tasks only)?

Thanks a lot.

 

[Asaad Saleh]

I think i can help but i think you should clear the question one more time, sorry i didn't get it well

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[PMPLookingForToBe]

Asaad:

Thanks, anyway. In fact, I just found the answer.

Best regards.

 

[Dale Howard [MVP]]

Gaspar --

If I understand you correctly, you want to identify those who have user
accounts in PWA only, and those who are resources in the Enterprise Resource
Pool. To identify PWA user accounts only, use the following SQL Query:

SELECT RES_NAME, RES_EUID
FROM MSP_WEB_RESOURCES
WHERE (RES_EUID IS NULL)

To identify resources in the Enterprise Resource Pool, use the following SQL
Query:

SELECT RES_NAME, RES_EUID
FROM MSP_WEB_RESOURCES
WHERE (RES_EUID IS NOT NULL)

The second query identifies both people and material resources. Hope this
helps.

 

[PMPLookingForToBe]

Dale:

Thanks a lot.

It was very useful.
--
Gaspar
PM --Adopting methodology--

Gaspar --

If I understand you correctly, you want to identify those who have user
accounts in PWA only, and those who are resources in the Enterprise Resource
Pool. To identify PWA user accounts only, use the following SQL Query:

SELECT RES_NAME, RES_EUID
FROM MSP_WEB_RESOURCES
WHERE (RES_EUID IS NULL)

To identify resources in the Enterprise Resource Pool, use the following SQL
Query:

SELECT RES_NAME, RES_EUID
FROM MSP_WEB_RESOURCES
WHERE (RES_EUID IS NOT NULL)

The second query identifies both people and material resources. Hope this
helps.

 

[Dale Howard [MVP]]

Gaspar --

You are more than welcome, my friend!

Dale:

Thanks a lot.

It was very useful.