XpoLog help - Defining Database Queries 
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.

Defining database queries
  1. From the 'Administration' menu the 'Add log'.
  2. Click the 'Database Query' link.
  3. In the 'General' section, select the parent folder and enter the name and description of the log.
  4. 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.
  5. 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.
  6. Select the database table you want to query.
  7. 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.
  8. 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.
  9. 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.
  Additional links
      Defining database accounts
      Log View help