view un-processed updates...by querying the database

[Jesse]

I'd like to have a view where all I see is the un-processed updates. Dale
Howard was nice enough to post a process to do this view in PWA (see below).

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.

I do have read-only access to the SQL Server database that supports the
Project Server. Can someone please tell me what the query would be?

==================================
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.