Resource availability period in MS Project 2003

B

Botond BAIKA

Hi All!

I would like to find out the period of (active) availability of a given
resource (person) in MS Project 2003. How can I do this?
Usually I am interested in a group of resources (persons), and I would like
to atach additional informations. This is why I would like to use a T-SQL
query. I have read rights to all the tables of the ProjectServer SQL Database.

But, I am open to other solutions, too.

Best Regards,
Botond
 
J

John Cello

Botond:
Try the Resources tab in Project Web Access. You can choose multipl
resources and view their availability there. For "additional information",
not sure what you're looking for, but you can add info to the resources in
the enterprise resource pool and add those fields to the views.
 
B

Botond BAIKA

John,

Thank you for your feed-back. I think my question was not precise enough:

I would like to find out the period of (active) availability of a given
resource (person) from code (of an application written by me). How can I do
this from code? Because I need this for more than one person (resource) at
the same time. So, using any user interface is not an option.
I would like to do this by quering the Project Server's MS SQL Database.
But if there are other better solutions, I am opened for those, too.
 
J

John Cello

Don't know if this is what you're after, but give it a whirl.

Go to Project Web Access
Click on "Resources" on the top menu bar
Ctrl + Click on the resources youwant to look at. (This allows you to select
multiple resources)
Click on the "View Availability" icon
You can either decrement\advance the date range you want to look at using
the arrows on either side of the displayed date range, or you can click on
the "View Options" button and set a date range as well as whether ou want to
see availability by days or weeks.

Hope this helps.
 
B

Botond BAIKA

Dear John,

You keep giving me solutions that need the use of the user interface.
As I said, I want to do it by code, from behind the scenes, by programming.
So I need MS SQL code snippet, not directions about how to use the user
interface.
Please, do not provide any more directions about the user interface.

Best Regards,
Botond
 
Top