I have a requirement where i have to build a full-trust solution create a report which shows most popular search results or, most frequently searched terms, further i have to show all the search terms ever searched by any user which did not yield in any results.

Has anyone ever come across this requirement?, or is it possible to do so using a full-trust SharePoint 2013 solution? if yes then what is the best possible way to do it? Or is there a direct SPQuery which can give me this?


I guess your requirements will be fulfilled by the OOB Popularity and Search Reports provide by SharePoint.

Site Setting >> Site Collection Administration >> Popularity and Search Reports


Just add your site path in front of this


enter image description here

  • hey cjs thanks for your valuable reply, but i a looking for some custom solution, i am looking for a way wherein how SharePoint is querying such data from the content db, to show it in the excel format, so that i can also use similar queries and get the required data and format it the way i want. – luckydeveloper Aug 30 '17 at 4:38

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.