FTR provides the following command line utilities available from the Start > All Programs > FTR menu folder.
ExecSQL
This utility provides a command line interface for running SQL statements and scripts.
Sample SQL Statement
SELECT FTRcolumn_1153, FTRcolumn_1150, TABLENAME(), RELEVANCE() AS RANK FROM C:\fultext\SPF42DATA WHERE CONTENT CONTAINS 'Intergraph' OR (FTRcolumn_1155 CONTAINS ' Intergraph') ORDER BY RANK DESC
This statement searches the FTR index for entries that contain the word Intergraph.
You can also run SQL statements from SearchServer Administrator. For information about how to use ExecSQL in SearchServer Administrator, see the SearchServer Administrator Help.
Intergraph FTR Ftrclnup
This utility removes any invalid rows in a collection. For more information, see Cleaning up Collections.