Skip to main content

SQL: Custom SQL Query

The Custom Query page for a Custom SQL Query contains the following configuration options. It is a wizard page for the following categories:

  • Custom MySQL Query
  • Custom PostgreSQL Query
  • Custom SQL Query
  • Custom Db2LUW Query

SQL Data Collector Wizard Custom SQL Query Page

The configurable options are:

  • Test Database:

    • Data Source – Select the host\instance from the drop-down menu
    • Database – Select the database from the drop-down menu

  • SQL Query textbox – Enter the custom SQL script

  • Validate Query – Click to test the query, results display in the box

  • Row limit – Enter a number to limit the rows the query is tested on