Where is the list information stored?

M

MD

I am trying to determin how to get a raw dump of some list data... primarily
from risks and issues, but some from a couple of custom lists. Where is all
of this data? I have been looking through the SQL data and haven't seen it
yet.
 
J

James Fraser

I am trying to determin how to get a raw dump of some list data... primarily
from risks and issues, but some from a couple of custom lists. Where is all
of this data? I have been looking through the SQL data and haven't seen it
yet.
Click to expand...

These days, the version of Project Server you are using is very
helpful. This data is stored in the "UserData" tables of the
SharePoint Content database. (That tabel name is from memory, so I
might be off a little bit.)

In 2003 this is typically called WSS_Content. In 2007 it is the SSP
WSS Content database and there is no standard name for it.


James Fraser
 
M

MD

Thanks that got it.. This is an 03' installation and the data was in fact in
the UserData table... thanks so much. I wish there was a metadata table that
contained the custom field names that the site owners used... but at least we
got the raw data.

Thanks BIG bunches....

Doc
 
J

James Fraser

Thanks that got it.. This is an 03' installation and the data was in fact in
the UserData table... thanks so much. I wish there was a metadata table that
contained the custom field names that the site owners used... but at least we
got the raw data.

Thanks BIG bunches....

Doc
Click to expand...

The field names are stored in an XML string in one of the tables in
that database. Some web searches on SharePoint reporting will get you
some code that parses the xml. It may not be worth it, though, as all
sites from a single template should be similar.


James Fraser
 
Top