When you get an empty CSV file that probably means that none of the datastores conform to the conditions in the Where-clause.

Judging from your description, when you leave out the Where-clause, it sounds as if you dropped the pipeline symbol ('|') at the end of the line.

The FreeSpaceGB property is a decimal, so you can't compare it to a string as "8190*" like you propose.