This content has been marked as final. Show 3 replies
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??