I'd like to query the thunderstone appliance - specifically, the query logs for the keywords that are searched. What do I need to do this -- as I don't see the thunderstone box / db through the SQL Enterprise manager. What am I missing?
You can't query the database directly. On your appliance admin interface for a profile select "Query Log" from the left side menu. From there you can get various reports and download the log.
You might want to setup query log rotation under search settings so that the log will be emailed to you periodically.