none
Is it possible to export the Crawl Logs, Crawl Health and Query Health reports to Excel? RRS feed

Answers

  • Or you can try 

    http://blogs.msdn.com/b/spses/archive/2011/06/22/exporting-sharepoint-2010-search-crawl-logs.aspx

    http://social.technet.microsoft.com/Forums/en-US/44fbe468-ffa0-4303-9fa6-0ac05304f205/exporting-crawl-log-to-csv?forum=fastsharepoint

    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 .


    If this helped you resolve your issue, please mark it Answered

    Monday, September 29, 2014 2:27 PM
    Moderator
  • You can export craw logs to .csv files by using powershell, which can be opened up in excel.

    http://blogs.msdn.com/b/spses/archive/2011/06/22/exporting-sharepoint-2010-search-crawl-logs.aspx


    Please mark the replies as answers if they help or unmark if not.

    Monday, September 29, 2014 2:35 PM
  • Hi all,

    You can use this to export the crawl logs.

    Monday, September 29, 2014 2:35 PM

All replies

  • Or you can try 

    http://blogs.msdn.com/b/spses/archive/2011/06/22/exporting-sharepoint-2010-search-crawl-logs.aspx

    http://social.technet.microsoft.com/Forums/en-US/44fbe468-ffa0-4303-9fa6-0ac05304f205/exporting-crawl-log-to-csv?forum=fastsharepoint

    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 .


    If this helped you resolve your issue, please mark it Answered

    Monday, September 29, 2014 2:27 PM
    Moderator
  • You can export craw logs to .csv files by using powershell, which can be opened up in excel.

    http://blogs.msdn.com/b/spses/archive/2011/06/22/exporting-sharepoint-2010-search-crawl-logs.aspx


    Please mark the replies as answers if they help or unmark if not.

    Monday, September 29, 2014 2:35 PM
  • Hi all,

    You can use this to export the crawl logs.

    Monday, September 29, 2014 2:35 PM
  • Hi Jon,

    Thanks for posting your issue, 

    SharePoint does not provide an option to export crawl logs from the Search crawl.

    The following set of queries can be executed in the database to export the list of errors from the crawl logs.

    select * from MSSCrawlErrorList with (nolock)
    This query will return the different types of error that can be generated by the search crawl. Keep a note of the ErrorID for the error that you want to export
    Example: ErrorID 692 is for “The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly.”

    select * from MSSCrawlHostList with (nolock)
    This query will return the web applications that are configured to be crawled.
    Example: HostID 2 is for the web application for which you want to export the crawl logs.

    Once you get the ErrorID and HostID from the above two queries, execute the following query to export the errors from the crawl log.

    select * from MSSCrawlURLLog with (nolock) where ErrorID = 692 and HostID = 2

    You can export the results to a text file or in a csv for further analysis.

    I hope this is helpful to you. If this works, Please mark it as Answered.

    Regards,

    Dharmendra Singh (MCPD-EA | MCTS)

    Blog : http://sharepoint-community.net/profile/DharmendraSingh

    Monday, September 29, 2014 2:41 PM