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
 
Top