Database Location for "File Properties"

[Jim Mac]

I'm trying to locate the place in the Project Server database (2003 and 2007)
where the File Properties are kept. These are not apparent looking through
the database tables. By "file properties" I'm refering to the fields that
you see when you choose the menu option "File / Properties".
This includes, "Subject", "Author", "Category", "Keywords" as well as a
collection of Custom Properties. I know that we could migrate them all to
Enterprise Custom Fields in the future. But, for now, it would really help
if I could query these properties (particularly the Custom Properties)
directly from the database. Does anyone know where they are stored?

Thanks!

 

[CQ]

I believe most, if not all of these are in the MSP_Projects table. The
fields are
PROJ_PROP_AUTHOR
PROJ_PROP_COMPANY
PROJ_PROP_KEYWORDS
PROJ_PROP_MANAGER
PROJ_PROP_SUBJECT

 

[Jim Mac]

Thanks. By, "not exposed" do you mean that they are "hidden" inside of some
BLOB database field? If so, can I read that field and find my content?
Where does Project Server generally store Project-level information that is
"not exposed"?

 

[Gary L. Chefetz [MVP]]

Jim:

Yes in a BLOB. You'll note that this is stored in the MSP_Project table as
well. I was mistaken about these fields not being exposed in the db. They
are, but not all project properties, such as last baseline save date, are
available this way.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Sam]

Gary ,

How can we get Last baseline save date from project server 2007 db or custom
field etc. I dont se any field in reporting or published DB although we can
see it if we open a project. Can we access using a Macro in project server
environment.

Thanks

Sam

 

[Gary L. Chefetz [MVP]]

You must use the Project Object model, which means that a macro running
inside project can access it.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Sam]

Thanks Gary , I was hoping if there was a way to access this from project
server database . I just dont get it why would MS not expose this field in
the database .