Project 2000 sql query against assignments

[lukeevans1000]

We are using Microsoft project 2000.
We are not using Microsoft project server.
There are many projects using a shared resource pool.

I need to create a report which shows resources which are over
utilised. e.g If Bill is utilised for 6 days in a five day week I want
Bill on my report

I am failrly useful at sql (although if you want to do this bit for me
I will not be offended!!) but I just cant find the table / columns
where the daily work breakdown is stored.

I can see that the msp_assignments table contains the resources
assigned to each task but how do I know when that resource is working
on the task?

e.g. if I have a task which lasts for 3 weeks, and a Bill works on the
task in week 1 and week 3 - where is this recorded in the database and
how is it stored?

Any help greatly appreciated!

Kind regards,

Luke.

 

[Mike Glen]

Hi Luke,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP