SharePoint Dragons

Nikander & Margriet on SharePoint

Esoteric info about retrieving content database info via the SharePoint OM

When you call the ContentDatabase property of an SPSite instance, it actually uses a composite key consisting of the web application id and the path of the site collection. Execute this SQL query in the SharePoint config db to see it:

select * from sitemapvisible

image

In the object hierarchy of the config db, things are a little different though, and it looks like this:

content db [child of] sharepoint database service instance [child of] spserver [child of] config database.

When will you be using this info? Uhm, probably never, that’s the esoteric part about it.

Advertisements

One response to “Esoteric info about retrieving content database info via the SharePoint OM

  1. washbucket December 14, 2015 at 10:45 pm

    Well…. You’d be using exactly this info when your server is giving you a cryptic error message about some invalid object in the ‘SiteMapVisible’….

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: