Dot Net Mafia

Group site for developer blogs dealing with (usually) Ionic, .NET, SharePoint, Office 365, Mobile Development, and other Microsoft products, as well as some discussion of general programming related concepts.

This Blog



Corey Roth [MVP]

A SharePoint MVP bringing you the latest time saving tips for Ionic, SharePoint, and Office 365.

How to: Return all items in the Search Index in SharePoint 2013

As an administrator or developer, there may be times when you really want to see everything in the search index.  It’s great for troubleshooting.  Unfortunately, the way you do this seems to vary between SharePoint versions.  I wrote on this in the past about how to do this in SharePoint 2010 with FAST Search for SharePoint using the % operator, but that no longer works in SharePoint 2013.


What can we use instead?  Now we can use the asterisk (*).  Just type it into your search box and you will see everything in the index (that you have permission to view).


Scrolling to the bottom of the page, we will see an approximation of how many search results there are.


One thing to note is that this will return all items in the current result source.  By default, that is Everything as you see highlighted below the search box.  We can just as easily return all people by clicking on the people link.


It works for conversations and videos too.


Lastly, here is videos.


Isn’t the video results page nice?

It works for on-premises search results too.  In SharePoint 2010, the percent syntax didn’t work on-premises, just in FS4SP and SharePoint Online.


Lastly, you can use this from REST as well.  Just put the asterisk (*) in your querytext parameter like you see below.



I’ve highlighted the row count in the search index. 

This is a great trick to view what is in your search index.  There are other ways of course but this one is pretty easy to get started with.  Give it a try on your SharePoint site and see what is out there today.



Blog de Juan Carlos González en Geeks.MS said:

Como cada mes, os dejo el clásico recopilatorio de enlaces interesantes que he ido recopilando. Como

November 1, 2013 10:31 AM

SharePoint 2013: Recopilatorio de enlaces interesantes (XXVI)! | Pasi??n por la tecnolog??a... said:

Pingback from  SharePoint 2013: Recopilatorio de enlaces interesantes (XXVI)! | Pasi??n por la tecnolog??a...

November 1, 2013 10:32 AM

Leave a Comment


About CoreyRoth

Corey Roth is an independent SharePoint consultant specializing in ECM, Apps, and Search.
2018 dotnetmafia.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems