Register
Home   Ask Question Discuss Purchase Submit Events Give Solutions Share News
Automobiles Beauty & Styles Business Computers & Internet Sports Travel Consumer Electronics Education Entertainment & Music Family Society & Culture Food & Drinks Health
Computer Networking
Hardware
Internet
Programming & Design
Security
Software
Other - Computers
How to find crawl status and logs in WSS
-->

PROBLEM: How to find crawl status and logs in Windows Sharepoint Services 3.0 (WSS 3.0)


Solution:


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]
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]


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

--
Bookmark and Share
Related Posts
Comments
Add Comment
Name*
Email*
Comment*
Hot Categories: Other - Business & Finance Celebrities Tennis Cricket Programming & Design Hardware Careers & Employment Personal Finance
Contact Us About Us Privacy Policy Copyright Sitemap