B
bugman
Greetings,
I need to get some specific data from the Project Server Database.
I have SQL Query builder and admin access to both the SQL server and
project server. I just inherited this instalation and the previous
owner made extensive, (and questionable) use of Enterprise fields. I
have a long term plan to sort things out, and if I can determine the
planned tasks for my resources, I will be able to buy some time to make
things right.
Here goes: I need to know the scheduled work, by date, for all
Enterprise resources for a specific status. The status field is defined
by the 'EnterpriseText3' field, and I just want to grab the assigned
work, for all the 'open' status projects.
Any ideas?
Thanks
I need to get some specific data from the Project Server Database.
I have SQL Query builder and admin access to both the SQL server and
project server. I just inherited this instalation and the previous
owner made extensive, (and questionable) use of Enterprise fields. I
have a long term plan to sort things out, and if I can determine the
planned tasks for my resources, I will be able to buy some time to make
things right.
Here goes: I need to know the scheduled work, by date, for all
Enterprise resources for a specific status. The status field is defined
by the 'EnterpriseText3' field, and I just want to grab the assigned
work, for all the 'open' status projects.
Any ideas?
Thanks