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

Posted Friday, January 6, 2012 12:55 PM by CoreyRoth

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. 

SearchResultsPercentFAST

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.

SearchResultsPercentSPO

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

PeopleSearchResultsPercentSPO

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.

Comments

# re: Quick Tip: Use % to return all items in the search index

Friday, January 6, 2012 2:13 PM by Erich Stehr

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.

# re: Quick Tip: Use % to return all items in the search index

Friday, January 6, 2012 3:10 PM by CoreyRoth

@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.

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

Tuesday, January 10, 2012 6:45 AM by Mikael Svenson

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.

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

Friday, January 13, 2012 2:29 PM by CoreyRoth

@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).  community.office365.com/.../19687.aspx

Leave a Comment

(required)
(required)
(optional)
(required)