|
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. |
|
|
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. |
|
In the Logs
query text box you need to insert the query you wish to execute and
click execute query to view the result. |
|
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. |
|
|