L
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.
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.