07-02-2008, 10:18 AM
|
 | EPMFAQ Founder/Owner | | Join Date: Feb 2008 Location: Quakertown, PA
Posts: 169
Thanks: 0
Thanked 13 Times in 13 Posts
| |
Quote:
Originally Posted by david.dienes  Hi All!
Where can I see in SQL database what assignments did project manager approve today?
According to my investigations, these tables couldn't answer my question:
MSP_WEB_WORK_APPROVAL - not good, because this is resource manager approval and not project manager (and completely empty).
MSP_WEB_WORK_ADJUSTED - only modifications here (adjusted actuals)
MSP_WEB_TRANSACTIONS - also seems to be only modifications
MSP_WEB_WORK - here is no time of approval.
So, I can see what changes project manager made, but what did he approve newly today?
Using Project Server 2003 and SQL 2000, scheduled work, actual work and protected actual work.
Thanks,
David |
I do not believe without snapshotting the data that there is any way to do this.
__________________ Stephen Sanderlin
Founder/Owner - EPMFAQ
Principal Consultant - MSProjectExperts If you found this message useful, please click the Thanks button in the post!
This electronic message, along with any information, advice, and opinions it contains, are mine alone and are not representative of my employer. All information is provided in "GOOD FAITH" and on an "AS IS" basis only. I provide no presentations or warranties, express or implied, including implied warranties of fitness for a particular purpose, merchantability, title, and noninfringement. I strongly advise you to extensively test any changes, workarounds, or techniques described herein on a development system prior to implementation in a production environment, and you are hereby notified that I bear no responsibility whatsoever for any loss, harm, or otherwise negative outcomes resulting from your actions, whether or not said actions were a result of this electronic message, directly or indirectly. |