Recently I had the request to locate all files that are bigger than 40 MB - and they were located in the entire farm across multiple Site Collections. Easy you might say? Just use search and query for size>41943040 Well, I said efficiently and thats the most efficient way - you are right! They key constraint here is that those files were excluded from search - so lets go for the PowerShell way.