timesheet & update compliance from PS SQL database

J

Jesse

posted initially on Server thread...my be better fit here

I know how to identify timesheet compliance from the Resource Views. The
biggest challenge with that is I have many more resources than 100 and the
view allows only 100 resources at a time. Since I recently gained access to
the PS SQL database I'd like to query the database to attain timesheet
compliance. I'm looking for a query to return the following info. Has someone
done this?

- task name
- submitted on
- PM accept
- status
- project
- resource name
- project manager
- start
- finish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

timesheet compliance from PS SQL database 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
My Timesheet behavior 3
Project Server 2010 - Issues with Timesheet 0
query PS database to identify where task duration <> resource dura 7
Major Issue with April CU - Timesheet Deployment 9
Data Analysis views from the 3 Timesheet cubes using Customized Fi 2
query PS database for task status 0

Top