Report of last update

[Andy Bruncke]

I am trying to work with our resident dbase guy to figure out a way to
generate a report of when the last time a person hit UPDATE ALL in Project
Web Access. Right now I get the email notifications when they do this, so I
know the data is there, but I think the query we are using is not accessing
the correct tables or something. Some of the data I get on an update is
correct, but some of it has dates that are really off.

Anyone familiar with the schema of project that can help out?

Here is the query we are currently using:

SELECT mr.RES_NAME, MAX(ma.WASSN_SEND_UPDATE_DATE) AS LastUpdated


FROM dbo.MSP_WEB_ASSIGNMENTS AS ma INNER JOIN



dbo.MSP_WEB_PROJECTS AS mp ON ma.WPROJ_ID =
mp.WPROJ_ID INNER JOIN



dbo.MSP_WEB_RESOURCES AS mr ON ma.WRES_ID = mr.WRES_ID



WHERE (mr.RES_NAME IN ('NAME1', 'NAME2', 'NAME3'))

group by res_name


I get a report (we put it in an xls and email it to me for convinience) that
lists the resource name, date of last update and days since that update, but
some of the dates are way old, some return NULL, even though I have an
update from them from like 2 days ago.

Anyone?

Andy