XpoLog help - SQL Analyzer
 
The SQL Analyzer allows the user to execute sql queries on a log or on several logs together as if they were database tables.
When click on SQL Analyzer under tools in the menu you will see the screen of the query definitions.
 

Creating a log using the SQL Analyzer  

On the upper part of the screen you will see an option box of all the logs defined in the system and for each log you will choose you will see it's associated filters if exists.
What you need to do is to choose a log with an associated filter (if you do not wish to use a filter choose none on the filter option box) and add it to the log list.
You may choose as many logs as you want and add them to the list - each table will get a name as follows: the first log -> Table1, the second log -> Table2 and so on, these name will use you in the SQL query as the tables names you would like to execute the query upon.
Logs Query
In the Logs query text box you need to insert the query you wish to execute and click execute query to view the result.
Preview settings
In the preview settings you can define how many log lines would you like XpoLog to use when executing the query or whether you want XpoLog to use the whole log's lines.
After executing the query you can choose either to move to XpoLog's log view without saving or to save the result of the query as a new log in your system.