07-17-2013 07:23 PM
Is it possible to see the SQL statement generated from the TRIM Search which is constructed using the HP TRIM interface.
I have constructed a Search Criteria and want to see the SQL Query which is sent to the Work Group server ?
Any assistance here is appreciated.
07-17-2013 07:54 PM
You can only do this if you're an administrator:
Click View->Activity Log Pane
Click the dataset tab
Right-click and select "Start Logging"
Execute your search
07-17-2013 08:43 PM
I am after a SQL statement which I could run from SQL Enterprise Studio and see the results.
I want to copy the results from the search criteria and send it to relevant teams.
The SQL Statement in the Activity Pane generated doesn't seem to provde with the results as seen on the TRIM Search interface.
07-17-2013 09:05 PM - edited 07-17-2013 09:08 PM
You have to sift through the generated SQL for the one searching on TSRECORD. All the rest are for other fields and such. There will be one SQL statement that is the core search.
Only other way to do it is to either use SQL Server Analyzer or turn on logging on the workgroup server. But both of these will lead you to the same core SQL statement you'd see in the activity log pane.
07-17-2013 09:06 PM