lukeevans
Computer
- Sep 26, 2005
- 1
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.
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.
