|
- Database Log
- LogAnalytics allows you to analyze data from any connected database table directly via ODBC connection The connection string looks as follows
DSN=DSN_name;SQL="sql_statement" (for system DSN) or FileDSN=FileName;SQL="sql_statement" (for system FileDSN)
- DSN or FileDSN are the ODBC source names (for System and File DSNs respectively). The DSN with the name should be previously created in the ODBC administrator. See Windows Control Panel for the details.
- sql_statement means the SQL statement retrieving the data from a table (or table group). For example "select * from db" retrieves all fields from table "db" in the DSN specified.
|