Re: querying the content database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You need to do a join in your query to get the corresponding information
from the other table. I'm not going to write the whole query out, but
here's an example to get you pointed in the right direction. This query
matches up the CheckoutUserID column in Docs with tp_ID in the Userinfo
table:

select Docs.DirName, Docs.LeafName, Userinfo.tp_login from userinfo inner
join docs on docs.SiteID = userinfo.tp_SiteID and docs.CheckoutUserID =
userinfo.tp_ID

You'll need something like that for 6. For 7 by "team leader" do you mean
"site collection owner?" Team Leader is not a SharePoint attribute, so I'm
not sure what you're looking for.

tk
"Nancee" <Nancee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4975E4A2-47BE-4790-AB7B-84593770F5D0@xxxxxxxxxxxxxxxx
Todd,

Let me be clear on what I want,

Files /docs information required :

1. File Name
2. File Size
3. Version Count
4. File Location
5. Last modified date
6. Last modifying user name
7. Team Leader for the site

The attributes from 1 tp 5 are available in Docs table. The tough are 6
and
7. I know that UserData table has the lastmodifying userid, but to get the
last modifying username we need to refer to UserInfo table. How do I
relate
all the three tables to retrieve the above attributes in a single query.
Hope
you can help me out with this. Appreciate your reply.

Thanks,
Nan





--
Nancee


"Todd Klindt [MVP]" wrote:

Looks like I inadvertently lied to you, sorry about that. The Admin
Guide
doesn't have the database schema in it. The SDK does. Searching for
"sharepoint sdk" should bring it up. The schema is under Reference ->
Databases. The information you're looking for is in the Docs table of
the
Content databases.

tk
"Nancee" <Nancee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9B746473-910F-4A25-A8D2-D5346933E73B@xxxxxxxxxxxxxxxx
Hello Todd,

Thanks for your reply. I downloaded wss admin guide and searched the
pages
for content database table schema, I could not find any. What I want
from
the
content database is info related to file size, file name, last
modifying
user, version count, .........for the documents. I tried to query the
database but I dont get the right information. Hope this info can help
you
to
clarify my questions. Please I need this to be fixed pretty soon. I
tried
googling sharepoint pages, but of no result.
--
Nancee


"Todd Klindt [MVP]" wrote:

The database schema is laid out in the WSS Admin Guide. If you search
for
that exact phrase in your favorite Internet search engine you'll be
directed
to the download.

Tread carefully in the databases. Don't even think about changing
anything
in there. Microsoft hates that.

tk
"Nancee" <Nancee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1304B475-C99F-43BD-AF0D-7C4C0D2AC410@xxxxxxxxxxxxxxxx
Can anyone please share the schema of the content database table in
sharepoint? I am trying to fetch some parameters like last modifying
user,
team leader for the site,..... ? Can anyone help me with this?
Appreciate
your inputs
--
Nancee








.

Relevant Pages

  • Form not working properly after adding new table columns to DB
    ... I've added about 19 fields to the database, and after modifying the ... // begin the query ... // end fieldnames and begin values ...
    (alt.php)
  • Re: Using nulls in a jdbc Select
    ... > I need to do a select on a nullable column in a database where I ... > with searches that get around it, but there is no way of searching and ... > I can set the null, but then the query doesn't find the row in both the ... > I noticed that when I do the query in the MS SQL query tool, ...
    (comp.lang.java.databases)
  • DDE connection w/ Access & Word 2007
    ... I have a database that, back in the days when we used Office XP I had no ... I have a parameter query in Access that feeds a Word mail merge. ... I've done some searching and the first suggestion I came across said it was ...
    (microsoft.public.word.mailmerge.fields)
  • Using nulls in a jdbc Select
    ... I need to do a select on a nullable column in a database where I ... with searches that get around it, but there is no way of searching and ... but then the query doesn't find the row in both the ... I noticed that when I do the query in the MS SQL query tool, ...
    (comp.lang.java.databases)
  • Re: querying the content database
    ... last modifying username we need to refer to UserInfo table. ... for content database table schema, ... googling sharepoint pages, but of no result. ...
    (microsoft.public.sharepoint.windowsservices)