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.

Quick Tip: Use % to return all items in the search index (FAST Search for SharePoint and SharePoint Online)

Ever wanted to see what exactly is in your SharePoint search index with a simple query?  Sure, you can take a look at the crawl log, but you can’t see that in SharePoint Online.  With SharePoint 2010, you can use queries using the ContentSource keyword to return everything in that content source (i.e.: Local SharePoint sites).  However, you may want to see the entire index.  Well that’s actually pretty easy.  Just use type % in the search box and submit your query.  It will return everything there is. 


This is a great way to see what is in your search index.  It can also help you find things that maybe you didn’t want indexed.  It even works with SharePoint Online as well.


What about people search?  It works there too with SharePoint Online.


However, this doesn’t work in FAST Search for SharePoint (which is just SharePoint Search when it comes to people) for me.  Even still, % is a useful operator that you can use to help troubleshoot issues with search.

UPDATE: Erich Stehr pointed out that % does not work on regular SharePoint Enterprise Search.  He is correct.  What is odd is that it does work in SharePoint Online.  That will make you think about things.  As an alternative, you can issue the query Size>=0 (no spaces) to return the entire index as well.



Erich Stehr said:

Not working for me on a SP2010 Enterprise search server, but what does is the query (size>=0).  # worked on FAST Search last time I worked on one.

January 6, 2012 2:13 PM

CoreyRoth said:

@Erich you're right % and # don't work in SharePoint 2010 but they do work in SharePoint Online and FAST.  I've updated the post.

January 6, 2012 3:10 PM

Mikael Svenson said:

I noticed "#" working in Office365 a while ago, and thought maybe they had implemented FS4SP. But so far this is not the case, so they must have upgraded the webpart code to support empty searches with oob SP search.

January 10, 2012 6:45 AM

CoreyRoth said:

@Mikael I am thinking it might have came with SU1.  The definitely cleaned some stuff up (like the removal of the FAST links in that update).

January 13, 2012 2:29 PM

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