What default Tables are used for Proj and Sql Server

[Guest]

Good luck, Brett.....you endeavoured in a not-so-easy
task...

-----Original Message-----
I have been looking on Sql Server for some time now and

can not find all the information that I need in order to
pull the information from the Server and post it onto
Crystal Reports. I would like to know what tables are
used for MS Project Server and what fields are used for
the following. I have been looking inside Sql Server and
there are many blank tables in the Project Server
database. I already have some information I need from
tables like MSP_WEB_TRANSACTIONS, Msp_web_assignments, and
Msp_web_resources. Where do I have to look to get
information like the PRIORITY, Client, Deadline, Done
and/or tested, percent complete, and resource - task
relationships? I thank anyone who can answer this
question ahead of time.

 

[John]

I am assuming that some of your fields are enterprise custom fields. You
will need the MSP_Code_fields table and the MSP_outline_codes table. Those
were very difficult tables to understand how to use, but the key is that
each Custom Field that you have defined is given an ID number. Each number
is associated per project, so you will need to work out the SQL code to get
the right data and work back through the tables to the MSP_Projects table.

On the Project Server CD (and on Microsoft's Technet website) you can find
the Database Schemas for Project and Project Server. On the CD they are
projdb.htm and svrdb.htm. You will find a lot of help in those files.

For your percent complete and resource task relationships, I used the
MSP_resources, and MSP_tasks and msp_web_tasks and msp_projects tables and
msp_assignments tables. You'll have to work your way through the database.

I agree with with anonymous, good luck. It is a not so easy task, but
muddle through it - it is worth it in the end.