How to retrive unsubmitted timesheet of all resource under a project

[Arun G]

Hi,

I'm new to project server 2007. I'm trying to develop a connector
between project server 2007 and .NET application.

I need to retrieve unsubimitted time sheet of all the resource for
each projects.

The results should be similar to a table with each table corresponding
to a project. The table should show the name and email id of the
resource who haven't submitted time sheet.

It would be a great help if someone could guide me on this topic

Thanks,
Arun G

 

[Jonathan Sofer [MVP]]

Hi Arun,

You would probably have better luck submitting this request to
microsoft.public.project.developer

To try to partially answer your question, you need to determine what
criteria you are using to determine which resources are missing timesheet
for a specific project. Is it for example a resource that is on the project
team (i.e. resource sheet) or is it a resource who had planned work for that
particular timesheet period.

You could then create some SQL queries in SRS to generate a report. Or you
could create as Stored Procedure and have it scheduled so that it sends out
individual reminders to the resources.

Thanks,
Jonathan Sofer