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.

  • 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 Oct 11 '18 at 9:33

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 = get-sptimerjob -type microsoft.office.server.search.analytics.usageanalyticsjobdefinition

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


| improve this answer | |
  • Thanks Tarun. Let me try this on my test as well as Prod environments. Will update this soon. – Arun Nov 24 '17 at 13:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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