view un-processed updates

[Jesse]

I want to view all the updates submitted to the PMs....that have yet to be
processed. I know how to go into "view resource assignments" and see
timesheet detail and sift through and see the un-processed updates because
they're in a different color.

What I'd like to do is have a view where all I see is the un-processed
updates. Any ideas?

 

[Dale Howard [MVP]]

Jesse --

Try the following:

1. Navigate to the View Resource Assignments page in PWA
2. Select all resources and then click the Apply button
3. Make sure you have the Summary view selected
4. Click the Filter, Group, Search tab
5. Select the AutoFilter option
6. Click the Filter, Group, Search tab again
7. Scroll to the Status field, click the autofilter button, and select
"Changes Submitted"

The grid will show only those resources who have submitted task updates, but
whose PM's have not yet processed the updates into the Microsoft Project
plan. Hope this helps.

 

[Jesse]

Very nice! Thanks Dale
--
Jesse

Jesse --

Try the following:

1. Navigate to the View Resource Assignments page in PWA
2. Select all resources and then click the Apply button
3. Make sure you have the Summary view selected
4. Click the Filter, Group, Search tab
5. Select the AutoFilter option
6. Click the Filter, Group, Search tab again
7. Scroll to the Status field, click the autofilter button, and select
"Changes Submitted"

The grid will show only those resources who have submitted task updates, but
whose PM's have not yet processed the updates into the Microsoft Project
plan. Hope this helps.

 

[Dale Howard [MVP]]

Jesse --

You are more than welcome, my friend! You must admit that my solution was
far simpler than most people would expect.

 

[Jesse]

Dale, this works like a charm. I've found a couple challenges with the
Assignment views in PWA. It appears I cannot use a filter (to view only
Status = Changes Submitted) and I cannot list more than 100 resources at a
time. I have more than 100 resources and I'd like to only see where changes
have been submitted but updates have not been process.

Can I not do this in a PWA assignment view?

I do have read-only access to the SQL Server database that supports the
Project Server. Can I run a query against the database to get what I want?
Can you tell me what the query would be?

 

[Dale Howard [MVP]]

Jesse --

Yes, the limit of a View Resource Assignments view is 100 users. You can
create a list of up to 100 users, set up the page as you wish, and then
click the Save Link button to save this custom setup as a personal custom
view. You could repeat this process for each group of 100 users and create
several personal custom View Resource Assignments views using Saved Links.

Otherwise, if you want to do this via a SQL Server query (which would be
simpler), then please repost your question as a new message and let our SQL
experts take a swing at it. Hope this helps.

 

[Jesse]

Thanks Dale
--
Jesse

Jesse --

Yes, the limit of a View Resource Assignments view is 100 users. You can
create a list of up to 100 users, set up the page as you wish, and then
click the Save Link button to save this custom setup as a personal custom
view. You could repeat this process for each group of 100 users and create
several personal custom View Resource Assignments views using Saved Links.

Otherwise, if you want to do this via a SQL Server query (which would be
simpler), then please repost your question as a new message and let our SQL
experts take a swing at it. Hope this helps.

 

[FaisalM]

I'm working on a similar issue. Just wondering if someone posted a SQL query
on this 100 user limitation of Resource Assignment view.

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://msp.faisalmasood.com/
My Sharepoint Blog
http://sps.faisalmasood.com/

 

[Jesse]

FaisalM, this query has been working for me....

select p.proj_name, a.task_name,
r.res_name,
w.wwork_start, w.wwork_finish
from dbo.MSP_WEB_ASSIGNMENTS a, dbo.MSP_WEB_PROJECTS p,
dbo.MSP_WEB_RESOURCES r, dbo.MSP_WEB_WORK w
where a.wassn_id = w.wassn_id and
(a.wassn_actuals_pending = 1 or a.wassn_update_status = 1) and
w.wwork_update_status <> 0 and
a.wproj_id = p.wproj_id and
a.wres_id = r.wres_id and
a.wres_id_mgr = r.wres_id
order by p.wproj_id, a.task_id

 

[Pascal]

Hi,

I followed your procedure to view resources who have submitted task updates
but unfortunately I don’t have any Status field. Moreover, I looked in PWA
server settings in Manage Views and I cannot add this field to the summary
view. Why I don’t have access to it and does it have another way to know if
my resources have submitted or not their task updates. Thanks in advance.

Regards,

Pascal

 

[Dale Howard [MVP]]

Pascal --

The Status field is the last column in the Summary view on the View Resource
Assignments page in PWA in Project Server 2003. Did you navigate to the
Resource Center page, click the View Resource Assignments link in the
sidepane, select one or more resources, and then click the Apply button? In
the upper right corner, do you have the Summary view selected on the Choose
a View pick list? If so, scroll to the far right side of the table on the
left side of the View and you should see the Status field. Also, when you
attempted to edit the View, did select the Summary view in the Assignment
section? Let us know.

 

[Pascal]

First, I don't have View Resource Assignments link on the sidepanel, I just
have View Assignments on the upper menu on Resource Center page.

Second, I do select the Summary view in the Assignment section when I
manage views.

Finally, I don't have the Status field (Ressource or Assignments) even if I
tried different ways, via Project, via PWA, etc...

Do we have to create this field as custom field, maybe it's a server side
settings, I don't know...

Btw, thanks for your fast reply.

 

[Dale Howard [MVP]]

Pascal --

Well, this indicates that you have Project Server 2007. Why didn't you say
so in the first place? The directions I gave were for Project Server 2003.
In Project Server 2007, you cannot see which resources have not submitted
task updates the way you can see it in 2003. Hope this helps.

 

[Pascal]

Sorry about that, I should have sait it; but the thread doesn't mention that
it's a version related discussion.

Anyway, do you known or have a idea if it exists a procedure to known if my
employees have submitted or not their task updates with MSP 2007?

Thanks!

 

[Dale Howard [MVP]]

Pascal --

That's what I said in my last message. Right now, there is no default or
custom way to determine if team members have pending updates that they have
not yet submitted. Hope this helps.