Table for user info

[ctd]

Hi,
Does anyone know what table stores all the info about a new user ? I added
a new user using PWA - server setting - add new user link.
Thanks.

 

[Jonathan Sofer [MVP]]

I would use the view MSP_EpmResource_UserView to pull the user information
and if you only want users that are not able to be assigned as resources
(meaning the checkbox "User can be assigned as a resource" is NOT checked)
then you can filter the view on the ResourceType field like in the following
query:

SELECT ResourceName, ResourceType
FROM dbo.MSP_EpmResource_UserView
WHERE (ResourceType = 1)

1 = "User can be assigned as a resource" IS NOT checked
2 = "User can be assigned as a resource" IS checked