Home Categories MOSS2007 How do I find the crawl status in WSS 3.0
How do I find the crawl status in WSS 3.0
Written by Administrator   
Thursday, 15 April 2010 10:50
Once I had to check progress of my full crawl for WSS 3.0, and as there is no GUI for that as for MOSS i started to google.
Luckily for me I found perfect article how to find this one via SQL.

You can find full article here: http://blogs.technet.com/neerajr/archive/2009/08/17/how-to-find-out-the-crawl-status-in-wss-3-0.aspx

Example:
SharePoint web application URL : http://wsstest:90
WSS 3.0 Search database:  WSS_Search

1.  Query to check the last crawled URL's  for the WSS 3.0.
SELECT [DocID],[AccessURL],[DisplayURL],[DisplayHash],[LastTouchStart],[LastTouchEnd]
FROM [WSS_Search].[dbo].[MSSCrawlURL]
where DisplayURL like '%wsstest:90%'
order by LastTouchStart desc

2. Query to check the crawl error for the SharePoint site in WSS 3.0.
select msscrawlurllog.lasttouchstart as Time, msscrawlurllog.displayurl as URL,msscrawlurllog.errorid as Error, msscrawlerrorlist.errormsg as Description
from msscrawlurllog
join msscrawlerrorlist on msscrawlurllog.errorid = msscrawlerrorlist.errorid
order by msscrawlurllog.lasttouchstart

3. Query to check the how many items has crawled for the SharePoint site in WSS 3.0.
SELECT [HostID],[HostName],[SuccessCount],[ErrorCount],[WarningCount]
FROM [WSS_Search].[dbo].[MSSCrawlHostList]
where HostName like '%wsstest:90%'

4. Query to find out the crawl 'Start" and 'completed" time in WSS 3.0.
 SELECT [CrawlID],[RequestTime],[Status],[StartTime],[EndTime]
FROM [WSS_Search].[dbo].[MSSCrawlHistory]
order by starttime desc

Whole article including images you can find on original blog at: http://blogs.technet.com/neerajr/archive/2009/08/17/how-to-find-out-the-crawl-status-in-wss-3-0.aspx

Cheers KbNk;



Comments
Add New Search
+/-
Write comment
Name:
Email:
 
Website:
Title:
UBBCode:
[b] [i] [u] [url] [quote] [code] [img] 
 
 
:):grin;)8):p:roll:eek:upset:zzz:sigh:?:cry
:(:x
 
Please input the anti-spam code that you can read in the image.
Tina  - Incremental Crawl     |203.191.35.xxx |2010-08-17 14:20:35
Do you know how to run incremental crawl on WSS 3. 0?

http://www.ekhichdi.com
/Software-43.html
Reply | Quote
KbNk   |95.103.250.xxx |2010-09-16 22:30:41
I've found this on: http://blogs.msdn.com/b/syedi/ archive/2009/05/27/some-facts
-and-fallacies-about- windows-sharepoint-search-service-wss-3-0.aspx
no t sure
though

Following is the stsadm command t o start the windows SharePoint searc
h service craw l explicitly in WSS 3.0
stsadm -o spsearch -actio n fullcrawlsta
rt

The fallacy here about the Win dows SharePoint search service is that the
stsadm command says that it’s a full crawl but it trigger s only the Incrementa
l crawl. In WSS 3.0 we cannot reset the crawled content and do the full crawl a
gain. Because the full crawl happens only once whe n we configure the Windows S
harePoint search servi ce
Reply | Quote

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."