Extracting data from WSS Database

[Don]

I am runng WSS 2.0 on Windows Server 2k3

I need to extract the following data. Can someone please let me know what
tables and relationships I can use?

1. General Discussion, Shared Documents, and Announcement titles/names
2. Name of the user who created or modified the entry
3. The modified date

Thank you.

Don

[Daniel Larson (www.portalbuilder.org)]

Don,

The guidance is to NOT access the database, but to use the API. You can get
a reference to the SPWeb object, it's SPList objects, and their SPListItem
objects. I have some info on my site that may help you get started... read
the presentation I did for the Rocky Mountain SharePoint User Group. Just
about everything in the API is enumerable... so just loop through all the
lists in the web, and then loop through all their list items. You can access
the listitem metadata through it's xml property.

Daniel Larson
http://www.portalbuilder.org
http://workspaces.gotdotnet.com/portaltools

Post by Don
I am runng WSS 2.0 on Windows Server 2k3
I need to extract the following data. Can someone please let me know what
tables and relationships I can use?
1. General Discussion, Shared Documents, and Announcement titles/names
2. Name of the user who created or modified the entry
3. The modified date
Thank you.
Don