Logs


Logs


The Logs page on the dashboard consists of two tabs:

  • Query Log: The query log contains details about the queries that are made to your CData Connect account.
  • Audit Log: The audit log records administrative tasks, including user creation, permission changes, and more.

Query Log

The Query Logs tab displays a list of performed queries and the following information for each one:

  • Timestamp: The time when the query occurs, formatted as YYYY-MM-DD HH:MM:SS AM/PM UTC
  • Query Type: The category of the query
  • User: The login Id of the CData Connect user who makes the query
  • Status: The final state of the query; that is, whether it succeeds or fails
  • Query Text: The text and destination of the query

At the bottom of the query table, you can select the number of queries to display per page and you can navigate between pages of results.

Query Details

Clicking any query in the log expands the query and displays detailed information about it. The fields and contents can vary between queries of different types.

You can click the Logs button in a query details section to download a log file that contains details about the query. These log files are useful in troubleshooting errors that are related to issuing queries to CData Connect.

Notes:

  • You can increase or decrease the logging verbosity for a connection on the Advanced Settings page for that connection. The default verbosity is 2. See Data Sources for more information.
  • CData Connect saves log files for seven days only. Log files older than seven days are deleted automatically.

Filtering

The section above the query table enables to filter queries. By default, only Start Time and End Time are listed as filtering criteria. Click the + icon to expand the field and expose the following categories:

Filter Name Description
Start Time and End Time Displays only queries run between the selected start and end times.
Query Type(s) Displays only queries of the types that you select.
All Queries/Failed/Successful Enables you to toggle between allowing all queries or only those that fail or succeed.
Username Displays only queries that are performed by the specified user name.
Query Id(s) Display only queries that match the entered Ids.
Query Text Displays only queries that include the specified text.

Click Search to apply the selected filters to the query table.

Audit Logs

The Audit Logs tab displays a list of audit events and the following information for each event:

  • Timestamp: The time when the event occurs, formatted as YYYY-MM-DD HH:MM:SS AM/PM UTC
  • Event Type: The category of audit event
  • User: The login Id of the CData Connect user who performs the administrative task
  • Target Resource: The category and the name of the targeted resource

At the bottom of the audit table, you can select the number of entries to display per page and navigate between pages of results.

Audit Details

Clicking any entry in the audit log expands the entry and displays detailed information about it. The fields and content can vary between entries of different types. Some entries do not have any detailed information to display.

Filtering

The section above the audit log enables you to filter entries. Click the + icon to expand the field, which enables you to filter by the following categories:

  • Start Time and End Time: Displays only entries that occur between the selected start and end times.
  • Audit Event Type: Displays only entries of the types that you select.

Click Search to apply the selected filters to the query table.