|
Many applications write their logs to databases,
allowing do utilize the database query capabilities to
investigate the logs in an more elaborate way. XpoLog can use database
tables as data sources, along with the many other data sources it can work with.
|
|
-
From the 'Administration' menu the 'Add
log'.
-
Click the 'Database Query' link.
-
In the 'General' section, select the parent
folder and enter the name and description of the log.
-
In the 'Database details' section select the
database account you want to use for this log. This account
describes the database and the connection parameters needed to
connect to it. For more details on database account definitions,
see
defining database
accounts.
Select the desired refresh rate, if any. If you want XpoLog to
automatically update the data it displays, check the 'Automatic
data update' option. If you leave this option unchecked, XpoLog
will use the latest downloaded data and will not attempt to
reload new data every time the log is accessed.
- Select the log time zone and press 'next'
for the 'Database query administration' page. If the connection of
the given database account could not be established, XpoLog will
display the appropriate error message.
- Select the database table you want to query.
-
XpoLog will automatically display the
default query (select * from tablename) and will display
the result log analysis in the lower section of the screen. If the
query is erroneous an appropriate message will be displayed. You
can now change the query as you would like, as long as it conforms
with the SQL syntax of the database of the given account, and even use more advanced syntax like aggregate functions. When finished
entering the query, press the 'verify query' link to check the validity of your
query.
-
Press the 'Show advanced Pattern Definition' to open the fields pattern section,
in which you can assign each of the table's database columns an
XpoLog column pattern. Press the 'verify patterns and query'
link to
check again your entries.
-
If the query verification was successful you
can now either save the log by clicking the 'save' link,
or go to 'Log field admin' page, where you can name the log columns
and set it for indexing prior to saving the log.
|
|
Defining database accounts
Log View help
|
|
|
|