SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I know searching the site-wide facility allows you to search the blog as well, but I am using the SP blog as a way of feeding a knowledge management system. The search facility added as a webpart on the page will search various sources (eg: bing, shared documents folder, etc), but I would also like to search the blog facility.

Is there a way of doing this?


I also realise that SP stores its data in a database and I guess I'd be able to interrogate that to obtain the blog content.

Does anyone know where the database is located? Currently I am using SharePoint Foundation locally on my machine.

share|improve this question

migrated from May 17 '11 at 16:51

This question came from our site for professional and enthusiast programmers.

I would create a search scope to manage that. A web address scope rule maybe enough,

but to be sure I would put in a property query on ContentClass or create a new search property for ContentType (the default one includes the content type/mime type of the document e.g. "application/pdf").

Use SharePointManager and the Search Service Tool until you get back the right mix of url/properties to limit your results.

share|improve this answer
thanks for that. It would be useful to follow your instruction to create a custom search from within SharePoint. BUT I wish to search SharePoint blog and shared documents from an application which is external to SharePoint itself. This is the reason I asked for guidance on the location of the SharePoint Database so that I can write a custom stored procedure to search the Blog and Shared Documents content. Does anyone know how I'd go about this? – khuzbuzz May 18 '11 at 16:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.