Exporting Data from Project Server Database

[Ris]

A couple of questions

1. Does any one know what database and table names contain the Enterprise
Custom Fields? I'm trying to create a query in Excell which will give me list
of the tasks in the active projects (I have used an Enterprise Custom Field
to specify if a project is on hold, current, planning.. etc) that are overdue
or about to be overdue for each resource.

2. Am I able to do more advanced queries through MPS views instead of using
excel?

Cheers
Ris

 

[Kevin W Flanagan]

We write ASP reports writing queries directly into the projecyserver
database. The database table changes based on the "type" of the field, i.e.
Text, Date, etc.

 

[Ris]

Hi Kevin,

Is there anywhere I can get detaild information on what fields are in the
Project Server Database tables?

 

[Kevin W Flanagan]

It is on the CD or you can search for the database schema online.

 

[Ris]

Thanks Kevin,

I downloaded the Schema online from MS website.
I'm sorry to seem so silly but I still dont know what most of the fielsd
are, 'm new to this and I certainly don't understand the DB field formats. Is
there any documentation with the fields and what they are abbreviated to ? I
must seem really silly. I'm finding it difficult to extract the information
from the correct tables when running a query in Access.

Regards
Ris