0

Whenever I pull a "Top Queries by Day" report from my SharePoint site, I am seeing a record with Query Text blank but I don't know why and from where these blank query texts are getting logged into the search log. Is there any way I can prevent blanks in the search report? See below screen: enter image description here

Update: I am using SharePoint 2013 Enterprise On Prem.

1
  • How is your custom result source showing up in reports? Number of queries report doesn't show result sources which I had created and performed search using it. Can you help me out ???
    – sukesh
    Commented Oct 11, 2018 at 9:33

1 Answer 1

3
+50

Please check the similar issue in Msdn

SharePoint 2013 search analytics reports - 'query text' column value is empty in 'top queries by month' report

1.Run the script to start the timer job:

$ua = Get-SPTimerJob -Type Microsoft.Office.Server.Search.Analytics.UsageAnalyticsJobDefinition
$ua.GetAnalysisInfo()

$ua = get-sptimerjob -type microsoft.office.server.search.analytics.usageanalyticsjobdefinition
$ua.DisableTimerJobSchedule()
$ua.StartAnalysis()
$ua.EnableTimerJobSchedule()

$ua = Get-SPTimerJob -Identity ("job-usage-log-file-import")
$ua.RunNow()
  1. Please install the SharePoint 2013 March update if our version is before this: SharePoint 2013 March update:

http://support.microsoft.com/kb/2767999

1
  • Thanks Tarun. Let me try this on my test as well as Prod environments. Will update this soon.
    – Arun
    Commented Nov 24, 2017 at 13:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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