I am trying to do the same thing - recreate the MS Project Server 2003 Task
Usage Report outside of MS Project. I have a SQL query that works for most
days but it seems to stop reporting correctly when I get close to the current
date. Does anyone know of a better query to use or another table that I
should be looking in?
Here is my query:
SELECT AssignmentTimeStart, SUM(AssignmentTimeCost) * 0.00016665 AS Work
FROM dbo.MSP_VIEW_PROJ_ASSN_TP_BY_DAY WHERE (ProjectUniqueID = 758) AND
(AssignmentTimeStart > CONVERT(DATETIME, '2006-02-15 00:00:00', 102)) AND
(AssignmentTimeFinish < CONVERT(DATETIME, '2006-07-26 00:00:00', 102))
GROUP BY AssignmentTimeStart
