Working in a multi-user enviroment (server) and somehow someone has over progressed a couple thousand activities ie...actual dates start and finish. is there any report or data log i can run or check to identify the user. Ive checked the (last modified by) but in the past ive found that is not always correct?
Not sure if this would give you your answer but there is a task_update_date and task_update_user field in the database. Here is a MSSQL query that I ran against my database. Just set the from_date variable to filter the results set.
declare @from_date varchar (10)
set @from_date = '08/01/2012'
select p.proj_short_name, CONVERT(varchar,t.update_date,101) as task_update_date, t.update_user as task_update_user, COUNT(t.update_user) as user_update_count
from dbo.TASK t
inner join dbo.PROJECT p on p.proj_id = t.proj_id
where t.update_date > convert(datetime, @from_date, 101)
group by p.proj_short_name, CONVERT(varchar,t.update_date,101), t.update_user
in my situation with so many activities being affected i was able to use this query to identify the user. but the issue i am now trying to run down is what could they have been doing to progress 21000 activies in less than an hour. it was not auto progress using the spot light tool. the user was running reports and leveling resources when he noticed the progress?? is there any other function that could progress acftivies out past the DD actual start and finish them??