When you use the Command Line Query Tool (scspquery.bat or sdcssquery.bat) in SCSP, the reports or queries contain no data when they are run. With reports, you see proper formatting and borders, but there is no data.
Blank reports and queries
This is caused by incorrect permissions for the user that is trying to process the report/query via the command line. By default, the "Query Tool Users" role does not have data read permissions for assets. The "Query Tool Users" role is what the command line function runs under.
Here are two solutions to this issue: