Exporting crawl log to CSV RRS feed

All replies

  • Using the bottom script on that blog post, try to add:

    $urls | Export-Csv c:\test.csv

    at the end. Export-Csv is a built-in powershell command to save data collections to a CSV file.

    Mikael Svenson 

    Search Enthusiast - SharePoint MVP/WCF4/ASP.Net4
    Wednesday, July 13, 2011 7:11 PM
  • Another solution is, a simple SQL query which can be pass as a Powell argument  and redirect output to CSV file easily.

     Sample SQL Query:-

    SELECT u.DocID,u.crawlid, u.accessurl, u.ContentSourceID, u.LastModifiedTime, u.LastTouchStart, u.DisplayURL, u.errorid, e.errormsg

    FROM [<Search crawl store Database>].[dbo].[MSSCrawlURL] u

        join [<Search crawl store Database>].[dbo].[MSSCrawlErrorList] e

        on u.errorid=e.errorid

    where u.errorid!=0

     Here we need to pass <Search crawl store Database Name> and data can be access from using MSSCrawlURL & MSSCrawlErrorList Tables.  Advantage is we can include columns to sql query  based on our requirements and customize SQL output .



    Friday, May 31, 2013 5:41 PM