S
sgcausey
I would like to find a way to pull timesheet data - hours worked by
month - through a SQL query. I would like to know what tables that I
will need to capture the Resource, Project, Task, date range, hours
worked. I am currently using the adjust actuals function to pull this
information, but it seems rather cumbersome and returns alot of empty
fields and takes alot of massaging in Excel to get to where I need to
be. I would like to be able to get the end result - a summary of this
information - through the SQL query. Any assistance is greatly
appreciated.
Thanks
month - through a SQL query. I would like to know what tables that I
will need to capture the Resource, Project, Task, date range, hours
worked. I am currently using the adjust actuals function to pull this
information, but it seems rather cumbersome and returns alot of empty
fields and takes alot of massaging in Excel to get to where I need to
be. I would like to be able to get the end result - a summary of this
information - through the SQL query. Any assistance is greatly
appreciated.
Thanks