Analytics - Log search

Log Search allows you to locate particular queries or patterns of queries within a specified timeframe. If found, the result displays the query with statistics. The query itself is hyperlinked and lists log entry details. Refer to Logs for details on available Log types.

Locate the query by following these steps:

  1. Click on the Analytics tab. Select the time period.
  2. Select the cluster and the hour.
  3. Select a database server to view its percentage and type of query traffic.
  4. Click on a database server chart to view its SQL query details.
  5. Select a query pattern to display unique queries.
  6. Click on a unique query to open the query search screen. 

    UniqueQueryLogSearch.png
     
  7. Enter an SQL query you wish to search within the selected time period. You can change the time period in Step 9. The query appears with its details in the table below.
  8. Click on the query to see the log details associated with the query.
  9. Change the query and the time period for this pattern at the top of the screen.
    • Matching_results_found.png

Back to top

Comments

0 comments

Please sign in to leave a comment.