Retrieving a list of all resources in from the enterprise pool

[AaronD]

Greetings,

I'm wondering if anybody can point me to an example or decent starting
point for how to retrieve the list of all Enterprise resources from
the Project Server 2007 Enterprise Resource Pool (for use in a VBA
macro). I'd like to be able to update a macro that presents resources
matched by specialty to a task for assignment so that it is not
limited to only those resources already in the project's resource pool
(which is how the macro currently operates) - I would also then need
to add a selected resource to the project's resource pool from the
enterprise if the resource did not already exist on the project.
(help/
pointers on this part - adding a resource from the enterprise to the
local pool - would also be appreciated =)

Thanks,
Aaron

(note: this message was re-posted here after I received notice that
the VBA group where I originally posted was closing down)

 

[Parth]

in the reporting database:


Select * from msp_epmResource_Userview will all the details of enterprise
resource.


Or

You can also use Resource webservice to read the resources details.

Parth

 

[AaronD]

Thanks for the reply!

Two followup questions:
1) Once I retrieve the list, if the user wishes to assign an
enterprise resource to a task and that resource is not yet in the
project's resource pool, what is the best way to add the resource?
2) What is the correct way to connect to the reporting database from
within VBA to issue the SQL statement you suggested?

(I'm surprised there's no included API support to do this...)

Thanks,
Aaron